Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Logging pg_autovacuum
- From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
- To: Larry Rosenman <lrosenman(at)pervasive(dot)com>
- Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org, Simon Riggs <simon(at)2ndquadrant(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Matthew T. O'Connor" <matthew(at)zeut(dot)net>
- Subject: Re: Logging pg_autovacuum
- Date: Fri, 28 Apr 2006 22:38:55 +0200
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 :) Have a nice day, -- Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
- Follow-Ups:
- Re: Logging pg_autovacuum
- From: Alvaro Herrera
- Re: Logging pg_autovacuum
- References:
- Re: Logging pg_autovacuum
- From: Larry Rosenman
- Re: Logging pg_autovacuum
- Prev by Date: Re: Logging pg_autovacuum
- Next by Date: Re: Solaris ASM problem
- Previous by thread: Re: Logging pg_autovacuum
- Next by thread: Re: Logging pg_autovacuum
- Indexes: