Re: Cost of creating an emply WAL segment

From: Shaun Thomas <sthomas(at)peak6(dot)com>
To: Greg Smith <greg(at)2ndQuadrant(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Cost of creating an emply WAL segment
Date: 2011-06-24 18:55:47
Message-ID: 4E04DDB3.8050306@peak6.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)peak6(dot)com

______________________________________________

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2011-06-24 23:26:31 Re: Cost of creating an emply WAL segment
Previous Message Harry Mantheakis 2011-06-24 16:49:55 Re: Long Running Update