Hello All,
I need a reliable way to determine the overall size of our database.
Recently, I started using the database_size() function from the dbsize
contrib.
Everything seems to work great until I need to delete records.
After I DELETE records, the pg_autovacuum daemon kicks in an runs a VACUUM.
Once the VACUUM finishes, I run database_size() again and the size does not
decrease.
I would expect the database size to decrease after the VACUUM.
I also don't want to run a VACUUM FULL because this kills the performance
of the system.
Do I have any other alternatives to determine the database size reliably
after a DELETE
and a VACUUM?
Note that I have also experimented with reltuples which does not give me
accurate results
either unless I run two VACUUMS in a row.
Please help.
Thank you,
Mike Samson
Senior Software Engineer
APC
