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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-performance by date

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

pgsql-general by date

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

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