From: Andrew Dunstan <andrew@dunslane.net>
To: David E. Wheeler <david@kineticode.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Overhauling GUCS
Date: Wed, 04 Jun 2008 15:48:47 -0400
Message-ID: <4846F19F.7060408@dunslane.net> (raw)
In-Reply-To: <ED198E85-983C-4B54-8F1A-592A2528FAA5@kineticode.com>
References: <48409D1E.3070208@agliodbs.com>
<484418D9.5040608@sun.com>
<Pine.GSO.4.64.0806021227100.4018@westnet.com>
<200806021106.05833.josh@agliodbs.com>
<0B854D92-C5C2-4138-A0FE-F81892A33869@sun.com>
<Pine.GSO.4.64.0806032324550.10282@westnet.com>
<72DA5875-8E89-4A6F-8D0B-7F9A869D79B9@kineticode.com>
<27574.1212603758@sss.pgh.pa.us>
<ED198E85-983C-4B54-8F1A-592A2528FAA5@kineticode.com>
David E. Wheeler wrote:
> On Jun 4, 2008, at 11:22, Tom Lane wrote:
>
>> "David E. Wheeler" <david@kineticode.com> writes:
>>> Exactly. The issue is that application developers, who are not DBAs,
>>> have no idea how to tune PostgreSQL, and postgresql.conf is daunting
>>> and confusing. So they use a different database that's "faster".
>>
>> I take it you haven't looked at mysql's configuration file lately.
>
> I'm not much into MySQL, but in the work I've done with it, I've had
> to create /etc/my.cnf myself. There *is* no configuration file
> configuring MySQL until that file is created, is there? So there is no
> configuration to learn at first. I'm not saying that this is
> necessarily admirable -- it's kind of the opposite end of the spectrum
> (PostgreSQL: "Here is every configuration tweak you could ever
> possibly want, have fun!" vs MySQL: "There is no configuration until
> you need one, then you have to find the docs for it."
Tell me how that's better.
If that's what you want, simply remove all the comment lines from your
config file. Problem solved.
>
>> They aren't actually in any better shape than we are, except that
>> they supply several "preconfigured" sample files for people to choose
>> from.
>
> Which would be a good start, if nothing else…
It's been suggested in the past. It is highly debatable that it would
actually be an advance.
cheers
andrew
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: andrew@dunslane.net, david@kineticode.com, tgl@sss.pgh.pa.us, gsmith@gregsmith.com, josh@agliodbs.com
Subject: Re: Overhauling GUCS
In-Reply-To: <4846F19F.7060408@dunslane.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox