Postgres Pro
Downloads
Home   >   mailing lists

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

From bricklen
Subject Re: Disk latency goes up during certaing pediods
Date
Msg-id CAGrpgQ8_sKxbp70dnMNvMSFAsB8duoo2uTHDDkULww_BVZzmSA@mail.gmail.com
Whole thread Raw
In response to Re: Disk latency goes up during certaing pediods  (German Becker <german.becker@gmail.com>)
Responses Re: Disk latency goes up during certaing pediods  (German Becker <german.becker@gmail.com>)
List pgsql-admin
Tree view

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: German Becker
Date:
Subject: Re: Disk latency goes up during certaing pediods
Next
From: German Becker
Date:
Subject: Re: Disk latency goes up during certaing pediods