Feature: vacuum page before write

From: pasman pasmański <pasman(dot)p(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Feature: vacuum page before write
Date: 2011-02-05 03:29:37
Message-ID: AANLkTimeJQ609A2ZxS+umEPSfqaBGin-hJkHwJ_B1pXr@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
------------
pasman

Responses

Browse pgsql-general by date

  From Date Subject
Next Message gargdevender74 2011-02-05 11:36:25 unable to publish layer
Previous Message Bill Thoen 2011-02-05 00:35:10 Directing Partitioned Table Searches