David Mitchell wrote:

If your table has got into this state, then vacuum analyze won't fix it. You will have to do a vacuum full to get it back to normal, then regularly vacuum (not full) to keep it in good condition. We vacuum our critical tables every 10 minutes to keep them in good nick.


So should I have vacuum run during the load test? At what level of updates should it run every ten minutes?

Dennis

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to