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 Saturday 05 February 2011 04:29:37
> Hi.
> I propose new feature.
> Before flushing pag
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),