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

Re: Limited Shared Buffer Problem

From: "**Rod MacNeil" <rmacneil(at)interactdirect(dot)com>
To: Richard Neill <rn214(at)cam(dot)ac(dot)uk>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Limited Shared Buffer Problem
Date: 2010-01-29 18:36:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Thanx, I will try out that recommendation.

On Fri, Jan 29, 2010 at 11:53 AM, Richard Neill <rn214(at)cam(dot)ac(dot)uk> 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(at)postgresql(dot)org)
> To make changes to your subscription:

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

In response to

pgsql-performance by date

Next:From: Greg StarkDate: 2010-01-29 18:56:23
Subject: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)
Previous:From: Ing . Marcos Luís Ortíz ValmasedaDate: 2010-01-29 18:24:12
Subject: Re: Limited Shared Buffer Problem

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