Subject: Re: Overhauling GUCS
From: "Joshua D. Drake" <jd@commandprompt.com>
To: Andreas Pflug <pgadmin@pse-consulting.de>
Cc: Gregory Stark <stark@enterprisedb.com>, pgsql-hackers@postgresql.org
In-Reply-To: <4849C8A7.5030803@pse-consulting.de>
References: <Pine.GSO.4.64.0806041045520.2258@westnet.com>
	<29525.1212613052@sss.pgh.pa.us> <48472E47.7030701@dunslane.net>
	<Pine.GSO.4.64.0806042033120.3874@westnet.com>
	<20080605162400.GF16502@alvh.no-ip.org>	<48481CBF.6040602@enterprisedb.com>
	<48481E3A.4010306@hagander.net>
	<Pine.GSO.4.64.0806051321360.27711@westnet.com>
	<20080605174209.GL16502@alvh.no-ip.org>
	<Pine.GSO.4.64.0806051452480.27254@westnet.com>
	<20080605212129.GI14498@yugib.highrise.ca>
	<Pine.GSO.4.64.0806051725550.10475@westnet.com>
	<3F927D52-A0FD-4575-8D24-F0F70C459235@kineticode.com>
	<4848FAA6.8000903@pse-consulting.de>	<87ej7aeuqx.fsf@oxford.xeocode.com>
	<4849137C.3040008@pse-consulting.de>	<877id2erp6.fsf@oxford.xeocode.com>
	<48492356.4040506@pse-consulting.de> <1618.1212765176@sss.pgh.pa.us>
	<484985EF.8080403@pse-consulting.de>
	<87prqucp5x.fsf@oxford.xeocode.com>
	<4849C8A7.5030803@pse-consulting.de>
Content-Type: text/plain
Organization: Command Prompt, Inc.
Date: Fri, 06 Jun 2008 16:45:31 -0700
Message-Id: <1212795931.14299.3.camel@jd-laptop>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit


On Sat, 2008-06-07 at 01:30 +0200, Andreas Pflug wrote:
> Gregory Stark wrote:
> > "Andreas Pflug" <pgadmin@pse-consulting.de> writes:

> I think I made my point very clear when stating "not a file, but via
> SQL". Though I'm not a native English speaker, and I'm sure you
> understood. I must assume you're polluting this thread deliberately in
> order to sabotage the original intention of this thread. I find this
> disgusting.
> 
> Ok, trying to contribute gui tools for pgsql is for masochists. We have
> vi, sed and grep, no more tools required, right?

Hold on guys, let's not get all out of whack. No one in their right mind
is going to suggest that vi, sed and grep are the only tools we need to
do this.

However a GUI wizard isn't really a way to go either. SQL? Yes it would
be very nice to be able to:

BEGIN;
SET shared_buffers to 65536 COMMENT IS 'Since I have 4G of ram I want
512 megs of shared buffers';
SET effective_cache_size to 262144 COMMENT IS 'Since I have 4G of ram I
want 1 gig of effective_cache';
COMMIT;

When that is done, it would write out the postgresql.conf.

Regardless of all of this, this thread is way out of hand. We went from
overhauling the configuration file to wizards, sample postgresql.conf
files and possibly even half of us migrating to MySQL :P.

Can we refine the topic a bit?

Joshua D. Drake