Postgres Pro
Downloads
Home   >   mailing lists

Re: Shared Buffer setting in postgresql.conf - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Shared Buffer setting in postgresql.conf
Date
Msg-id dcc563d10710101749k12d58355q721cc9b741eaa6cc@mail.gmail.com
Whole thread Raw
In response to Re: Shared Buffer setting in postgresql.conf  ("Radhika S" <radhika.sambamurti@gmail.com>)
Responses Re: Shared Buffer setting in postgresql.conf
List pgsql-performance
Tree view 
On 10/10/07, Radhika S <radhika.sambamurti@gmail.com> wrote:
> Thank you scott.
>
> We plan on upgrading to Postgres 8.2 very soon.
> Would it be safe to say I can make my SHARED BUFFER setting 200MB (I have
> 2GB memory ).
> The default is 24MB.

On a dedicated db machine with 2 Gigs of ram 500Meg is fine.  I run
768 Meg shared_buffers on a machine that runs postgresql 8.2 and
apache/php and routinely have 1Gig of kernel cache on it.

So yeah, 200M shared_buffers should be no problem.

pgsql-performance by date:

Previous
From: "Radhika S"
Date:
Subject: Re: Shared Buffer setting in postgresql.conf
Next
From: Greg Smith
Date:
Subject: Re: building a performance test suite