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 CAKFQuwbU1+tOVMSc-wzW4gxXVSxdhDRkgjFB4m115pNyMUW-aQ@mail.gmail.com
Whole thread Raw
In response to Re: 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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
On Wed, Jan 19, 2022 at 2:57 PM Wells Oliver <wells.oliver@gmail.com> wrote:
It does. In a cruel twist of fate, RDS parameter groups do not allow "48GB" and want integer values.

The system operates and calculates memory in binary per the referenced documentation so 6,291,456 (I double-checked this).

Assuming RDS doesn't do something to that as well...

David J.

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: Setting effective_cache_size in integer form with the 8kb block units
Next
From: Tom Lane
Date:
Subject: Re: Setting effective_cache_size in integer form with the 8kb block units