Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l5AlU-0003Xd-QJ for pgsql-admin@arkaria.postgresql.org; Thu, 28 Jan 2021 17:07:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l5AlT-0004zF-Ny for pgsql-admin@arkaria.postgresql.org; Thu, 28 Jan 2021 17:07:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l5AlT-0004z8-Bs for pgsql-admin@lists.postgresql.org; Thu, 28 Jan 2021 17:07:27 +0000 Received: from mail-qk1-x72c.google.com ([2607:f8b0:4864:20::72c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1l5AlM-000476-5G for pgsql-admin@postgresql.org; Thu, 28 Jan 2021 17:07:27 +0000 Received: by mail-qk1-x72c.google.com with SMTP id v126so5905860qkd.11 for ; Thu, 28 Jan 2021 09:07:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=wKU1TtUhOCFhBXnoTAECleWfNqyRdzbXahoNkm+JvRs=; b=MwaomS73Vo0M3m8Heny+Jagke0uQfTCdcz1W8COZlQ+CKCQcKVuRMoC5zk3wuECfwp hh8s/ZjRrl2h0Kb1QcvJ8fHGNL4K6xzZ63f9Q2dLbCWl5Yx8hY0lzsJWBGlBUI/x9pAC DAdn4fxSvxhAyoraGMwOAO27IvFYtRFBSjX0tzv0nBAaNF9epy36caCjNsn8zf8oBNLp Gr+tVimw8Aj17HwqA8ogxBls9wiNEP+KdL6RML5Wl4FxBJhbviTllPvxbK98EwkdqR+r TYaxOORO7xHms6AAOSgQgwRdiPkaRuqNH3WYEhuljXDvDAOpQWNphh/8LSJmHnczX7/V GDvA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=wKU1TtUhOCFhBXnoTAECleWfNqyRdzbXahoNkm+JvRs=; b=gmzKDvXJDBVGQRmy29ltGjILZdjENrOEXRp0kIiQSBRcPn08vC096KhjYG7It9IQwG JzuFwRZW93ZEanW0WAz9F7wfFJz2lHEsSTvCIQsIfb2hhvIlHxUOfnsFSkEHomYv2Igt elUANhNDSwh9HIdEzOrRUIOukMfF9+okvP727sTX6xMvgqbMu1PT5m8/cmtY113nCEWG Ye25mABigQfoX9F1zhc9SzX8pAft4LwOnc+uRdS1VG9A0E7C3r0vn9Y9oD5ZsG+yEkgF 8HvHEK9Tzb/QTjHO3BDpcUE+3mmo63XtgrxvRzacblNAavB3Hls3mNmkGF9NWFeEap0x 1pbA== X-Gm-Message-State: AOAM5304qYRSzNgdgnGxQJvgxemOW6n9g0J48rdPOfeFL7w8YKTr58ui PCQYNhuq5MeQIkf/zANUu78= X-Google-Smtp-Source: ABdhPJySiYK7Ry2UCgyrLBCGCRArH609BvsMD5lfBZ3lvM+7T0+QNqCjnaNflgussbMWflN8/77kyA== X-Received: by 2002:a37:7104:: with SMTP id m4mr128276qkc.5.1611853638396; Thu, 28 Jan 2021 09:07:18 -0800 (PST) Received: from [192.168.254.67] (h178.165.133.40.static.ip.windstream.net. [40.133.165.178]) by smtp.gmail.com with ESMTPSA id t51sm3932177qte.8.2021.01.28.09.07.17 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 28 Jan 2021 09:07:17 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-CE648DC7-C90E-4CDD-AC43-FA2F31425705 Content-Transfer-Encoding: 7bit From: John Scalia Mime-Version: 1.0 (1.0) Subject: Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL Date: Thu, 28 Jan 2021 12:07:16 -0500 Message-Id: <203AACAF-0E4E-4FCF-8A28-F3363663037B@gmail.com> References: Cc: pgsql-admin@postgresql.org In-Reply-To: To: dbatoCloud Solution X-Mailer: iPad Mail (18C66) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-CE648DC7-C90E-4CDD-AC43-FA2F31425705 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Ok, it took a me a bit to locate one of my servers that is the same size as y= ours. Now, I did not set this one up, I only inherited it, but it is config= ured the same as yours, i.e., using that same formula. When I log into it, h= owever, and type: show shared_buffers; it reports 21555264kB. A db.r5.xlarge= has 32 GB of memory according to AWS and by my calculations the value for s= hared_buffers is 20.56GB (21555264/1024/1024) Not quite the 75% value, but t= his is far greater than the 8GB you=E2=80=99re asking for. So, are you tryin= g to limit it to this lower value, and have you queried yours to see what th= e shared_buffers is set to? Sent from my iPad > On Jan 28, 2021, at 11:30 AM, dbatoCloud Solution = wrote: >=20 > =EF=BB=BF > Hi,=20 > Ok Sure. But in the parameter group , i can see like this SUM({DBInstance= ClassMemory/12038},-50003) . How to calculate it ? where should I update it= . Should I do change it in 12038 value. >=20 > What is meant by DBInstanceClassMemory? My RDS instance shape is "db.r5.xl= arge". I am confused with this parameter?=20 >=20 > Can you please help me? >=20 > =20 >=20 > Thanks & Best Wishes, >=20 > Ashok >=20 > =20 >=20 > --------------------------------------------------------------------------= ------------------------------------------- >=20 > Ashokkumar Mani (OCP12c/11g/10g/9i, AWS SAA, M103) >=20 > Dubai , UAE | BLR , INDIA >=20 > M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922 >=20 > W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com=20 >=20 >=20 >=20 >> On Thu, Jan 28, 2021 at 9:44 PM John Scalia wrot= e: >> Well, you should understand the AWS recommends a 75% setting, or 24GB in t= heir documentation. So, why don=E2=80=99t you just set the value as somethin= g like that in your database parameter group settings. >>=20 >>=20 >> Sent from my iPad >>=20 >>>> On Jan 28, 2021, at 10:55 AM, dbatoCloud Solution wrote: >>>>=20 >>> =EF=BB=BF >>> Hi John, >>> Yes, I calculated as per pgtune(https://pgtune.leopard.in.ua/#/) >>> advisor. I took 25% of physical memory 32GB in AWS RDS PostgreSQL which= is 8GB.=20 >>>=20 >>>> AWS PostgreSQL Configuration: - >>> >>>=20 >>> =20 >>>=20 >>> >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> How to update the shared_buffer into 8GB in the AWS RDS Parameter Group h= ere below? >>>=20 >>> >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>> Thanks & Best Wishes, >>>=20 >>> Ashok >>>=20 >>> =20 >>>=20 >>> ------------------------------------------------------------------------= --------------------------------------------- >>>=20 >>> Ashokkumar Mani (OCP12c/11g/10g/9i, AWS SAA, M103) >>>=20 >>> Dubai , UAE | BLR , INDIA >>>=20 >>> M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922 >>>=20 >>> W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com=20= >>>=20 >>>=20 >>>=20 >>>> On Thu, Jan 28, 2021 at 6:05 PM dbatoCloud Solution wrote: >>>> Hi All, >>>>=20 >>>> I want to increase the size of shared_buffers in AWS RDS postgreSQL 10.= 11. When I see it in the DB parameter group in AWS it says "SUM({DBInstance= ClassMemory/12038},-50003)" and at the instance level I see 2694408 . >>>>=20 >>>> Please let me know how to calculate and change the value for 8GB? >>>> =20 >>>>=20 >>>> =20 >>>>=20 >>>> Thanks & Best Wishes, >>>>=20 >>>> Ashok >>>>=20 >>>> =20 >>>>=20 >>>> -----------------------------------------------------------------------= ---------------------------------------------- >>>>=20 >>>> Ashokkumar Mani (OCP12c/11g/10g/9i, AWS SAA, M103) >>>>=20 >>>> Dubai , UAE | BLR , INDIA >>>>=20 >>>> M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922 >>>>=20 >>>> W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com=20= --Apple-Mail-CE648DC7-C90E-4CDD-AC43-FA2F31425705 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Ok, it took a me a bit to locate one of my s= ervers that is the same size as yours.  Now, I did not set this one up,= I only inherited it, but it is configured the same as yours, i.e., using th= at same formula. When I log into it, however, and type: show shared_buffers;= it reports 21555264kB. A db.r5.xlarge has 32 GB of memory according to AWS a= nd by my calculations the value for shared_buffers is 20.56GB (21555264/1024= /1024) Not quite the 75% value, but this is far greater than the 8GB you=E2=80= =99re asking for. So, are you trying to limit it to this lower value, and ha= ve you queried yours to see what the shared_buffers is set to?

Sent from my iPad

On Jan 28, 2021, at 11:30 AM, dbatoCloud Solution <dbatocloud17@gmai= l.com> wrote:

=EF=BB=BF
Hi,
Ok Sure. But in the parameter group , i can see =20 like this SUM({DBInstanceClassMemory/12038},-50003)  . How to calculate it ? where should I update it . Should I do c= hange it in 12038 value.

<= span class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;font-si= ze:small">What is meant by DBInstanceClassMemory? My RDS instance shape is=20= "db.r5.xlarge". I am confused with this parameter?=

Can you p= lease help me?

 

Thanks & Best= Wishes,

Ashok

 

-----------------------------------------------------= ----------------------------------------------------------------

A= shokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UA= E | BLR , I= NDIA

M:= +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W:= https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com



On Thu, Jan 28, 2021 at 9:44 PM John Scalia <jayknowsunix@gmail.com> wrote:
Well, y= ou should understand the AWS recommends a 75% setting, or 24GB in their docu= mentation. So, why don=E2=80=99t you just set the value as something like th= at in your database parameter group settings.


S= ent from my iPad

On Jan 2= 8, 2021, at 10:55 AM, dbatoCloud Solution <dbatocloud17@gmail.com> wrote:

<= /blockquote>
=EF=BB=BF
Hi John,
Yes, I calculated as per pgtune= (https://pgtun= e.leopard.in.ua/#/)
 advisor. I took 25% of physical= memory 32GB in AWS RDS PostgreSQL which is 8GB. 

AWS PostgreS= QL Configuration: -
<image.png>

=

 

<image.png>

<= br>


How to u= pdate the shared_buffer into 8GB in the AWS RDS Parameter Group here below?<= /span>

<image.png>




<= /p>

Thanks & B= est Wishes,

Ashok

 

-----------------------------------------------------= ----------------------------------------------------------------

A= shokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UA= E | BLR , I= NDIA

M:= +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W:= https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com



On Thu, Jan 28, 2021 at 6:05 PM dbatoCloud Solution <= dbatocloud17@gma= il.com> wrote:
Hi All,
I want to increase the size of shared_buffers i= n AWS RDS postgreSQL 10.11.  When I see it in the DB parameter group in= AWS it says "SUM({DBInstanceClassMemory/12038},-50003)"  and at the in= stance level I see 2694408 .

Please let  me know how to calculate and  change the v= alue for 8GB?

 

 

Thanks & Best= Wishes,

Ashok

 

-----------------------------------------------------= ----------------------------------------------------------------

A= shokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UA= E | BLR , I= NDIA

M:= +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W:= https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com

= --Apple-Mail-CE648DC7-C90E-4CDD-AC43-FA2F31425705--