Re: Logging of autovacuum activity

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Markus Wollny <Markus(dot)Wollny(at)computec(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Logging of autovacuum activity
Date: 2008-04-01 19:14:39
Message-ID: 1207077279.4238.63.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2008-04-01 at 21:02 +0200, Markus Wollny wrote:

> I am a bit stuck finding out how to log autovacuum activity in
> PostgreSQL 8.2. In the olden times I used to pipe the pg_autovacuum
> daemon's output to a file. Now pg_autovacuum has become part of the
> core, I wonder if there's some other possibility of monitoring its
> activity?

That's a new feature in 8.3. If you did have it you'd realise you want
the other features in 8.3 also. Upgrade recommended.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2008-04-01 19:18:18 Re: ANALYZE getting dead tuple count hopelessly wrong
Previous Message Markus Wollny 2008-04-01 19:02:06 Logging of autovacuum activity