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

From Andrew Sullivan
Subject Re: PostgreSQL vs. MySQL
Date
Msg-id 20030704182853.GK4707@libertyrms.info
Whole thread Raw
In response to Re: PostgreSQL vs. MySQL  ("Arjen van der Meijden" <acm@tweakers.net>)
Responses Re: PostgreSQL vs. MySQL
Re: PostgreSQL vs. MySQL
List pgsql-performance
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


pgsql-performance by date:

Previous
From: "Arjen van der Meijden"
Date:
Subject: Re: PostgreSQL vs. MySQL
Next
From: Josh Berkus
Date:
Subject: Re: PostgreSQL vs. MySQL