Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum daemon - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: autovacuum daemon
Date
Msg-id 20090121151445.GF4038@alvh.no-ip.org
Whole thread Raw
In response to autovacuum daemon  (Abdul Rahman <abr_ora@yahoo.com>)
Responses Re: autovacuum daemon  (Andreas Wenk <a.wenk@netzmeister-st-pauli.de>)
List pgsql-admin
Tree view 
Abdul Rahman wrote:
> Deal All,
>
> I have set postgresql.conf for autovacuum and need to know weather the
> process is running/working or not.

Run this query:
SHOW autovacuum;

If it says "on", then it is working.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-admin by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: [GENERAL] bytea size limit?
Next
From: Tom Lane
Date:
Subject: Re: Question on Index usage