Questions tagged [disk-space]
For questions about the storage space used by databases or database objects.
378 questions
0
votes
0
answers
17
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
108
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
113
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
169
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
130
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
182
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,248
0
votes
0
answers
59
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
851
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
59
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
103
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,548
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
0
votes
0
answers
934
views
Upon PC restart, MySQL service on local computer "started and then stopped"
I'm working in MySQL on a local (Windows) computer. I have a somewhat recurring issue I have with managing the server. I cannot replicate this error because I do not know what causes it.
Sometimes, I'...
- 1