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

Re: PostgreSQL Configuration Tool for Dummies - feedback adjustable control

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL Configuration Tool for Dummies - feedback adjustable control
Date: 2007-06-25 11:47:43
Message-ID: f5oa0f$1aoa$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-performance
<david(at)lang(dot)hm> wrote in message 
news:Pine(dot)LNX(dot)4(dot)64(dot)0706221144290(dot)14942(at)asgard(dot)lang(dot)hm(dot)(dot)(dot)
> 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)
>

You are right. But an automatic tool beeing able to take decisions by 
different inputs, would be able to set a startup configuration too, based on 
the hw/sw environment, and interactive user requirements.

> 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.
>

Well, I think to an automatic tool, not an utopian application good for 
everything. For instance the existing automatic daemon have some abilities, 
bat not all of the VACUUM command. I'm realistic that good things may be 
done in steps, not once.

I would be super happy if an available automatic configuration tool would be 
able to set for the beginning just the shared_buffers or  max_fsm_pages 
based on the available memory. Adjustments can be done later.

Regards,
Sabin 



In response to

pgsql-performance by date

Next:From: Jean-David BeyerDate: 2007-06-25 13:06:55
Subject: Re: Performance query about large tables, lots of concurrent access
Previous:From: Michael StoneDate: 2007-06-25 11:37:48
Subject: Re: Performance query about large tables, lots of concurrent access

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