Questions tagged [database-size]
The database-size tag has no summary.
154 questions
1
vote
0
answers
34
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 ...
3
votes
1
answer
226
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,322
0
votes
2
answers
309
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
1
vote
1
answer
416
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
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
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
597
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
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
0
votes
1
answer
332
views
Issue with table size after upgrading to MySQL 8
I have two MySQL servers. One is running on 5.7.24 and other one is running on 8.0.29 version.
In 5.7.24 I have table with 71M (millions) records and its size is about 6GB. The same table on 8.0.29 ...
- 123
0
votes
1
answer
394
views
PostgreSQL DB size estimation
We are doing POC for DB selection. Based on our use case we got three recommendation
Postgres
Cassandra
Azure SQL
We are not going with Cassandra since we are not matching minimum requirements and ...
0
votes
2
answers
3k
views
How to reduce the size of a SQL Server-Database?
Context
We have a Backup DB, where we normally store BackUps of tables from production DB before doing any updates/deletes. If anything goes wrong, we can restore the data from that table created in ...
- 1
0
votes
0
answers
364
views
varbinary(max) - table size
I have an application database (not of my design) with a table for storing files in a varbinary(max) column. These databases show to take up 2X the actually required space (i.e. shrink shows give/take ...
0
votes
1
answer
2k
views
Oracle XE 18c database size limitation
According to official Oracle documentation available at https://www.oracle.com/database/technologies/appdev/xe/faq.html it has limitations:
What are the resource limits for Oracle Database XE Oracle ...
- 101
1
vote
1
answer
803
views
Database is 300 GB, but I only see small tables?
I wonder why my database is so large. I type:
SELECT pg_size_pretty(pg_database_size('defaultdb'));
and it says defaultdb is 259 GB. That is huge.
So I list my tables in psql with:
\dt
For each ...
- 113
3
votes
2
answers
2k
views
Free some space on a full Express Edition instance
Using Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Express Edition (64-bit)
I have a database that reaches the maximum space (10Gb) every month.
In order to free up some space I do a bacpac, ...
- 33
2
votes
0
answers
113
views
How do I measure the overhead of a Postgres extended statistics object?
Some solutions to poor query performance suggest creating extended statistics objects to help the query planner better understand the shape of the data. Because these statistics objects are not ...
- 163
6
votes
2
answers
2k
views
Identifying Unused Indexes on SQL Azure
I have a large SQL Azure database (P6 nearing 1TB in size). I want to do a cleanup/removal of any unused indexes. For the past 30 days, we've captured the 2 following sets of information.
See: https://...
- 201
0
votes
2
answers
760
views
Analyse differential backup to see why it is so big
We quickly have very big diff files. Although the database is a highly transactional database, there is also a lot of data at rest.
1 or 2 days after a full backup was taken, the diff backup is bigger ...
- 573
2
votes
0
answers
754
views
Sql Server Express edition - Could not allocate space for object [Table] in database [DB] because the 'PRIMARY' filegroup is full
I have reached the Sql Server Express edition limit of 10 Go of space per database and for every new INSERT I have this error :
2020-08-10 14:21:58.75 spid67 Could not allocate space for object [Table]...
- 121
2
votes
2
answers
3k
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,
...
- 123
1
vote
2
answers
897
views
Very large table makes the application performance too slow
We have an old application that has problems with performance. I narrow it down to few spots in the system that definitely require attention.
I found one table referenced in this app with 1,332,730,...
- 111
2
votes
1
answer
1k
views
postgresql logical replication -- subscriber size discrepancy
I have a postgres 11 database in Amazon RDS with a little over 2 TB data in it whose tables have incrementing integer ids that are nearing exhaustion. I've been vetting using logical replication to ...
- 23
1
vote
1
answer
35
views
In place upgrade from Express 2005 SP 4 to Express 2014, does database size limitation follow?
We are currently attempting get around a file size limitation issue with our database. The database file size hovers around the 4GB mark (the database size limit is 4GB in SQL Express 2005). We always ...
4
votes
2
answers
3k
views
SQL Server table with 4,000,000 rows is 40GB
I have been trying to figure out why our production database has grown so much recently and have found the cause to be an audit table. We are going to archive the table to fix the problem but I just ...
- 175
2
votes
2
answers
1k
views
Why is my SQL Server database file so large?
I have a relatively simple database that is over 300MB on disk. When I look at the table data it adds up to just over 5MB. Please see the screenshot below:
This screenshot can also be seen here.
If ...
- 129