Re: Cost of creating an emply WAL segment

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx

______________________________________________

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

--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux