pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Wells Oliver <wells.oliver@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Setting effective_cache_size in integer form with the 8kb block units
Date: Wed, 19 Jan 2022 17:21:01 -0500
Message-ID: <770649.1642630861@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwbU1+tOVMSc-wzW4gxXVSxdhDRkgjFB4m115pNyMUW-aQ@mail.gmail.com>
References: <CAOC+FBW5J8yDkbiaU7WVi=-FcpAtFwOQHU+z6GW9wfbK-PgkvA@mail.gmail.com>
	<CAKFQuwbozweTCx=AQZABxF=53q92mn+i+M7GgeRXZBVuqfze=g@mail.gmail.com>
	<CAOC+FBXgR2d3sy5EJPKwU2Dvp6ZD9vby1LEXWY=tkCW69KOxow@mail.gmail.com>
	<CAKFQuwbU1+tOVMSc-wzW4gxXVSxdhDRkgjFB4m115pNyMUW-aQ@mail.gmail.com>

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> 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).

If you don't trust hand arithmetic, try

regression=# set effective_cache_size to '48GB';
SET
regression=# select setting from pg_settings where name = 'effective_cache_size';
 setting 
---------
 6291456
(1 row)

			regards, tom lane

view thread (6+ messages)  latest in thread

Message-ID: <770649.1642630861@sss.pgh.pa.us>
Permalink:  ../770649.1642630861@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/770649.1642630861@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, wells.oliver@gmail.com
  Subject: Re: Setting effective_cache_size in integer form with the 8kb block units
  In-Reply-To: <770649.1642630861@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox