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
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com
In response to
pgsql-admin by date
|Next:||From: Greg Williamson||Date: 2012-06-22 18:58:19|
|Subject: autovac hitting too many tables at once|
|Previous:||From: Craig Ringer||Date: 2012-06-21 04:34:04|
|Subject: Re: about shared_buffer and kernel.shmmax|