Questions tagged [disk-space]

For questions about the storage space used by databases or database objects.

Filter by
Sorted by
Tagged with
0
votes
0answers
67 views

SQL Server 2014 - Disk Space Issue

Currently we have a drive on your server that stores all user DB's data files along with one tempdb data file. (D: drive) It has 1.4 TB total space with only 98Gigs free space. The biggest DB size is ...
0
votes
2answers
72 views

Free disk space on SQL without impacting application

We have 1 TB disk which is almost full(85%). We're going to free up disk space without any impact on application availability with below approach. Please suggest if this approach looks good or there ...
0
votes
1answer
60 views

How to reduce big size database files (Data File ) SQL Server without SHRINK?

I found a couple of 'question' regarding shrinking big datafiles but I think that is not very accurate to my situation. So here is my question I have a big database with almost 8TB of Data File Size ...
2
votes
2answers
291 views

Reduce the size of a primary key Index

I'm using Azure SQL DB and noticed that one of my largest databases appears to have a primary key index with a total size of 6Gb. It's a clustered index on a uniqueidentifier. However, the total rows ...
6
votes
2answers
513 views

Is there a performance or storage space advantage to lowering time/timestamp precision in PostgreSQL?

PostgreSQL allows time/timestamp to specify a precision: time, timestamp, and interval accept an optional precision value p which specifies the number of fractional digits retained in the seconds ...
1
vote
0answers
47 views

Does a fragmented database cause the transaction log to grow faster?

Hoping to get some clarity here as I've reached the limits of my SQL knowledge. The company I work for sells products storing data in Microsoft SQL Server databases, but our focus isn't really on the ...
0
votes
1answer
17 views

Limit size of WAL files for PostgreSQL database

I'm using AWS RDS PostgreSQL 13 database in a master-slave configuration using logical replication with pglogical extension. Recently, one of the application migrations has updated the schema of the ...
0
votes
0answers
15 views

Are these files safe to delete?

Over the weekend my postgres 12 database ran out of space while I was trying to "vaccum full" a large table. Someone, not a postgresql expert, tried to "help out" by deleting some ...
0
votes
1answer
53 views

SQL Server data drive (.mdf files) running out of space

We have a D drive that has 999 GB of total space. Currently the production database data files are being stored there. It is running out of space. A few weeks ago DB files were shrunk to temporarily ...
0
votes
3answers
72 views

RMAN configuration suggestions to help save our storage space?

To preface... Our Senior Oracle DBA has just recently passed away, and I've been taking over. My level of experience is just a junior level. So there is a lot I still don't understand. So I appreciate ...
0
votes
1answer
17 views

Estimate Oracle tablespace required before loading data

I have files ranging from 450 to 750 million rows, which I need to load into our Oracle environment. The DBA asked me to give an estimate on how much tablespace I would need. How to estimate the ...
0
votes
2answers
46 views

Which Oracle directory takes up the most space and why?

Does any directory file in Oracle occupy the most space? Why does it takes up the most? e.g. system
0
votes
0answers
46 views

Store Elasticsearch shards in separate partitions on data node

I have an Elasticsearch cluster configured with one head node and three data nodes with the number of replicas set to 2. The data nodes are each split into three partitions called /data1 /data2 and /...
1
vote
1answer
149 views

Disk space requirement for REINDEX in Postgresql

There is a server with postres 13 running out of disk space. It contains a table metrics that occupies 90% of the entire database. I have deleted old records in this table. Due to this table is used ...
0
votes
1answer
17 views

How to add a volume to current in use MySQL database

related to the problem I faced here No space left on device, I want to adopt a long term solution about the point no space left on device. One of the action includes to add a volume to the machine in ...
0
votes
1answer
29 views

Properly delete data forever and free up the space it was using? [duplicate]

I've been having issues finding a real answer to this question as the response is always "Don't do this, it's a bad idea, that space was obviously needed and it will just get used up again in ...
0
votes
1answer
44 views

mysql: ERROR 1040 (HY000): Too many connections and can't restart because of Error: 28 (No space left on device) [closed]

My app crashes because there are too many connections open and mysql does not make me log in as root showing the same problem. After restarting mysql, it does not restart because of no space on disk
2
votes
1answer
43 views

