Postgres Pro
Downloads
Home   >   mailing lists

Re: about shared_buffer and kernel.shmmax - Mailing list pgsql-admin

From Greg Smith
Subject Re: about shared_buffer and kernel.shmmax
Date
Msg-id 4FE2CB4D.4000108@2ndQuadrant.com
Whole thread Raw
In response to about shared_buffer and kernel.shmmax  (wangqi <wangqi@edgesoft.cn>)
List pgsql-admin
Tree view 
On 06/20/2012 11:38 PM, wangqi wrote:
> shared_buffer maximum limit is ?
> I set shared_buffer more than 250G, I got error at startup pg.

There's not much evidence that values larger than 16GB are really
productive.  You really do not want put all their memory in just that
one place.

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com

pgsql-admin by date:

Previous
From: Craig Ringer
Date:
Subject: Re: about shared_buffer and kernel.shmmax
Next
From: Greg Williamson
Date:
Subject: autovac hitting too many tables at once