Postgres Pro
Downloads
Home   >   mailing lists

Re: Disk latency goes up during certaing pediods - Mailing list pgsql-admin

From German Becker
Subject Re: Disk latency goes up during certaing pediods
Date
Msg-id CALyjCLuLv_OfmfEHVOW7qRpuU_jNoKG1uKM3=SA59VSXsi=yMg@mail.gmail.com
Whole thread Raw
In response to Re: Disk latency goes up during certaing pediods  (bricklen <bricklen@gmail.com>)
Responses Re: Disk latency goes up during certaing pediods  (bricklen <bricklen@gmail.com>)
List pgsql-admin
Tree view
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@gmail.com> wrote:

On Mon, Jul 29, 2013 at 12:41 PM, German Becker <german.becker@gmail.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?

pgsql-admin by date:

Previous
From: bricklen
Date:
Subject: Re: Disk latency goes up during certaing pediods
Next
From: bricklen
Date:
Subject: Re: Disk latency goes up during certaing pediods