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

Re: [HACKERS] Changing the default configuration

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Daniel Kalchev <daniel(at)digsys(dot)bg>
Cc: Jason Hihn <jhihn(at)paytimepayroll(dot)com>,PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>,pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [HACKERS] Changing the default configuration
Date: 2003-02-14 15:59:12
Message-ID: 1045238352.12931.620.camel@camel (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackers
On Fri, 2003-02-14 at 03:00, Daniel Kalchev wrote:
> >>>Jason Hihn said:
>  > Pardon my ignorance, but there's no way to auto-tune? Ship it with a thread
>  > that gathers statistics and periodically re-tunes the database parameters.
>  > Of course, be able to turn it off. People that actually take the time to run
>  > tune manually will turn it off as to not have the overhead or interruption.
>  > Those that don't care about pg_tune shouldn't care about having a thread
>  > around retuning. Those that will care will tune manually.
> 
> This is related to my proposition, but trouble is, there is not such thing as 
> 'well tuned database' that will suit all queries. You can tune the database to 
> the hardware for example (still remember that old argument on random access 
> and fast disks).
> 
> It seems the system could 'self-tune' itself on minor choices. I believe it 
> does this today for a number of things already. More significant changes 
> require the DBA consent and choice - but they need to be well informed of the 
> current usage statistics when making the choice.
> 

I agree. Given that we don't have solid explanations on telling people
how to tune the different parameters, nor do we have enough mechanisms
for actually giving people the information they need to determine the
changes they need, a complete auto-tune seems premature.

Robert Treat



In response to

pgsql-hackers by date

Next:From: Patrick WelcheDate: 2003-02-14 16:00:05
Subject: Re: psql and readline
Previous:From: Manfred KoizarDate: 2003-02-14 15:53:07
Subject: Re: Brain dump: btree collapsing

pgsql-advocacy by date

Next:From: johnnnnnnDate: 2003-02-14 16:33:14
Subject: Re: Tuning scenarios (was Changing the default configuration)
Previous:From: Tom LaneDate: 2003-02-14 15:07:45
Subject: Re: Offering tuned config files

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