I prefer on demand solution, as it reduces latency and I can order vaccum at night, when I have free CPU resources. At least auto vaccum on flush should be configurable. Kind regards, Radek pasman pasmaÅski <pasman.p@xxxxxxxxx> Saturday 05 February 2011 04:29:37 > 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
