Re: auto-vacuum questions - Mailing list pgsql-general

From John Gateley
Subject Re: auto-vacuum questions
Date
Msg-id 20080508100420.82594ce7.gateley@jriver.com
Whole thread Raw
In response to Re: auto-vacuum questions  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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>

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: auto-vacuum questions
Next
From: Peter Eisentraut
Date:
Subject: Re: now i'm really confused. insert/update does autocast, where sometimes.