On Thu, Mar 17, 2005 at 05:22:41AM +0000, Christopher Browne wrote: > What strikes me as being a useful approach would be to set up an > LRU-ordered (or perhaps unordered) queue of pages that have had tuples > "killed off" by DELETE or UPDATE.
>From http://www.postgresql.org/docs/faqs.TODO.html : * Maintain a map of recently-expired rows This allows vacuum to reclaim free space without requiring a sequential scan -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
