On 11/20/2012 10:03 AM, Merlin Moncure wrote:
Shared buffer manipulation changing contention is suggesting you're running into free list lock issues. How many active backends/cores?
Oh, the reason I wanted to point it out was that we see a lot more than CPU contention with higher shared_buffer settings. The scheduler starts aggressively clearing out the file cache *and* freeing memory, driving load way higher than it should be. That doesn't result in a very high iowait, but all that page swapping sure isn't free.
-- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-444-8534 sthomas@xxxxxxxxxxxxxxxx ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
