Re: PostgreSQL vs. MySQL

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL vs. MySQL
Date: 2003-07-04 18:37:58
Message-ID: 200307041137.59148.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general pgsql-hackers pgsql-performance

People:

> 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 think we actually need much more than this. Kaarel on the Advocacy list has
volunteered to try to extend our "getting started" section to encompass some
basic tuning stuff. Of course, more people would be better.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2003-07-04 19:18:43 Re: PostgreSQL vs. MySQL
Previous Message Andrew Sullivan 2003-07-04 18:28:53 Re: PostgreSQL vs. MySQL

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-07-04 18:55:33 Re: Q: Executing functions at connect/disconnect?
Previous Message Andrew Sullivan 2003-07-04 18:28:53 Re: PostgreSQL vs. MySQL

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruno Wolff III 2003-07-04 18:58:03 Re: Compile error in current cvs (~1230 CDT July 4)
Previous Message Andrew Sullivan 2003-07-04 18:28:53 Re: PostgreSQL vs. MySQL

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-07-04 19:18:43 Re: PostgreSQL vs. MySQL
Previous Message Andrew Sullivan 2003-07-04 18:28:53 Re: PostgreSQL vs. MySQL