Erwin Lansing <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
