From: | Radosław Smogura <rsmogura(at)softperience(dot)eu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | pasman pasmański <pasman(dot)p(at)gmail(dot)com> |
Subject: | Re: Feature: vacuum page before write |
Date: | 2011-02-06 15:20:42 |
Message-ID: | 201102061620.42688.rsmogura@softperience.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)p(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2011-02-06 15:54:57 | Re: Looking for Suggestion on Learning |
Previous Message | Herouth Maoz | 2011-02-06 15:07:14 | What's canceling autovacuum tasks? |