Re: Disk latency goes up during certaing pediods

From: bricklen <bricklen(at)gmail(dot)com>
To: German Becker <german(dot)becker(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Disk latency goes up during certaing pediods
Date: 2013-07-29 20:06:41
Message-ID: CAGrpgQ8_sKxbp70dnMNvMSFAsB8duoo2uTHDDkULww_BVZzmSA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message German Becker 2013-07-29 20:28:47 Re: Disk latency goes up during certaing pediods
Previous Message German Becker 2013-07-29 19:44:41 Re: Disk latency goes up during certaing pediods