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

Reply via email to