Re: [PERFORM] PostgreSQL vs. MySQL

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