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 CALyjCLs1qTQimn+2oVYcw2DtFN8aRnAgh2AfYbD+uQE1n6f3uQ@mail.gmail.com
Whole thread Raw
In response to Re: Disk latency goes up during certaing pediods  (bricklen <bricklen@gmail.com>)
List pgsql-admin
I'm using kernel 3.2 so this probably apply. Many thanks! I'll upgrade the kernel and let you know


On Wed, Jul 31, 2013 at 1:34 PM, bricklen <bricklen@gmail.com> wrote:
On Wed, Jul 31, 2013 at 9:25 AM, German Becker <german.becker@gmail.com> wrote:
To all whom might be interested, I have an update on this.
I run some tests on the old production DB which was Posgres 8.3 (and only one disk for everything), using pgreplay, running the same queries as the 9.1 server.
Here is the output of iostat for the 8.3 server:
...
Here is the output for 9.1:
...

What kernel are you running? Could it be related to a recent discussions about the 3.2 kernel?
http://markmail.org/message/qosngswoy5lqmxlr

pgsql-admin by date:

Previous
From: bricklen
Date:
Subject: Re: Disk latency goes up during certaing pediods
Next
From: Kevin Grittner
Date:
Subject: Re: unexpected EOF on client connection during pg_dumpall