Re: [HACKERS] Changing the default configuration (was Re:

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [HACKERS] Changing the default configuration (was Re:
Дата
Msg-id Pine.LNX.4.44.0302121912150.2811-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: [HACKERS] Changing the default configuration (was Re:  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] Changing the default configuration (was Re:  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] Changing the default configuration (was Re:  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-advocacy
Tom Lane writes:

> Well, as I commented later in that mail, I feel that 1000 buffers is
> a reasonable choice --- but I have to admit that I have no hard data
> to back up that feeling.

I know you like it in that range, and 4 or 8 MB of buffers by default
should not be a problem.  But personally I think if the optimal buffer
size does not depend on both the physical RAM you want to dedicate to
PostgreSQL and the nature and size of the database, then we have achieved
a medium revolution in computer science. ;-)

--
Peter Eisentraut   peter_e@gmx.net


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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: [HACKERS] Changing the default configuration (was Re:
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Changing the default configuration (was Re: