Re: strange pgbench results (as if blocked at the end)

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: strange pgbench results (as if blocked at the end)
Date: 2011-08-13 00:18:48
Message-ID: 4E45C2E8.5070701@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2011-08-13 03:09:07 Re: strange pgbench results (as if blocked at the end)
Previous Message Tomas Vondra 2011-08-12 23:37:19 strange pgbench results (as if blocked at the end)