Martijn van Oosterhout wrote: > 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 :) > 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: [EMAIL PROTECTED] Web: www.pervasive.com ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster