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

Re: New project launched : PostgreSQL GUI Installer for

From: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: New project launched : PostgreSQL GUI Installer for
Date: 2006-01-31 20:01:22
Message-ID: 1138737682.5648.1.camel@toonses.gghcwest.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, 2006-01-31 at 13:02 -0600, Jim C. Nasby wrote:
> On Tue, Jan 31, 2006 at 11:46:03AM +0000, Andreas Pflug wrote:
> > Tino Wildenhain wrote:
> > 
> > >
> > >Figuring out the correct values for some of the buffers and costs
> > >is still a bit tough. Otoh, I guess there is no easy way to predict
> > >all these.
> > 
> > pgAdmin has a mechanism to suggest values (currently for autovacuum and 
> > listen_address only), which waits for expansion :-) I could think of a 
> > wizard that asks decent questions, resulting in proposals.
> > 
> > Whether implemented as GUI or not, a questionaire and suggested 
> > algorithms to calculate settings (eyeballed from Core) would be a good 
> > starting point.
> 
> PostgreSQL *desperately* needs a better means of dealing with
> configuration (though I guess I shouldn't be pushing too hard for this
> since the current state of affairs brings me business). Any improvement
> in this area would be very welcome.
> http://pgfoundry.org/projects/configurator/ is something worth looking
> at.

An ideal facility would be a program that analyzes the workload at
runtime and adjusts accordingly.  That doesn't sound too hard, within
some unambitious boundary.  If anyone would like to work on this, I'd be
happy to contribute.

-jwb

In response to

Responses

pgsql-hackers by date

Next:From: Michael PaesoldDate: 2006-01-31 20:04:34
Subject: Re: Tab completion of SET TRANSACTION ISOLATION
Previous:From: Jim C. NasbyDate: 2006-01-31 19:52:05
Subject: Re: VACUUM Question

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