On Tue, Oct 02, 2007 at 09:07:54PM -0400, Alvaro Herrera wrote: > Decibel! wrote: > > > Hrm... what about adding output to vacuum verbose that indicates how many > > pages in a relation have free space? That would allow something like > > pgfouine to see how many FSM pages were needed. It would also make it > > easier to identify relations that could stand a vacuum full/reindex/cluster > > (though you'd also want to know something like average free space per > > page). > > Rather than wasting time fixing minor FSM issues, I would favor > rewriting the stuff so that the FSM is disk-spillable.
Sure, but this would also likely be a 20 line change to vacuum... -- Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828
pgpJ9N6QD9S1A.pgp
Description: PGP signature