"Mindaugas Riauba" <mind@bi.lt> writes:
> 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?
Checkpoints? You should ensure that the checkpoint settings are such
that checkpoints don't happen too often (certainly not oftener than
every five minutes or so), and make sure the bgwriter is configured
to dribble out dirty pages at a reasonable rate, so that the next
checkpoint doesn't have a whole load of stuff to write.
regards, tom lane