Re: patch review, please: Autovacuum/Vacuum times via stats.

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(at)svana(dot)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 jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461