Re: PostgreSQL Configuration Tool for Dummies - feedback adjustable control

From: david(at)lang(dot)hm
To: Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL Configuration Tool for Dummies - feedback adjustable control
Date: 2007-06-22 18:47:20
Message-ID: Pine.LNX.4.64.0706221144290.14942@asgard.lang.hm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 (e.g
> http://pgfouine.projects.postgresql.org/index.html ) ?

something like this would be useful for advanced tuneing, but the biggest
problem is that it's so difficult to fingoure out a starting point. bad
choices at the starting point can cause several orders of magnatude
difference in the database performsnce. In addition we know that the
current defaults are bad for just about everyone (we just can't decide
what better defaults would be)

this horrible starting point gives people a bad first impression that a
simple tool like what's being discussed can go a long way towards solving.

David Lang

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Glaesemann 2007-06-22 19:51:32 Re: Slow join query
Previous Message Tom Tamulewicz 2007-06-22 18:32:15 Slow join query