> Sounds to me like your IO system is stalling on fsyncs or something
> like that. On machines with plenty of IO cranking up completion
> target usuall smooths things out.
It certainly seems like it does. However, I can't demonstrate the issue
using any simpler tool than pgbench ... even runni
On 02/19/2013 07:15 PM, Scott Marlowe wrote:
> On Tue, Feb 19, 2013 at 4:24 PM, Josh Berkus wrote:
>> ... then you'll see checkpoint "stalls" and spread checkpoint will
>> actually make them worse by making the stalls longer.
>
> Wait, if they're spread enough then there won't be a checkpoint, so