Re: When do I Vacuum ? - Mailing list pgsql-general

From Doug McNaught
Subject Re: When do I Vacuum ?
Date
Msg-id m3oflcb43m.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to Re: When do I Vacuum ?  ("Steve Brett" <steve.brett@e-mis.com>)
List pgsql-general
"Steve Brett" <steve.brett@e-mis.com> writes:

> could someone please post an answer, even if it's just a pointer to
> somewhere else ... please ....

Sorry, I just got your message--looks like the list got hung up for a
little while.

The nice thing about VACUUM is that if you're running it "too often"
it won't have very much work to do so it'll complete very quickly.  The
only thing to watch out for is lock contention between VACUUM and
"real work" (which is why Bruce suggests running it at quiet times).

So once an hour isn't going to hurt anything most likely, though it is
probably overkill for your current situation.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: [BASIC FEATURES] stored procedures in Postgresql ?
Next
From: Herb Blacker
Date:
Subject: DBVisualizer