Re: Limited Shared Buffer Problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanx, I will try out that recommendation.


On Fri, Jan 29, 2010 at 11:53 AM, Richard Neill <rn214@xxxxxxxxx> wrote:


**Rod MacNeil wrote:
Hi All,

I have a server running CentOS5 with 6gb of memory that will run postgres 8.3 exclusively.
I would like to allocate 4gb of the memory to shared buffers for postgres.

It might be worth pausing at this point:

The various postgresql tuning guides usually suggest that on a dedicated system, you should give postgres about 1/4 of the RAM for shared buffers, while telling it that the effective_cache_size = 1/2 RAM.

Postgres will make good use of the OS cache as a file-cache - the "effective_cache_size" setting is advisory to postgres that it can expect about this much data to be in RAM.

Also, If you are setting up a new system, it's probably worth going for 8.4.2. Postgres is relatively easy to build from source.

HTH,

Richard

--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



--
Rod MacNeil
Senior Software Engineer
Interact Direct Marketing, Inc.
www.interactdirect.com
rmacneil@xxxxxxxxxxxxxxxxxx
Primary Phone Mississauga Ontario: 905-278-4086
Alternate Phone London Ontario: 519-438-6245, Ext 183


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux