Disk latency goes up during certaing pediods

From: German Becker <german(dot)becker(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Disk latency goes up during certaing pediods
Date: 2013-07-26 19:21:25
Message-ID: CALyjCLtwf_0rV4bXpHEkew63eii2YNCO=16zMpZqeaugXgYYZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi list,

I am running Postgres 9.1 on Ubuntu 12.04. I have a dedicated disk for
pg_xlog, using ext4 filesystem with journaling in writeback mode
During high load times, the disk usage is arround 40%. The IO write time is
constant at about 3ms. On certain occasions roughly once in 15 days, the
IO write time goes up to about 10ms. This makes the disk usage go up to
almost 100%, probably saturation, and the INSERTS DELETES UPDATES run
considerable slower than normal.This lasts for about 2 hours and then the
latency goes back to 3ms and everything is normal again.
Has anyone seen this behavior? What could be causing the increase in
latency?

Thanks!

Germán Becker

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2013-07-26 20:27:14 Re: Disk latency goes up during certaing pediods
Previous Message Luis 2013-07-26 15:31:06 Question about DB stats resets