Re: autovacuum daemon

On 21/01/2009 14:57, Raymond O'Donnell wrote:
> On 21/01/2009 07:47, Abdul Rahman wrote:
>
>> I have set postgresql.conf for autovacuum and need to know weather
>> the process is running/working or not.
>
> ps ax | grep postgres

Also, in psql:

postgres=# show autovacuum;
 autovacuum
------------
 on
(1 row)

HTH,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------