Re: autovacuum daemon - Mailing list pgsql-general

From Sam Mason
Subject Re: autovacuum daemon
Date
Msg-id 20090121162243.GZ3008@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to Re: autovacuum daemon  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-general
  [ Grzegorz, please include some context ]

On Wed, Jan 21, 2009 at 03:01:39PM +0000, Grzegorz Jaaakiewicz wrote:
> Avdul Rehman wrote:
> > I have set postgresql.conf for autovacuum and need to know weather
> > the process is running/working or not.
>
> select * from pg_autovacuum;

This won't do what the OP was asking for; pg_autovacuum only records
non-default autovacuum parameters where they have been set by the
user/admin.  More details here:

  http://www.postgresql.org/docs/current/static/catalog-pg-autovacuum.html

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Slow update
Next
From: Sam Mason
Date:
Subject: Re: Slow update