Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

New answers tagged

0 votes

Database size is far larger than sum of tables, even after VACUUM FULL?

Turns out you didn't account for other schemas. Most importantly _timescaledb_internal, which is used by Timescale to store table partitions ("chunks" in Timescale parlance). You then asked: ...
Erwin Brandstetter's user avatar
1 vote

Database size is far larger than sum of tables, even after VACUUM FULL?

Further to Adrian Klaver's comment about the public schema, the solution is to find the size taken up by tables from all of the schemas, not just the public one. Run this script: DO $$ DECLARE ...
Datguy's user avatar
  • 11
3 votes
Accepted

Why there is huge gap between allocated and used size in a database

Remember that database's data and log files are kind of containers with pre-allocated disk space, and if your data file is 365 GB and data inside it is 730 MB then it means the data file is over 99% ...
Aleksey Vitsko's user avatar

Top 50 recent answers are included