[ 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/