On 10/10/2011 12:31 PM, alexandre - aldeia digital wrote:

<2011-10-10 14:18:48 BRT >LOG: checkpoint complete: wrote 6885 buffers
(1.1%); 0 transaction log file(s) added, 0 removed, 1 recycled;
write=29.862 s, sync=28.466 s, total=58.651 s

28.466s sync time?! That's horrifying. At this point, I want to say the increase in effective_cache_size or shared_buffers triggered the planner to change one of your plans significantly enough it's doing a ton more disk IO and starving out your writes. Except you said you changed it back and it's still misbehaving.

This also reminds me somewhat of an issue Greg mentioned a while back with xlog storms in 9.0 databases. I can't recall how he usually "fixed" these, though.

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

______________________________________________

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

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

Reply via email to