Back in the discussion of this someone had mentioned capturing all the info that you'd get from a vacuum verbose; dead tuples, etc. What do people think about that? In particular I think it'd be handy to know how many pages vacuum wanted in the FSM vs. how many it got; this would make it much easier for people to ensure that the FSM is large enough. Using the functions that let you query the FSM won't work because they can't tell you if there are pages that should have been in the FSM but didn't make it in.
On Tue, May 02, 2006 at 09:19:22PM +0200, Martijn van Oosterhout wrote: > Looks good to me. Short and sweet. > > On Tue, May 02, 2006 at 01:18:03PM -0500, Larry Rosenman wrote: > > Greetings, > > I've got a patch to be reviewed for having the stats system keep > > track of the last > > time a table was vacuumed or analyzed either by the user or via > > AutoVacuum. > > > > The patch is at: > > http://www.lerctr.org/~ler/pg-dev/vacuum-autovacuum-times-stats.diff > > > > I'd appreciate a full review, it includes docs as well. > > -- > Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > > From each according to his ability. To each according to his ability to > > litigate. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