Oracle: Decreasing PCTFREE on large table

Question about Oracle Database Enterprise Edition version 19.10.0.0.0 running as a standalone instance. I have a table with billions of rows. The table has always had PCTFREE set to 10. It turns out ...
5
votes
3answers
993 views

Size Requirement of SQL Database

I have been asked this question in an interview that how much would be the DB size for a standalone SQL server if 650MB of data is processed every month. I couldn't give any answer to this question in ...
0
votes
1answer
47 views

DB autogrowth issue

I have a database that will growth in 1 month time the autogrowth was set to 500MB but as I monitored it, the consumption is 1GB+ per day. Should I wait for it to auto grow or is it better to set the ...
1
vote
1answer
30 views

Pointing the database secondary data file towards a network drive

I have a 2 TB database and the Data Drive has filled up. My network team cannot expand the drive nor provide another drive so that the secondary data file can be pointed towards that. My question is ...
-1
votes
2answers
42 views

Factorising out repeating data and replacing it with an integer key

I have noticed in my SQLite database that some tables contain columns where many rows usually repeat the same data. Transaction key from_account_key to_account_key timestamp amount data_type data ...
0
votes
1answer
34 views

Disk space efficient foreign key index for insert intensive scientific database?

I'm working tuning a scientific database whose associated simulation is very insert intensive (i.e., run for a long time inserting data, execute summary query at the end). One of the tables is ...
0
votes
1answer
475 views

Drop tables but space not claimed in postgres 12

I have upgraded Postgresql 9.5 to Postgresql 12.4 a few days back using pg_upgrade utility with link (-k) option. So basically I am having two data directories i.e. One is old data directory (v9.5) ...
0
votes
0answers
29 views

Inspect size of Postgres database and storage space usage on a DigitalOcean managed database instance

On an instance of a managed Postgres database system on DigitalOcean.com, I have a limit of 10 gigs of storage space. How can I tell how much space my Postgres instance is using? How can I tell what ...
0
votes
1answer
62 views

Free Drive Space and SQL Server Agent Alerts

I need to receive an email when free drive space on E: or H: becomes less than 20% I know that can be achieved by setting up a job that executes PowerShell or T-SQL scripts on a schedule, that checks ...
0
votes
0answers
41 views

64k disk cluster size and vSAN [duplicate]

It's time to ask again this popular question: "Is it still valuable for the I/O performance to manage disk cluster size?" But this time I'm interested in a case with vSAN as storage. I've ...
0
votes
1answer
132 views

How can I tell if TempDb is too big?

Let's say that someone wants to follow sage advice and properly setup TempDb and TempDb's log. But let's also say that the chosen sizes are almost certainly too big/aggressive. E.g. pretend we've got ...
1
vote
1answer
75 views

MySQL INFORMATION_SCHEMA.TABLES not adding to file size

I have a file for a table which has grown very large. I expected to have a large amount of unallocated space needing to be optimized, but when checking INFORMATION_SCHEMA.TABLES, there is little ...
3
votes
2answers
305 views

Monitoring for and dealing with sudden jump in TOAST bloat

I'm trying to diagnose a sudden jump in disk usage in one of my databases (running 11.4). Typically the database grows by ~1 GB per day, but recently in the span of 24h it grew by nearly 100 GB. ...
3
votes
1answer
624 views

Postgresql: Refreshing materialized view fails with "No space left on device" and a huge spike in disk usage

I have a materialized view that refreshes every five minutes. The SQL aggregates the data among many tables with over 800k rows in each. However, the when using the "REFRESH MATERIALIZED VIEW ...
0
votes
1answer
23 views

Create partial index with single value

I have PostgreSQL 12 DB with a table with a several columns, two of them are a bigint ("numCol") and a boolean ("boolCol"). numCol can have any integer number, and 0 is about 0.1%-...
2
votes
2answers
67 views

How to determine or predict space on disk per table row?

I'm very new to Postgres so my math could be off here ... This is my table: CREATE TABLE audit ( id BIGSERIAL PRIMARY KEY, content_id VARCHAR (50) NULL, type VARCHAR (100) NOT NULL, ...
2
votes
1answer
137 views

Reducing table size bytes per row in a simple PostgreSQL database

