Re: Super Optimizing Postgres

----- Original Message ----- 
From: mlw <markw@mohawksoft.com>
Sent: Friday, November 16, 2001 8:45 AM

> Does anyone think it is a good idea, to make a postgresql.conf cookbook sort of
> thing? Gather a number of tuned config files, annotated as to why the settings
> are set the way they are, and the machine on which they run.

Sounds like a very good idea, but... who's gonna be in charge of it?

> Alternatively, it should be possible to write a program that analyzes a target
> system, asks questions like: "Is this a dedicated server?" "How much ram do you
> have?" "On which volume will the database be installed?" Then perform some
> tests that mimic the cost values, and create a new postgresql.conf with the
> options tuned.

This program sounds like a little rule-based expert system-like software :)
"Tune your PostgreSQL server with a pgTune expert system!" an ad
would be voicing out loud...

--
Serguei A. Mokhov