Re: [GENERAL] Feature: vacuum page before write

2011-02-06 Thread Radosław Smogura
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

[GENERAL] Feature: vacuum page before write

2011-02-04 Thread pasman pasmański
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),