Re: Setting effective_cache_size in integer form with the 8kb block units

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Setting effective_cache_size in integer form with the 8kb block units
Дата
Msg-id CAKFQuwbozweTCx=AQZABxF=53q92mn+i+M7GgeRXZBVuqfze=g@mail.gmail.com
обсуждение исходный текст
Ответ на Setting effective_cache_size in integer form with the 8kb block units  (Wells Oliver <wells.oliver@gmail.com>)
Ответы Re: Setting effective_cache_size in integer form with the 8kb block units
Список pgsql-admin
Дерево обсуждения
On Wed, Jan 19, 2022 at 2:39 PM Wells Oliver <wells.oliver@gmail.com> wrote:
Sorry to be daft, but if I want 48GB for effective_cache size, should I put the integer value of 6291456 or 6000000?

Not quite sure how to spell out the 8kb units, decimal or binary...


Seems easier to just specify the units (which the docs for effective_cache_size says are accepted).

https://www.postgresql.org/docs/current/config-setting.html#CONFIG-SETTING-NAMES-VALUES

David J.

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