Postgres Pro
Downloads
Home   >   mailing lists

Re: strange pgbench results (as if blocked at the end) - Mailing list pgsql-performance

From Craig Ringer
Subject Re: strange pgbench results (as if blocked at the end)
Date
Msg-id 4E45C2E8.5070701@ringerc.id.au
Whole thread Raw
In response to strange pgbench results (as if blocked at the end)  ("Tomas Vondra" <tv@fuzzy.cz>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: hyelluas
Date:
Subject: How to see memory usage using explain analyze ?
Next
From: Greg Smith
Date:
Subject: Re: strange pgbench results (as if blocked at the end)