Skip site navigation (1) Skip section navigation (2)

Re: Feature Request --- was: PostgreSQL PerformanceTuning

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Michael Stone <mstone+postgres(at)mathom(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Feature Request --- was: PostgreSQL PerformanceTuning
Date: 2007-04-27 14:36:52
Message-ID: 1177684612.20922.154.camel@archimedes (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: H.J. SandersDate: 2007-04-27 15:03:09
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Previous:From: Tom LaneDate: 2007-04-27 14:36:40
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning

pgsql-general by date

Next:From: Tom LaneDate: 2007-04-27 14:44:04
Subject: Re: Preferred Installation/Data Directories
Previous:From: Tom LaneDate: 2007-04-27 14:36:40
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group