Manfred Koizar wrote: > [ still brainstorming ... ] > > On Thu, 21 Aug 2003 17:16:50 -0400, Tom Lane <[EMAIL PROTECTED]> > 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.
Added to TODO: * Maintain a map of recently-expired of pages so vacuum can reclaim free space without a sequential scan -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])