Re: Autovacuum in the backend - Mailing list pgsql-hackers

From Russell Smith
Subject Re: Autovacuum in the backend
Date
Msg-id 200506171901.16148.mr-russ@pws.com.au
Whole thread Raw
In response to Re: Autovacuum in the backend  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Autovacuum in the backend
List pgsql-hackers
> Added to TODO:
> 
>  * Create a bitmap of pages that need vacuuming
>  
>    Instead of sequentially scanning the entire table, have the background
>    writer or some other process record pages that have expired rows, then
>    VACUUM can look at just those pages rather than the entire table.  In
>    the event of a system crash, the bitmap would probably be invalidated.
> 
Further to this, is there any use case for allowing FSM, or this DSM to spill to disk
if the space fills up.  It would allow the possibility of unusual changes to the db
to not loose space.  You could just load part of the overflow from the disk back
int the FSM in memory and continue using free space.

Regards

Russell Smith


pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Utility database (Was: RE: Autovacuum in the backend)
Next
From: Russell Smith
Date:
Subject: Re: Autovacuum in the backend