I have a pretty simple 3 column table in postgresql 11. It's timeseries data and the table can contain many billions of rows. I'm concerned about my table size and total size, and want to optimize my ...
0
votes
1answer
407 views

MySQL: My table size using a query does not match the IBD's file size on disk

I have a table with about 600 million rows. I ran the following commands and noticed select table_schema "DB name (table_schema)", -> sum((data_length+index_length)/1024/1024/1024) AS "DB ...
1
vote
1answer
202 views

How to measure amount of MySQL 8 INNODB table used to store blobs?

I'm trying to understand a discrepancy in the file size on disk of my tables and the size of the information stored in them. I'm using MySQL 8 hosted on RDS (InnoDB, one file per table), so getting ...
0
votes
1answer
79 views

Why is my primary key a separate relation taking up storage?

I have a table with a primary key. Postgres automatically created an index on this primary key, and it is separately taking up +34% more storage. Why does Postgres not simply keep the table sorted by ...
0
votes
1answer
174 views

optimizing or estimating postgresql table size on disk

This question is in the context of the helpcovid GPLv3+ project (work in progress in March 2020). With PostgreSQL 11 on Debian/Buster/x86-64. See the file hcv_database.cc there. I have a table of web ...
4
votes
2answers
443 views

Running out of disk space, start saving new data to different disk

I'm currently at around 7 billion rows on one table and approaching the max disk space for the entire database. I need to start saving new data on the one large table to a new disk. I've looked at ...
-1
votes
1answer
786 views

'PRIMARY' filegroup is full [closed]

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 ...
3
votes
2answers
215 views

How do I use the smallest amount database file space to rebuild an index on Mircosoft SQL Server Express due to the 10GB limit

How do I use the smallest amount of database file space to rebuild an index on Mircosoft SQL Server Express due to the 10GB limit I have a database file size of 7GB but I have two indexes that are on ...
0
votes
1answer
138 views

How to have PostgreSQL running forever with constant insert and delete per day

Question: Lots of rows are getting inserted every second. Batch deletion is performed when the disk is close to full. This causes two problems: It is impossible to examine actually how much space in ...
1
vote
1answer
69 views

Is it better to add a data file or better to increase the existing files (MAXSIZE)

I'm quite familiar with SQL-Server as a developer but not so much in the DBA role. Currently I'm working on a rather large DB (~7TB, living in 7 files, all equal in size and all within one single ...
1
vote
1answer
774 views

minimum space is required on disk to restore a backup in SQl Server?

Suppose I am going to restore a backup (2 GB) in my sql server, I have sufficient space (20 GB) in my disk, but is there any algorithm that SQL server follows to calculate the minimum disk space ...
2
votes
2answers
157 views

With multiple files in a file group, when does data start being placed on the 2nd file in the filegroup?

In a previous question, it was suggested that I should add an extra "File" to my existing (Primary) Filegroup to easily add more disk space for my DB. So I did that and nothing broke. But I'm not ...
2
votes
2answers
557 views

MS SQL running out of Disk Space - can FileGroups be used to free up some space?

Problem We have a Sql Server 2014 with a 1TB attached disk (on Azure) that's running out of disk space. We have about 20GB's left (maybe a few weeks of space). As such, we need to move some data off ...
1
vote
2answers
102 views

Add data directory on PostgreSQL 10

I have a postgresql database on / root partition (61GB used out of 63GB), so I asked the VPS provider to add more disk (50GB to /mnt/vdb1) How to add another data directory to that new partition (...
0
votes
1answer
541 views

MongoDB deleted logs

So I recently realized my /var directory was growing but couldn't find anything using du, then find out about lsof and found the following: lsof -nP | grep '(deleted)' mongod 23184 23205 ...
0
votes
1answer
59 views

Auto-Shrinking All Databases Files To Their Minimum Size In Sql Server

I restore my all databases in production to my development environment monthly. Development server has 4 TB disk space and there are 4 different instances over it which containt databases on the ...
0
votes
3answers
128 views

SQL Server Space Reclaim

We have a sizeable SQL Server 2016 database (running on Windows 2016 Datacenter). A table was growing exponentially due to a bad SQL process. The bad SQL process has been resolved, but the specific ...

1
2 3 4 5
7