Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 05B14475F2F
	for <pgsql-sql@postgresql.org>; Wed, 22 Jan 2003 05:02:33 -0500 (EST)
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by postgresql.org (Postfix) with SMTP id 24A00475F28
	for <pgsql-sql@postgresql.org>; Wed, 22 Jan 2003 05:02:31 -0500 (EST)
Received: (qmail 14288 invoked by uid 0); 22 Jan 2003 10:02:32 -0000
Received: from chello062178186201.1.15.tuwien.teleweb.at (HELO beeblebrox)
	(62.178.186.201)
	by mail.gmx.net (mp014-rz3) with SMTP; 22 Jan 2003 10:02:32 -0000
Message-ID: <00a301c2c1fd$8fec4d30$3201a8c0@beeblebrox>
From: "Michael Paesold" <mpaesold@gmx.at>
To: <pgsql-sql@postgresql.org>
Cc: "Michael Hostbaek" <mich@the-lab.org>
References: <Pine.LNX.4.44.0301221103180.812-100000@matrix.gatewaynet.com>
Subject: Re: optimal sql
Date: Wed, 22 Jan 2003 11:03:47 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/328
X-Sequence-Number: 11193

Achilleus Mantzios <achill@matrix.gatewaynet.com> wrote:

> For a) do all the necessary tuning on PostgreSQL.
> With 1GB of Mem, you could set a value of shared_buffers to 100000.

Perhaps just a type, but that is way to much! It would mean about 800 Mb
shared buffers! I would rather suggest a value between 1000 and 10000. See
recent descussions on -performance and -hackers mailing lists.

Best Regards,
Michael Paesold