On Nov 16, 2012, at 11:59 AM, Richard Huxton 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:
On 11/16/2012 01:59 PM, Richard Huxton wrote:
http://frosty-postgres.blogspot.co.uk/2012/08/postgresql-numa-and-zone-reclaim-mode.html
I actually considered zone_reclaim_mode. But the article you linked to
misses a point: during boot, zone_reclaim_mode is chosen only if the
zone distance is
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
It does the same thing at 6GB. 4GB is safe
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
The thing is, we currently have 850 clients connected to our database (I
know, that'
