Re: Configuring Shared Buffers

On Mon, Jun 30, 2008 at 7:09 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Rafael Domiciano escribió:
>> The Postgres version is 8.3.3 and I am using Fedora Core 8.
>> I have in the actual server around 70 connections the same time. I am
>> assigning for this 100.
>
> 100 MB?  That's not very much either.  You can probably get a hefty
> performance boost by upping it a lot more (depending on whether the
> machine is doing something else, or Postgres is the only service running
> on it.)

I think he was talking about max connections.

As for shared buffers, I'd start out at about 25% main memory for
8.3.3 and test that.  Also, he should be looking at his setting for
work_mem