Feature: vacuum page before write - Mailing list pgsql-general

From pasman pasmański
Subject Feature: vacuum page before write
Date
Msg-id AANLkTimeJQ609A2ZxS+umEPSfqaBGin-hJkHwJ_B1pXr@mail.gmail.com
Whole thread Raw
Responses Re: Feature: vacuum page before write
List 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

pgsql-general by date:

Previous
From: Bill Thoen
Date:
Subject: Directing Partitioned Table Searches
Next
From: gargdevender74
Date:
Subject: unable to publish layer