Re: Cost of creating an emply WAL segment - Mailing list pgsql-performance

From Shaun Thomas
Subject Re: Cost of creating an emply WAL segment
Date
Msg-id 4E04DDB3.8050306@peak6.com
Whole thread Raw
In response to Re: Cost of creating an emply WAL segment  (Greg Smith <greg@2ndQuadrant.com>)
Responses Re: Cost of creating an emply WAL segment
List pgsql-performance
On 06/24/2011 11:18 AM, Greg Smith wrote:

> sync=14525.296 s, total=14786.868 s

Whaaaaaaaaat!? 6% of 8GB is just shy of 500MB. That's not a small
amount, exactly, but it took 14525 seconds to call syncs for those
writes? What kind of ridiculous IO would cause something like that?
That's even way beyond an OS-level dirty buffer flush on a massive
system. Wow!

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas@peak6.com

______________________________________________

See  http://www.peak6.com/email_disclaimer.php
for terms and conditions related to this email

pgsql-performance by date:

Previous
From: Harry Mantheakis
Date:
Subject: Re: Long Running Update
Next
From: Greg Smith
Date:
Subject: Re: Cost of creating an emply WAL segment