Re: Configuring Shared Buffers

On Mon, Jun 30, 2008 at 7:09 PM, Alvaro Herrera
<alvherre@[EMAIL PROTECTED]
> wrote:
> Rafael Domiciano escribi=F3:
>> 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

--=20
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin