X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id D07DCD1B535
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Sep 2003 17:47:34 +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 80731-08
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Sep 2003 14:47:25 -0300 (ADT)
Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251])
	by svr1.postgresql.org (Postfix) with ESMTP id E3D74D1B4F9
	for <pgsql-docs@postgresql.org>; Fri, 26 Sep 2003 14:47:22 -0300 (ADT)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.11.6) id h8QHlMT13666;
	Fri, 26 Sep 2003 13:47:22 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200309261747.h8QHlMT13666@candle.pha.pa.us>
Subject: Re: [PERFORM] PostgreSQL vs. MySQL
In-Reply-To: <20030817110619.A28221@mail.libertyrms.com>
To: Andrew Sullivan <andrew@libertyrms.info>
Date: Fri, 26 Sep 2003 13:47:22 -0400 (EDT)
Cc: PostgreSQL-documentation <pgsql-docs@postgresql.org>
X-Mailer: ELM [version 2.4ME+ PL106 (25)]
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary=ELM1064598442-17213-1_
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/63
X-Sequence-Number: 2019

--ELM1064598442-17213-1_
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Andrew Sullivan wrote:
> On Sat, Aug 16, 2003 at 08:36:57PM -0400, Bruce Momjian wrote:
> > 
> > Do we need to add a mention of the need for tuning to the install docs?
> 
> Wouldn't be a bad idea, as far as I'm concerned.

OK, I added a 'Tuning' section to the install instructions.  I can make
adjustments.

-- 
  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

--ELM1064598442-17213-1_
Content-Transfer-Encoding: 7bit
Content-Type: text/plain
Content-Disposition: inline; filename="/bjm/diff"

Index: doc/src/sgml/installation.sgml
===================================================================
RCS file: /cvsroot/pgsql-server/doc/src/sgml/installation.sgml,v
retrieving revision 1.143
diff -c -c -r1.143 installation.sgml
*** doc/src/sgml/installation.sgml	13 Sep 2003 17:01:09 -0000	1.143
--- doc/src/sgml/installation.sgml	26 Sep 2003 17:40:53 -0000
***************
*** 1156,1161 ****
--- 1156,1181 ----
    <title>Post-Installation Setup</title>
  
    <sect2>
+    <title>Tuning</title>
+ 
+    <indexterm>
+     <primary>tuning</primary>
+    </indexterm>
+ 
+    <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 <xref linkend="runtime-config-resource-memory">. Other
+     paramters in <xref linkend="runtime-config-resource"> also affect 
+     performance.
+    </para>
+   </sect2>
+ 
+   <sect2>
     <title>Shared Libraries</title>
  
     <indexterm>

--ELM1064598442-17213-1_--