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

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Date: 2007-04-27 15:30:33
Message-ID: 20070427153029.GB2422@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

On Fri, Apr 27, 2007 at 07:36:52AM -0700, Mark Lewis wrote:
>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 :)

However you implement it, anyone who can answer all of those questions
is probably capable of reading and understanding the performance section
in the manual.

It's probably more practical to have a seperate script that looks at the
running system (ram, disks, pg config, db size, indices, stats, etc.)
and makes suggestions--if someone wants to write such a thing.

Mike Stone

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2007-04-27 16:12:21 Re: Feature Request --- was: PostgreSQL Performance Tuning
Previous Message H.J. Sanders 2007-04-27 15:03:09 Re: Feature Request --- was: PostgreSQL Performance Tuning

Browse pgsql-performance by date

  From Date Subject
Next Message Siddharth Anand 2007-04-27 15:30:51 [Fwd: ] How
Previous Message H.J. Sanders 2007-04-27 15:03:09 Re: Feature Request --- was: PostgreSQL Performance Tuning