public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Andrew Sullivan <[email protected]>
Cc: PostgreSQL-documentation <[email protected]>
Subject: Re: [PERFORM] PostgreSQL vs. MySQL
Date: Fri, 26 Sep 2003 13:47:22 -0400 (EDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
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
[email protected] | (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>
Attachments:
[text/plain] /bjm/diff (1.3K, 2-%2Fbjm%2Fdiff)
download | inline:
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>
view thread (66+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: [PERFORM] PostgreSQL vs. MySQL
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox