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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Setting effective_cache_size in integer form with the 8kb block units
Date: 2022-01-19 21:46:12
Message-ID: CAKFQuwbozweTCx=AQZABxF=53q92mn+i+M7GgeRXZBVuqfze=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2022-01-19 21:56:43 Re: Setting effective_cache_size in integer form with the 8kb block units
Previous Message Wells Oliver 2022-01-19 21:38:17 Setting effective_cache_size in integer form with the 8kb block units