Re: Super Optimizing Postgres

Поиск
Список
Период
Сортировка
От Serguei Mokhov
Тема Re: Super Optimizing Postgres
Дата
Msg-id 083201c16ee2$34ea0220$5dd9fea9@gunn
обсуждение исходный текст
Ответ на Super Optimizing Postgres  (mlw <markw@mohawksoft.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Call for testing
Следующее
От: teg@redhat.com (Trond Eivind Glomsrød)
Дата:
Сообщение: Re: 7.2b2 "make check" failure on Red Hat Linux 7.2