Re: [PERFORM] PostgreSQL vs. MySQL

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: Re: [PERFORM] PostgreSQL vs. MySQL
Date: 2003-08-17 00:36:57
Message-ID: 200308170036.h7H0avV17926@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general pgsql-hackers pgsql-performance


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(at)libertyrms(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Dan Langille 2003-08-17 02:09:40 Re: [HACKERS] What goes into the security doc?
Previous Message Bruce Momjian 2003-08-16 23:55:05 Re: [GENERAL] pam-linux, /etc/shadow : HOW-TO

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-08-17 02:41:39 Re: [HACKERS] Are we losing momentum?
Previous Message Bruce Momjian 2003-08-16 23:55:05 Re: [GENERAL] pam-linux, /etc/shadow : HOW-TO

Browse pgsql-hackers by date

  From Date Subject
Next Message Dan Langille 2003-08-17 02:09:40 Re: [HACKERS] What goes into the security doc?
Previous Message Bruce Momjian 2003-08-17 00:14:26 Re: Error message style guide, take 2

Browse pgsql-performance by date

  From Date Subject
Next Message David Emery 2003-08-17 03:48:24 Re: Benchmark
Previous Message Christopher Browne 2003-08-16 22:22:48 Re: Insert performance