X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 5DD0ED1B4EF
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Oct 2003 17:52:37 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 07583-10
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Oct 2003 14:51:51 -0300 (ADT)
Received: from davinci.ethosmedia.com (unknown [209.128.84.228])
	by svr1.postgresql.org (Postfix) with ESMTP id 36CB3D1B545
	for <pgsql-performance@postgresql.org>;
	Wed,  8 Oct 2003 14:51:50 -0300 (ADT)
Received: from [63.195.55.98] (HELO spooky)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2)
	with ESMTP id 3741632; Wed, 08 Oct 2003 10:52:25 -0700
Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Organization: Aglio Database Solutions
To: Bruce Momjian <pgman@candle.pha.pa.us>,
	Andrew Sullivan <andrew@libertyrms.info>
Subject: Re: PostgreSQL vs. MySQL
Date: Wed, 8 Oct 2003 10:49:55 -0700
User-Agent: KMail/1.4.3
Cc: pgsql-performance@postgresql.org
References: <200310081728.h98HSr811803@candle.pha.pa.us>
In-Reply-To: <200310081728.h98HSr811803@candle.pha.pa.us>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200310081049.55816.josh@agliodbs.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/225
X-Sequence-Number: 3973

Bruce,

> Agreed.  Text added to install docs:
>
>    <para>
>     By default, <productname>PostgreSQL</> is configured to run on minimal
>     hardware.  This allows it to start up with almost any hardware
>     configuration. However, the default configuration is not designed for
>     optimum performance. To achieve optimum performance, several server
>     variables must be adjusted, the two most common being
>     <varname>shared_buffers</varname> and <varname> sort_mem</varname>
>     mentioned in <![%standalone-include[the documentation]]>
>     <![%standalone-ignore[<xref
> linkend="runtime-config-resource-memory">]]>. Other parameters in
> <![%standalone-include[the documentation]]> <![%standalone-ignore[<xref
> linkend="runtime-config-resource">]]> also affect performance.
>    </para>

What would you think of adding a condensed version of my and Shridhar's guide 
to the install docs?  I think I can offer a 3-paragraph version which would 
cover the major points of setting PostgreSQL.conf.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco