Re: [GENERAL] pgtune and massive shared_buffers recommendation

2014-05-27 Thread Shaun Thomas
On 05/21/2014 09:39 AM, Stuart Bishop wrote: I've got some boxes with 128GB of RAM and up to 750 connections, just upgraded to 9.3 so I'm revising my tuning. I'm getting a recommendation from pgtune to bump my shared_buffers up to 30GB and work_mem to 80MB. Is a shared_buffers this high now sane

Re: [GENERAL] pgtune and massive shared_buffers recommendation

2014-05-21 Thread Bill Moran
On Wed, 21 May 2014 21:39:05 +0700 Stuart Bishop wrote: > > I've got some boxes with 128GB of RAM and up to 750 connections, just > upgraded to 9.3 so I'm revising my tuning. I'm getting a > recommendation from pgtune to bump my shared_buffers up to 30GB and > work_mem to 80MB. Is a shared_buffe