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

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: Setting effective_cache_size in integer form with the 8kb block units
Дата
Msg-id CAOC+FBXgR2d3sy5EJPKwU2Dvp6ZD9vby1LEXWY=tkCW69KOxow@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Setting effective_cache_size in integer form with the 8kb block units  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Setting effective_cache_size in integer form with the 8kb block units  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
Дерево обсуждения
It does. In a cruel twist of fate, RDS parameter groups do not allow "48GB" and want integer values.

On Wed, Jan 19, 2022 at 1:46 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: 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