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.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461