From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Andrew Sullivan <andrew(at)libertyrms(dot)info> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: PostgreSQL vs. MySQL |
Date: | 2003-10-08 17:49:55 |
Message-ID: | 200310081049.55816.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-general pgsql-hackers pgsql-performance |
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.
--
Josh Berkus
Aglio Database Solutions
San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-10-08 17:58:57 | Re: PostgreSQL vs. MySQL |
Previous Message | Bruce Momjian | 2003-10-08 17:28:53 | Re: PostgreSQL vs. MySQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-10-08 17:58:57 | Re: PostgreSQL vs. MySQL |
Previous Message | Grant Rutherford | 2003-10-08 17:48:09 | Displaying a float8 as a full-length number |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-10-08 17:58:57 | Re: PostgreSQL vs. MySQL |
Previous Message | Bruce Momjian | 2003-10-08 17:48:43 | Re: [HACKERS] pg_restore -d doesn't display output |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-10-08 17:58:57 | Re: PostgreSQL vs. MySQL |
Previous Message | Neil Conway | 2003-10-08 17:43:31 | Re: Sun performance - Major discovery! |