On Nov 16, 2012, at 11:59 AM, Richard Huxton <dev@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
