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 <pasma...@gmail.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general