shared_buffers documentation

Поиск
Список
Период
Сортировка
От Robert Haas
Тема shared_buffers documentation
Дата
Msg-id x2w603c8f071004140805xc38061a0w70a8a6f972e17c35@mail.gmail.com
обсуждение исходный текст
Ответы Re: shared_buffers documentation
Список pgsql-hackers
TFM says:

Sets the amount of memory the database server uses for shared memory
buffers. The default is typically 32 megabytes (32MB), but might be
less if your kernel settings will not support it (as determined during
initdb). This setting must be at least 128 kilobytes. (Non-default
values of BLCKSZ change the minimum.) However, settings significantly
higher than the minimum are usually needed for good performance.
Several tens of megabytes are recommended for production
installations.

So if the default is 32MB, and what I'm actually supposed to have is
"several tens of megabytes", isn't that pretty much the same thing?  I
think this advice is badly outdated.  s/tens/hundreds/ might be a good
idea at a minimum, but I'm thinking we might want to also mention the
one-quarter-of-system-memory heuristic.

...Robert


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

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: standbycheck was:(Re: [HACKERS] testing hot standby
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: shared_buffers documentation