Re: Decent VACUUM (was: Buglist) - Mailing list pgsql-general

From Manfred Koizar
Subject Re: Decent VACUUM (was: Buglist)
Date
Msg-id r4eakv03lngq465gsvipehduvcuiae6dh5@4ax.com
Whole thread Raw
In response to Re: Buglist  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Responses Re: Decent VACUUM (was: Buglist)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] Decent VACUUM (was: Buglist)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
[ still brainstorming ... ]

On Thu, 21 Aug 2003 17:16:50 -0400, Tom Lane <tgl@sss.pgh.pa.us>
wrote:
>> Whenever a backend encounters a dead tuple it inserts a reference to
>> its page into the RSM.
>
>This assumes that backends will visit dead tuples with significant
>probability.  I doubt that assumption is tenable;

Good point.  What about:  Whenever a backend *deletes* a tuple it
inserts a reference to its page into the RSM?  Then an entry in the
RSM doesn't necessarily mean that the referenced page has reclaimable
space, but it would still be valueable information.

Servus
 Manfred

pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Decent VACUUM (was: Buglist)
Next
From: Manfred Koizar
Date:
Subject: Re: Buglist