Re: PostgreSQL vs. MySQL - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: PostgreSQL vs. MySQL
Date
Msg-id 200310081758.h98Hwvr15088@candle.pha.pa.us
Whole thread Raw
In response to Re: PostgreSQL vs. MySQL  (Josh Berkus <josh@agliodbs.com>)
Responses Re: PostgreSQL vs. MySQL
List pgsql-performance
Josh Berkus wrote:
> Bruce,
>
> > Agreed.  Text added to install docs:
> >
> >    <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 <![%standalone-include[the documentation]]>
> >     <![%standalone-ignore[<xref
> > linkend="runtime-config-resource-memory">]]>. Other parameters in
> > <![%standalone-include[the documentation]]> <![%standalone-ignore[<xref
> > linkend="runtime-config-resource">]]> also affect performance.
> >    </para>
>
> What would you think of adding a condensed version of my and Shridhar's guide
> to the install docs?  I think I can offer a 3-paragraph version which would
> cover the major points of setting PostgreSQL.conf.

Yes, I think that is a good idea --- now, does it go in the install
docs, or in the docs next to each GUC item?

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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: PostgreSQL vs. MySQL
Next
From: Greg Spiegelberg
Date:
Subject: Re: Compare rows