Thursday, May 8, 2008

Re: [GENERAL] auto-vacuum questions

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>

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: