Re: Overhauling GUCS - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Overhauling GUCS
Date
Msg-id 4846F19F.7060408@dunslane.net
Whole thread Raw
In response to Re: Overhauling GUCS  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: Overhauling GUCS  ("David E. Wheeler" <david@kineticode.com>)
Re: Overhauling GUCS  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers

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





pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: Overhauling GUCS
Next
From: "David E. Wheeler"
Date:
Subject: Re: Overhauling GUCS