pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <gsmith@gregsmith.com>
To: Sabin Coanda <sabin.coanda@deuromedia.ro>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL Configuration Tool for Dummies - feedback adjustable control
Date: Sat, 23 Jun 2007 15:44:04 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0706231535481.1349@westnet.com> (raw)
In-Reply-To: <f5giih$1kt2$1@news.hub.org>
References: <A3AC4FA47DC0B1458C3E5396E685E63302395E63@SAB-DC1.sab.uiuc.edu>
	<f5giih$1kt2$1@news.hub.org>

On Fri, 22 Jun 2007, Sabin Coanda wrote:

> Instead of (or in addition to) configure dozens of settings, what do you 
> say about a feedback adjustable control based on the existing system 
> statistics and parsing logs

Take a look at the archive of this list for the end of April/Early May. 
There's a thread there named "Feature Request --- was: PostgreSQL 
Performance Tuning" that addressed this subject in length I think you'll 
find interesting reading.

I personally feel there's much more long-term potential for a tool that 
inspects the database, but the needs of something looking for getting good 
starting configuration file (before there necessarily is even a populated 
database) is different enough that it may justify building two different 
tools.

I would suggest you or anything else building the starter configuration 
tool not stray from the path of getting the most important variables set 
to reasonable values.  Trying to satisfy every possible user is the path 
that leads to a design so complicated that it's unlikely you'll ever get a 
finished build done at all.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD



view thread (42+ messages)  latest in thread

Message-ID: <Pine.GSO.4.64.0706231535481.1349@westnet.com>
Permalink:  ../Pine.GSO.4.64.0706231535481.1349@westnet.com/
Also on:    postgresql.org/message-id/Pine.GSO.4.64.0706231535481.1349@westnet.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gsmith@gregsmith.com, sabin.coanda@deuromedia.ro
  Subject: Re: PostgreSQL Configuration Tool for Dummies - feedback adjustable control
  In-Reply-To: <Pine.GSO.4.64.0706231535481.1349@westnet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox