[ 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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general