Re: "--tuning" compile and runtime option (?)

Поиск
Список
Период
Сортировка
От John Gray
Тема Re: "--tuning" compile and runtime option (?)
Дата
Msg-id E14muoz-0007W2-00@main.cabbage.uklinux.net
обсуждение исходный текст
Ответ на "--tuning" compile and runtime option (?)  (Justin Clift <jclift@iprimus.com.au>)
Ответы Re: Re: "--tuning" compile and runtime option (?)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
I can understand why there might be some resistance to the idea of
adding performance tuning flags into the server rather than documenting
existing settings better, but I think a compromise would be possible.

Could we develop a helper application that takes the  --tuning
superserver argument and translates that into a set of options to pass?
That way, fine-tuning by hand is still practical, but for those who just
want a good first set of values, a tuning helper application that looks
at system memory, processor speed, and a user-supplied indication of the
system's purpose and produces a set of postmaster options  might be the
way to approach this. And we don't bloat the server with extra
algorithms. There is no dependency on this utility, either (assuming we
continue to use workable defaults for postmaster options!) but it may
benefit some people to use it. 

I really like the performance hints thing too. 

John

-- 
John Gray
Tel +44-7974-100-584
mailto:jgray@beansindustry.co.uk




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Giles Lean
Дата:
Сообщение: Re: Re: Call for platforms
Следующее
От: Alvar Freude
Дата:
Сообщение: Indexes not used in 7.1RC4: Bug?