Re: Super Optimizing Postgres - Mailing list pgsql-hackers

From Serguei Mokhov
Subject Re: Super Optimizing Postgres
Date
Msg-id 083201c16ee2$34ea0220$5dd9fea9@gunn
Whole thread Raw
In response to Super Optimizing Postgres  (mlw <markw@mohawksoft.com>)
List pgsql-hackers
----- 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Call for testing
Next
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: 7.2b2 "make check" failure on Red Hat Linux 7.2