Re: VACUUM, 24/7 availability and 7.2

Erwin Lansing <erwin(at)lansing(dot)dk> writes:

> We are having some trouble with some tables in which we have lots of
> update's (and insert/delete's). "A lot" being several thousands per day
> (I haven't measured the exact numbers recently). VACUUM is running twice
> a day and locks these tables a long time where 10-15 minutes is not
> exceptional. This table has only approx 100k records, but these are
> updated very often and that seems to cause to much rubbish for vacuum

You might try running VACUUM much more often, as it'll run faster with
less work to do. If running it every hour takes the locked time down
to 30 seconds, you might find that acceptable (depending on the
application of course).

Worth a try until 7.2 is solid...

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