Обсуждение: 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>