Re: Logging pg_autovacuum

On Thu, Apr 27, 2006 at 08:12:23PM +0000, Chris Browne wrote:
> Having some ability to collect statistics about "we recovered 42 pages
> from table foo at 12:45" would seem useful both from an immediate
> temporal perspective where it could suggest whether specific tables
> were being vacuumed too (seldom|often), and from a more
> global/analytic perspective of perhaps suggesting better kinds of
> vacuuming policies. (In much the same way that I'd like to have some
> way of moving towards an analytically better value for
> default_statistics_target than 10...)
>
> If people are interested, I could provide a copy of the "analyze
> VACUUM stats" script...

Yeah, I'm interested. Though just like EXPLAIN output this seems like
another case where having the ability to log this information into the
database itself would be incredibly valuable for anyone wanting to do
later analysis.
--
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