Re: Logging pg_autovacuum

Martijn van Oosterhout wrote:
> On Fri, Apr 28, 2006 at 03:18:56PM -0500, Larry Rosenman wrote:
>>> Martijn van Oosterhout <kleptog(at)svana(dot)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 :)
>
Yeah, I was thinking about seeing about that (tying it into vacuum).

I have the time, and the inclination. Just want to get all the details
ironed out before I start doing serious code crunching. I have the
time and Pervasive is ok with me doing it on their dime.

LER

--
Larry Rosenman
Database Support Engineer

PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531

Tel: 512.231.6173
Fax: 512.231.6597
Email: Larry(dot)Rosenman(at)pervasive(dot)com
Web: www.pervasive.com