Questions tagged [disk-space]
For questions about the storage space used by databases or database objects.
379 questions
0 votes
0 answers
20 views
Mysql-Documentation mentions "null" alteration to rebuild an innodb-table. Is this feasible and effective for MariaDB as well?
I have a MariaDB of version 10.6.22-18 (Enterprise) and the disk partition bearing the DB has 98% disk utilization. Hence, I checked whether we have tables with lots of DATA_FREE, and, fortunately, I ...
- 13
0 votes
0 answers
27 views
How to update complex data structure in RocksDB?
I have been working with RocksDB for a while, and in my use case, complex data structures are stored as values in the database — for example, a Map that may itself contain nested maps. 1. Update ...
1 vote
1 answer
112 views
Non clustered index including all columns smaller than the clustered index
While messing around in SQL Server to get a better grasp on indices, I'm quite surprised to see that if I create an index (on another column than the PK) that includes all columns, it is still lighter ...
- 227
0 votes
1 answer
122 views
Is it possible to determine table disk size after vacuum full?
im using postgresql database and currently im experimenting with some vacuum/autovacuum/full vacuum stuff. As far as i know, the updated/removed rows in table still occupy space (and are only marked ...
- 103
1 vote
0 answers
34 views
Can not boot postgresql after vacuum full [duplicate]
I am running my simulations for my phd thesis and writing data to Postgres db on a local machine. Yesterday I executed vacuum full by mistake. In the morning I could not login to my Postgres db vm. It ...
- 29
0 votes
2 answers
171 views
Reclaiming space after dropping varbinary columns
I have a table of almost one million rows with two columns of datatype varbinary. These two columns store binary data that causes the database to grow to 1 TB. As this database is also restored in ...
- 1
0 votes
1 answer
32 views
Riak KV Compation error cause disk not enough space
My riak cluster have 10-node running version 2.9.8. All nodes same version. The node which named [email protected] had used about 95% space of disk. And other nodes only used less than 50% space of ...
- 3
0 votes
2 answers
135 views
SQL Server: which data file extension should be used when adding a primary file on another drive?
If I have a Windows disk with a capacity of 1T, for example, and the primary datafile (.mdf) for my database reaches the disk's maximum size, I want to add a second datafile to the primary group. As ...
- 1
0 votes
1 answer
197 views
When should sp_spaceused be used to get the size of a database, instead of querying sys.database_files?
I frequently find the output of sp_spaceused misleading. What appears to be the size of all data in a database is actually the combined size of both the data file and the log file. I have recently ...
- 1,360
0 votes
0 answers
60 views
Postgresql database went from 56 Gb to 185 using one query
we are using Pgadmin 15 to manage our database and yesterday, we launched a basic sql query. I waited for 10 min and the result was a bit strange. I got the message "sql state : 53100" which ...
2 votes
5 answers
914 views
Investigate why SQL Log file increased in size
We had one or more of our log files increase in size over night, causing our SQL logs disk to almost fill up. I've been asked to look at what could have caused this. Can anyone suggest where to start ...
- 61
1 vote
0 answers
21 views
PG: How to release disk space after truncating string columns [duplicate]
select version() PostgreSQL 15.3 (Ubuntu 20.04) on x86_64-pc-linux-gnu 64-bit We have an application that stores big jsons in result TEXTFIELD. Data inside this column looks like this: {"data&...
0 votes
1 answer
62 views
Why do updates to table increase the relation size?
In my Postgres database have a large table execution_transcripts with several columns. Two of those columns, task and result are JSONB columns holding values that are often in the kilobytes range and ...
- 103
0 votes
2 answers
104 views
Is FILEPROPERTY only used for database_files dmv?
I'm trying to mix some queries I created in the past, and some that I stole over the network to give me mount points size and free space together with database size and free space of the files. Only ...
- 7,558
2 votes
2 answers
1k views
How much extra disk space should a postgresql server have?
Suppose you have a PostgreSQL database of total size X hosted on a local server (i.e. expanding disk space in an emergency is difficult). How much space should the server actually be allocated to be ...
- 121