Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Setting effective_cache_size in integer form with the 8kb block units
Date
Msg-id CAKFQuwbozweTCx=AQZABxF=53q92mn+i+M7GgeRXZBVuqfze=g@mail.gmail.com
Whole thread Raw
In response to Setting effective_cache_size in integer form with the 8kb block units  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: Setting effective_cache_size in integer form with the 8kb block units  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view
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: Wells Oliver
Date:
Subject: Setting effective_cache_size in integer form with the 8kb block units
Next
From: Wells Oliver
Date:
Subject: Re: Setting effective_cache_size in integer form with the 8kb block units