Mindaugas Riauba wrote:
The "vacuum cost" parameters can be adjusted to make vacuums fired by pg_autovacuum less of a burden. I haven't got any specific numbers to suggest, but perhaps someone else does.
It looks like that not only vacuum causes our problems. vacuum_cost seems to lower vacuum impact but we are still noticing slow queries "storm". We are logging queries that takes >2000ms to process. And there is quiet periods and then suddenly 30+ slow queries appears in log within the same second. What else could cause such behaviour?
I've seen that happen when you're placing (explicitly or *implicitly*) locks on the records you're trying to update/delete.
If you're willing to investigate, `pg_locks' system view holds information about db locks.
-- Cosimo
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings