Re: Logging pg_autovacuum - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Logging pg_autovacuum
Date
Msg-id 1146568017.9599.372.camel@localhost.localdomain
Whole thread Raw
In response to Re: Logging pg_autovacuum  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
On Fri, 2006-04-28 at 22:38 +0200, 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. 

Good idea; Agreed.

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Google SoC--Idea Request
Next
From: "Brandon Black"
Date:
Subject: Re: Constraint Exclusion + Joins?