Subject: Re: Feature Request --- was: PostgreSQL Performance
	Tuning
From: Mark Lewis <mark.lewis@mir3.com>
To: Michael Stone <mstone+postgres@mathom.us>
Cc: pgsql-performance@postgresql.org
In-Reply-To: <20070427143023.GA2422@mathom.us>
References: 
 <OFC96167D5.6BB63AC2-ON652572C9.003B5263-652572C9.003E4142@lntinfotech.com>
	<46310247.2050802@pinpointresearch.com> <463158DD.3060602@mochima.com>
	<2679.1177642153@sss.pgh.pa.us> <4631FA55.4010406@mochima.com>
	<20070427143023.GA2422@mathom.us>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Organization: MIR3, Inc.
Date: Fri, 27 Apr 2007 07:36:52 -0700
Message-Id: <1177684612.20922.154.camel@archimedes>
Mime-Version: 1.0

Maybe he's looking for a switch for initdb that would make it
interactive and quiz you about your expected usage-- sort of a magic
auto-configurator wizard doohicky?  I could see that sort of thing being
nice for the casual user or newbie who otherwise would have a horribly
mis-tuned database.  They could instead have only a marginally mis-tuned
database :)

On Fri, 2007-04-27 at 10:30 -0400, Michael Stone wrote:
> On Fri, Apr 27, 2007 at 09:27:49AM -0400, Carlos Moreno wrote:
> >Notice that the second part of my suggestion covers this --- have 
> >additional
> >switches to initdb so that the user can tell it about estimates on how 
> >the DB
> >will be used:  estimated size of the DB, estimated percentage of 
> >activity that
> >will involve writing, estimated percentage of activity that will be 
> >transactions,
> >percentage that will use indexes, percentage of queries that will be 
> >complex,
> >etc. etc.
> 
> If the person knows all that, why wouldn't they know to just change the 
> config parameters?
> 
> Mike Stone
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org