On 12/01/2010 2:00 AM, Leonardo M. Ramé wrote:
A customer of mine asked me to periodically delete old, unneeded records containing ByteA fields, because he think it will reduce the database size on disk. Is this true?. For example, in Firebird, the database size is not reduced until you do a Backup-Restore of the database.
It won't shrink it unless you do a VACUUM FULL or CLUSTER, but it *will* prevent growth or (if you're adding more data than you're deleting) reduce the rate of growth.
Make sure autovacuum is running and (for pre-8.4 databases) your free space map settings are sufficient.
-- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
