Hi. 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?
The PostgreSQL reference doesn't make recommendations on limits, but it didn't either with earlier versions of PostgreSQL where more than a few GB was normally a bad thing to do. The most recent blob posts I see mentioning 9.3 and modern RAM sizes still seem to cap it at 8GB. (and yes, I am using pgbouncer but stuck in session mode and up to 750 connections for the time being) -- Stuart Bishop <stu...@stuartbishop.net> http://www.stuartbishop.net/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
