Re: postgresql.conf (Proposed settings)

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: postgresql.conf (Proposed settings)
Дата
Msg-id Pine.LNX.4.30.0111202318300.613-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: postgresql.conf (Proposed settings)  (mlw <markw@mohawksoft.com>)
Ответы Re: postgresql.conf (Proposed settings)
Список pgsql-hackers
mlw writes:

> These are just ballpark settings, I don't even know how good they are. The problem
> is that server environments differ so greatly that there is no right answer.

Which is why this is clearly not a solution.

> I am just really concerned that the newbe PostgreSQL user will assume
> the performance they see with the default settings are what they will
> judge PostgreSQL.

For this kind of "newbie", the kind that doesn't read the documentation,
this would only make it worse, because they'd assume that by making the
choice between three default configurations they've done an adequate
amount of tuning.  Basically, you'd exchange, "I can't find any tuning
information, but it's slow" for "I did all the tuning and it's still
slow".  Not a good choice.

The bottom line is that you *must* edit postgresql.conf in order to tune
your server.  If this editing is simplified it doesn't matter what the
default is.

-- 
Peter Eisentraut   peter_e@gmx.net



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: OCTET_LENGTH is wrong
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: OCTET_LENGTH is wrong