Re: Disk latency goes up during certaing pediods

Here are the values:

# - Checkpoints -

checkpoint_segments = 256 # in logfile segments, min 1, 16MB
each
#checkpoint_timeout = 5min # range 30s-1h
checkpoint_completion_target = 0.7 # checkpoint target duration, 0.0 -
1.0
#checkpoint_warning = 30s # 0 disables

On Mon, Jul 29, 2013 at 5:06 PM, bricklen <bricklen(at)gmail(dot)com> wrote:

>
> On Mon, Jul 29, 2013 at 12:41 PM, German Becker <german(dot)becker(at)gmail(dot)com>wrote:
>
>> Luis, The disk only has the WAL (pg_xlog ) directory. Brett, Here are the
>> mount options:
>>
>> /dev/sdb1 on /storage/sdb1 type ext3
>> (rw,noatime,data=writeback,errors=remount-ro)
>>
>> BTW The original fs was ext4, now I am trying with ext3, with the exact
>> same results. No noticeable changes using diferent journal modes.
>>
>> I also tried disabling the journal altogether, which dramatically reduced
>> the disk usage, but nevertheless there was this latency spikes.
>>
>
>
> I haven't been following this thread and might have missed it, but did you
> show your checkpoint_completion_target?
>