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.
the space occupied by deleted tuples will available for reuse after they are vacuumed... so it might not shrink the database but it will help keep the database from growing.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general