Re: Feature Request --- was: PostgreSQL Performance Tuning

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 Performance Tuning
Date: 2007-04-27 14:36:52
Message-ID: 1177684612.20922.154.camel@archimedes
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-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

Browse pgsql-general by date

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

Browse pgsql-performance by date

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