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

[Wells Oliver <wells.oliver@xxxxxxxxx>]

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@xxxxxxxxx> wrote:

On Wed, Jan 19, 2022 at 2:39 PM Wells Oliver <wells.oliver@xxxxxxxxx> 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.

--

Wells Oliver
wells.oliver@xxxxxxxxx