Hi. I propose new feature. Before flushing page of table to disk it may be scanned to reclaim deleted rows. And assigned as partially vacuumed or vacuumed. It may reduce bloat in frequently updated tables and make normal (auto)vacuum faster. Additional scan adds overhead to cpu (for update/delete), but seq scan will be faster and disk io usage will be lower. I don't know what is happen when a index entry points to reclaimed row.
-- ------------ pasman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
