Questions tagged [database-size]
The database-size tag has no summary.
154 questions
1
vote
2
answers
100
views
MSSQL Performance gain when clearing out (large size) filestore-table records?
On MSSQL (our DB size is 520g), there is one filestore table that holds tons of files. 65-70% of this 520g is sitting in there. So essentially, it's a 200g database with 320g worth of files in this ...
0
votes
1
answer
198
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,362
3
votes
1
answer
228
views
Does rebuilding a clustered index offline require extra space for each non-clustered index?
I have an uncompressed clustered primary key. It consumes 63.6 GB in the main part of the clustered index with 17.9 GB LOB. The table's only non-clustered index is 57.3 GB also with 17.9 GB LOB. I ...
- 1,362
0
votes
1
answer
51
views
What is a viable low-cost DR option for a large cluster?
We have a Cassandra cluster running on GKE with a 32-CPU node pool and SSD disks. The current cluster size is nearly 1 PB, with each node utilizing an average of 5 TB on 10 TB allocated SSD disks. The ...
- 39
0
votes
2
answers
311
views
Database size is far larger than sum of tables, even after VACUUM FULL?
Here is my query and its output in psql, run as an admin on that database.
There is a massive discrepancy between the 'total size of the database' at 50GB, and the sum of the tables, ~7MB.
This is ...
- 11
2
votes
1
answer
734
views
Why there is huge gap between allocated and used size in a database
I want to find total used and remaining space for each database in Azure SQL MI.
For that, from an example, when I right click on a database and select properties I see following example output, where ...
- 147
1
vote
1
answer
428
views
how to find out the free space inside a database file when the database is not online?
Normally when the database is online
I use the following query and get how much space is free inside each file:
SELECT CONVERT (decimal(12,2) ,
(CONVERT(...
- 17.3k
0
votes
1
answer
154
views
Can a postgres autovacuum increase the TOAST size of the table?
A table toast size goes from 7.5Go to 9.2Go in one hour. The normal database activity seems not responsible for that: no more queries than usual. To be the cause, it would need a larger amount of ...
- 291
2
votes
1
answer
117
views
Why is my composite index on 3 int columns smaller than the PK index on 1 int column?
I have a table called data_table. Below are schema, indexes, and their sizes.
Table "public.data_table"
Column | Type | ...
- 21
0
votes
1
answer
156
views
Create DB: Initial Size vs Max Size
In SQL Server, when creating a database we can specify the (initial) SIZE and the MAX_SIZE. I don't understand the difference.
When I create the database, it's empty. So it's size is zero.
Therefore, ...
- 121
1
vote
1
answer
1k
views
How to find whole cluster size in PostgreSQL?
I know how to find relation and database size using pg_total_relation_size(), and pg_database_size(). But I want to find whole cluster size. Is there a way other than calculating disk space of data ...
0
votes
1
answer
139
views
How to add information about two same named databases on different hosts in PgBouncer config file?
I want to add details for databases in a config file of pgbouncer.
I have two same database names but their hosts are different, as there is no information about server endpoints in the config file, ...
0
votes
1
answer
600
views
How difficult and how much time should it take to export a DB to a flat file?
How difficult of a process is it to export a database to a flat-file? Should it take seconds, minutes, hours, or days to complete an export?
I have no knowledge of the database structure, beyond the ...
- 11
0
votes
0
answers
183
views
Better way to store stock levels for products?
I currently have 3 tables: locations, products, and stock, which are pretty self-explanatory:
The fields of stock are location_id, product_id, and quantity, which is great... until I add a new ...
- 131
0
votes
0
answers
1k
views
PostgreSQL Database Data and Log size
I am looking for a way to list PostgreSQL Database Data and Log sizes.
Using the following command we can check the total database size based on the documentation https://pgpedia.info/p/...
- 170