Questions tagged [disk-space]

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

Filter by
Sorted by
Tagged with
0
votes
2answers
42 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
16 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 /...
0
votes
1answer
31 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
15 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
24 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
36 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
37 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
927 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
43 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
votes
2answers
39 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
33 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
91 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
16 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
0answers
40 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
53 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
31 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
162 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
327 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
17 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
56 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
77 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
217 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
136 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
46 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
110 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
436 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
500 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
208 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
78 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
67 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
524 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
104 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
444 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
74 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
350 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
48 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
122 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
votes
2answers
322 views

Move database files from one drive to another

I am running out of space in the C drive. I have plenty in the D or E drive. How to I move database data from drive C to D or E?
0
votes
1answer
17 views

How to delete all rows in a Greenplum row oriented table

In Greenplum, what is the best practice to delete all rows from a table? DELETE FROM TABLE or TRUNCATE TABLE? I dont have any child tables or foreign key constraints.
1
vote
1answer
461 views

How to manage disk space allocation for materialized views?

Summary: I have materialized views in oracle 11g that seem to hog disk space, unlike normal tables that mark rows as deleted and stats eventually show them as free space (allocated to the table, ...
0
votes
1answer
34 views

Is there a way to determine what caused the last growth operation of my database (MDF file)? [duplicate]

If I don't already have any logging in place, is there any way to use the DMVs or anything else on SQL Server to determine which query / event caused my database's last grow operation?
0
votes
1answer
153 views

autogrowth set higher than available disk

First all our autogrow settings are either turned off or the file size is set to the max autogrow size. I guess same difference as I came in after the setup. Although I've never had this problem, I'...
0
votes
5answers
353 views

Restore DB Backup with limited amount of disk space

I want to restore a SQL Server database using a backup (.bak) of about 60GB. Is it possible to do this on a machine with only 100GB of free disk space? Or do I need at least the 60GB for the .bak ...
2
votes
2answers
41 views

SQL Server Table Reports Disk Usage 0 Rows but reserved 46 GBs

I've executed report on database "Disk Usage by Table" And I have couple of weird tables, where there are no rows, but disk used couple dozens of gigabytes. What caused such behavior? What to do with ...
2
votes
1answer
249 views

Postgres: Why does pg_stat_get_dead_tuples return 0 when there is still wasted space?

Using Postgres 11.1, I have been trying to determine/estimate the amount of 'wasted' space in a table that would be recovered by a VACUUM FULL. My plan was to use pg_stat_get_live_tuples (L), ...
0
votes
1answer
563 views

How to find total used and remaining space in Azure SQL mi

I queried sp_databases and the sum of space occupied by all db's was 380Gb. The total allocated space for the managed instance is 800Gb. But, enquiring with the infra team found that we have only ...
0
votes
2answers
33 views

Mysql - tablename.ibd file is huge in size

I'm using MySQL 5.6 and innodb file per table has been enabled. I noticed that one file named as tablename.ibd is 211GB, then query the information schema there it's showing 21GB. I have done a huge ...
0
votes
3answers
458 views

AlwaysOn High Availability MDF and LDF file locations

We have 4 replicas with 03 replica in read only mode with manual failover. We have some drive issues and we need to rearrange the MDF and LDF files. On the primary we have 2 drives I and J. The I ...
8
votes
1answer
1k views

Disk usage of integer column vs boolean column in Postgres

I saw this question Bit vs. Boolean columns. I'm asking myself the same for Postgres: does a single digit integer column occupy the same disk space of a boolean one? In big tables (~50 columns x ~50 ...
1
vote
1answer
368 views

Is it safe to stop the shrinking of MSDB?

In a production server (Microsoft SQL Server 2014), the file MSDBData.mdf ballooned up to more than 450 GB, eating almost all the space in the server (only 38 GB remaining). First thing, I created ...

1
2 3 4 5
7