Re: auto-vacuum questions

John Gateley <gateley@jriver.com>

From: John Gateley <gateley@jriver.com>
To: pgsql-general@postgresql.org
Date: 2008-05-08T15:04:20Z
Lists: pgsql-general
On Thu, 8 May 2008 10:54:32 -0400
Alvaro Herrera <alvherre@commandprompt.com> wrote:

> John Gateley wrote:
> > Hi, I have a couple of questions on the auto-vacuum daemon:
> > 
> > 1) How do I know it is running.
> 
> Open a session and run "SHOW autovacuum".  If it says "on", it's
> vacuuming.  Keep an eye on the autovacuum_naptime setting too.

Thank you,

j

-- 
John Gateley <gateley@jriver.com>