DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=vLwLM6FVOesO6ceE4jeawSUTRjAYRVWD409qCaPFK+jeKv55cF9Vs/V3EFBhso2Prx
	YerlLgE1mWwBrKNtdMl/Ou5jsHSwRej3ORxE84zlMiRE3OfD+gVtI/+IPPCLJlrhwm7W
	ZLUQT+CB71O0b+lPSHJ8V3GZon+yMOrRrOtBI=
Message-ID: <dcc563d10806301908m5d90b8beqa60b8c53efc0ed7f@mail.gmail.com>
Date: Mon, 30 Jun 2008 20:08:39 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Alvaro Herrera" <alvherre@commandprompt.com>
Subject: Re: Configuring Shared Buffers
Cc: "Rafael Domiciano" <rafael.domiciano@gmail.com>,
	"Tino Schwarze" <postgresql@tisc.de>, pgsql-admin@postgresql.org
In-Reply-To: <20080701010927.GH18252@alvh.no-ip.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <3a0028490806301052y193a4aeayfcc6deafdeb1cdb2@mail.gmail.com>
	<20080630182830.GA5358@easy2.in-chemnitz.de>
	<3a0028490806301201m5e4c48d4qc51a880b8f80ecf5@mail.gmail.com>
	<20080701010927.GH18252@alvh.no-ip.org>

On Mon, Jun 30, 2008 at 7:09 PM, Alvaro Herrera
<alvherre@commandprompt.com> 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