On 13/08/2011 7:37 AM, Tomas Vondra wrote:
I'd understand a slowdown, but why does it block?
My first guess is that you're having checkpoint issues. Try enabling logging of checkpoints and checkpoint timings and see if anything there lines up with the pause you encounter.
-- Craig Ringer -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
