Обсуждение: Re: [PERFORM] PostgreSQL vs. MySQL

Do we need to add a mention of the need for tuning to the install docs?

---------------------------------------------------------------------------

Andrew Sullivan wrote:
> On Fri, Jul 04, 2003 at 08:07:18PM +0200, Arjen van der Meijden wrote:
> > > Andrew Sullivan wrote:
> > > results under production conditions, and not bother to read
> > > even the basic "quickstart"-type stuff that is kicking
> > > around.
> > Then please point out where it sais, in the documentation, that the
> > value for the shared_memory of 64 is too low and that 4000 is a nice
> > value to start with?
>
> I think I did indeed speak too soon, as the criticism is a fair one:
> nowhere in the installation instructions or the "getting started"
> docs does it say that you really ought to do some tuning once you
> have the system installed.  Can I suggest for the time being that
> something along these lines should go in 14.6.3, "Tuning the
> installation":
>
> ---snip---
> By default, PostgreSQL is configured to run on minimal hardware.  As
> a result, some tuning of your installation will be necessary before
> using it for anything other than extremely small databases.  At the
> very least, it will probably be necessary to increase your shared
> buffers setting.  See Chapter 16 for details on what tuning options
> are available to you.
> ---snip---
>
> > I'm sorry to put this in a such a confronting manner, but you simply
> > can't expect people to search for information that they don't know the
> > existence of.
>
> No need to apologise; I think you're right.
>
> A
>
> --
> ----
> Andrew Sullivan                         204-4141 Yonge Street
> Liberty RMS                           Toronto, Ontario Canada
> <andrew@libertyrms.info>                              M2P 2A8
>                                          +1 416 646 3304 x110
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

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

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.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

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>