Re: Shared Buffer setting in postgresql.conf

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Radhika S" <radhika(dot)sambamurti(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Shared Buffer setting in postgresql.conf
Date: 2007-10-11 00:49:23
Message-ID: dcc563d10710101749k12d58355q721cc9b741eaa6cc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 10/10/07, Radhika S <radhika(dot)sambamurti(at)gmail(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2007-10-11 03:14:02 Re: building a performance test suite
Previous Message Radhika S 2007-10-11 00:33:50 Re: Shared Buffer setting in postgresql.conf