From: | Steven Schlansker <steven(at)likeness(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Noticed something odd with pgbench |
Date: | 2012-11-16 20:44:51 |
Message-ID: | 1FFEEDA6-75BB-4C1F-8ED7-EFA03A545783@likeness.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Nov 16, 2012, at 11:59 AM, Richard Huxton <dev(at)archonet(dot)com> wrote:
> On 16/11/12 19:35, Shaun Thomas wrote:
>> Hey guys,
>>
>> So, we have a pretty beefy system that runs dual X5675's with 72GB of RAM. After our recent upgrade to 9.1, things have been... odd. I managed to track it down to one setting:
>>
>> shared_buffers = 8GB
>>
> Does this match what you're seeing?
>
> http://frosty-postgres.blogspot.co.uk/2012/08/postgresql-numa-and-zone-reclaim-mode.html
>
(Slightly OT from the OP's question, sorry)
Would this be worth referencing in the PostgreSQL documentation? I feel like I've read a lot of the documentation on Postgres tuning but this is news to me. And surprise surprise I'm running an affected system too! Maybe it deserves a more prominent warning, perhaps at http://www.postgresql.org/docs/9.2/interactive/performance-tips.html
From | Date | Subject | |
---|---|---|---|
Next Message | Vlad | 2012-11-16 21:21:09 | Re: High SYS CPU - need advise |
Previous Message | Merlin Moncure | 2012-11-16 20:31:34 | Re: High SYS CPU - need advise |