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 8EB2AD1B4FC
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Oct 2003 17:59:49 +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 09431-04
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  8 Oct 2003 14:59:03 -0300 (ADT)
Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251])
	by svr1.postgresql.org (Postfix) with ESMTP id 423F2D1B549
	for <pgsql-performance@postgresql.org>;
	Wed,  8 Oct 2003 14:59:01 -0300 (ADT)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.11.6) id h98Hwvr15088;
	Wed, 8 Oct 2003 13:58:57 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200310081758.h98Hwvr15088@candle.pha.pa.us>
Subject: Re: PostgreSQL vs. MySQL
In-Reply-To: <200310081049.55816.josh@agliodbs.com>
To: Josh Berkus <josh@agliodbs.com>
Date: Wed, 8 Oct 2003 13:58:57 -0400 (EDT)
Cc: Andrew Sullivan <andrew@libertyrms.info>, pgsql-performance@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL106 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/226
X-Sequence-Number: 3974

Josh Berkus wrote:
> 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.

Yes, I think that is a good idea --- now, does it go in the install
docs, or in the docs next to each GUC item?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073