Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting effective_cache_size in integer form with the 8kb block units - Mailing list pgsql-admin

From Wells Oliver
Subject Re: Setting effective_cache_size in integer form with the 8kb block units
Date
Msg-id CAOC+FBXgR2d3sy5EJPKwU2Dvp6ZD9vby1LEXWY=tkCW69KOxow@mail.gmail.com
Whole thread Raw
In response to Re: Setting effective_cache_size in integer form with the 8kb block units  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Setting effective_cache_size in integer form with the 8kb block units  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Setting effective_cache_size in integer form with the 8kb block units
Next
From: "David G. Johnston"
Date:
Subject: Re: Setting effective_cache_size in integer form with the 8kb block units