Re: When do I Vacuum ?

"Steve Brett" <steve(dot)brett(at)e-mis(dot)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