Re: Changing the default configuration

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Changing the default configuration
Дата
Msg-id 20030212.101026.71083976.t-ishii@sra.co.jp
обсуждение исходный текст
Ответ на Re: Changing the default configuration (was Re: [pgsql-advocacy]  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список pgsql-hackers
It's interesting that people focus on shared_buffers. From my
experience the most dominating parameter for performance is
wal_sync_method. It sometimes makes ~20% performance difference. On
the otherhand, shared_buffers does very little for
performance. Moreover too many shared_buffers cause performance
degration! I guess this is due to the poor design of bufmgr. Until it
is fixed, just increasing the number of shared_buffers a bit, say
1024, is enough IMHO.
--
Tatsuo Ishii


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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Changing the default configuration
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Changing the default configuration (was Re: [pgsql-advocacy]