Re: Logging pg_autovacuum - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Logging pg_autovacuum
Date
Msg-id 20060428203855.GF15566@svana.org
Whole thread Raw
In response to Re: Logging pg_autovacuum  ("Larry Rosenman" <lrosenman@pervasive.com>)
Responses Re: Logging pg_autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Logging pg_autovacuum  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On Fri, Apr 28, 2006 at 03:18:56PM -0500, Larry Rosenman wrote:
> > Martijn van Oosterhout <kleptog@svana.org> writes:
> >> You know, rather than adding new columns to pg_class, why not extend
> >> the stats collector to collect this information.
>
> That sounds doable.  And a lot less scary for me (as a relative
> noobie) to do.

Well, I've been thinking a bit more and it seems a perfect fit in many
ways. None of the info we're talking about here takes any extra time to
calculate, it's all debates about what to log. So send it to the stats
collector and let it deal with it.

It should probably tie in with normal vacuum. We get requests from time
to time from people wanting to know the last time a table was vacuumed
(not autovacuumed) for example.

And it's probably a nice little sub-project someone can work on :)

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

pgsql-hackers by date:

Previous
From: "Larry Rosenman"
Date:
Subject: Re: Logging pg_autovacuum
Next
From: Kris Jurka
Date:
Subject: Re: Solaris ASM problem