Skip site navigation (1) Skip section navigation (2)

Re: about shared_buffer and kernel.shmmax

From: Greg Smith <greg(at)2ndQuadrant(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: about shared_buffer and kernel.shmmax
Date: 2012-06-21 07:20:45
Message-ID: 4FE2CB4D.4000108@2ndQuadrant.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(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 WilliamsonDate: 2012-06-22 18:58:19
Subject: autovac hitting too many tables at once
Previous:From: Craig RingerDate: 2012-06-21 04:34:04
Subject: Re: about shared_buffer and kernel.shmmax

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group