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 1l5Bys-0006dQ-To for pgsql-admin@arkaria.postgresql.org; Thu, 28 Jan 2021 18:25:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l5Byr-0000Ve-Tp for pgsql-admin@arkaria.postgresql.org; Thu, 28 Jan 2021 18:25:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l5Byr-0000V5-8T for pgsql-admin@lists.postgresql.org; Thu, 28 Jan 2021 18:25:21 +0000 Received: from mail-qk1-x735.google.com ([2607:f8b0:4864:20::735]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1l5Byn-00057B-QJ for pgsql-admin@postgresql.org; Thu, 28 Jan 2021 18:25:19 +0000 Received: by mail-qk1-x735.google.com with SMTP id 19so6224593qkh.3 for ; Thu, 28 Jan 2021 10:25:17 -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=3Hm4lO9QbXlbpWAilvOx8fOoR+AhoHKIOd/cJBfE/bs=; b=GxXZIxfy1b3mappau3bubzGnC6sm4ZAzIbMVY0qe2iW7gyooRri6ANO2UgmVBU6QTD rAEhNC4YJrlW1oZ4IorE0h7dM8Ls0fBYnE5FPUwOcmNaPp7bjNQVMWl2RGzhMGG4oHVH 3SbndatZ/pOFDlrTE38ItF6bBXpl2+JbjnKEozJSDwSa191NcwiJTvY6S7Tp+QpRGPd2 /wAeGjQQWmfjycr7eFj0FlQCsDhanAl1XrB09Kh6gsUK97p6tlnLgmcglUCfs6KWay8F hLYcyESTQwQLf6aYMuMm/8B6wL/6UvSV0RmsOwXe2d3S5iyKpqGJVllOLculzzD8ltm4 WlAA== 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=3Hm4lO9QbXlbpWAilvOx8fOoR+AhoHKIOd/cJBfE/bs=; b=NMeVydAmlQapJJUHNHvO9ud0GqBVz2E/Ck+JjGuIqXWlXOGRjsLAn7NZIbri6O9ZN2 gwFu+Cf6/N1hYmudNEprbXpFKGQjEPe1u49d3DDcTtajnrTFjPRvS23mREPdPxksiJPn Deo1Y6RxNFwOr0owiqcYi6OsP7ssj+Qcaq8MWYKV3glC/u/5ueQU69AR7OVGSwG3sFpm qN+Xf4KcV2UeRWh0oGKH0lTDVTk90iGIf3aamY6WdLiWYeF2P0rNPXmC33ZXxwRszFaq FCb8YArJ0q7w7xBFYGfBYM99zq6Z1x+ByKUHj6jdvSU5ZiSeh/2ibWxEI0Cwnvr1+9Ir rzbw== X-Gm-Message-State: AOAM531rMDx81dZrFRmJQKvco3GakJxDJF8LJAvreZqZPd+Wy7L1TODx 2VbmmbeH0jG4qbITGxttpk0= X-Google-Smtp-Source: ABdhPJxn/p1/So8REPAw2VlN9coYkCMHk0ct8PxFuKX6R2tOq3l6wkV9A1N2s+OvoXgbMSzQAFxPHA== X-Received: by 2002:a05:620a:542:: with SMTP id o2mr505352qko.266.1611858316196; Thu, 28 Jan 2021 10:25:16 -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 r64sm4075479qkf.121.2021.01.28.10.25.15 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 28 Jan 2021 10:25:15 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-0D8ECE07-66AD-46CA-A09B-E3373F1A2B5F 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 13:25:11 -0500 Message-Id: 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-0D8ECE07-66AD-46CA-A09B-E3373F1A2B5F Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable That really doesn=E2=80=99t seem to correspond to an r5.xlarge instance then= , but you could always remove the calculation from the parameter group, and j= ust hard code the value you want. I would probably make a copy of the parame= ter group do this in, so you don=E2=80=99t lose the formula if you might nee= d it later. Remember that you need to restart the instance afterwards. Sent from my iPad > On Jan 28, 2021, at 12:33 PM, dbatoCloud Solution = wrote: >=20 > =EF=BB=BF > I have verified it already as per the calculation. The current shared buff= er is 2.5GB > (2694408/1024/1024). >=20 > Which I want to make it 8GB or 24G >=20 > How to update this is in AWS like below > SUM({DBInstanceClassMemory/12038},-50003) >=20 >=20 >> On Thu, Jan 28, 2021, 22:37 John Scalia wrote: >> Ok, it took a me a bit to locate one of my servers that is the same size a= s yours. Now, I did not set this one up, I only inherited it, but it is con= figured the same as yours, i.e., using that same formula. When I log into it= , however, and type: show shared_buffers; it reports 21555264kB. A db.r5.xla= rge has 32 GB of memory according to AWS and by my calculations the value fo= r shared_buffers is 20.56GB (21555264/1024/1024) Not quite the 75% value, bu= t this is far greater than the 8GB you=E2=80=99re asking for. So, are you tr= ying to limit it to this lower value, and have you queried yours to see what= the shared_buffers is set to? >>=20 >> Sent from my iPad >>=20 >>>> 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({DBInstan= ceClassMemory/12038},-50003) . How to calculate it ? where should I update i= t . Should I do change it in 12038 value. >>>=20 >>> What is meant by DBInstanceClassMemory? My RDS instance shape is "db.r5.= xlarge". 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 wr= ote: >>>> Well, you should understand the AWS recommends a 75% setting, or 24GB i= n their documentation. So, why don=E2=80=99t you just set the value as somet= hing 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 whi= ch 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 Grou= p here 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 1= 0.11. When I see it in the DB parameter group in AWS it says "SUM({DBInstan= ceClassMemory/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.co= m=20 --Apple-Mail-0D8ECE07-66AD-46CA-A09B-E3373F1A2B5F Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable That really doesn=E2=80=99t seem to corresp= ond to an r5.xlarge instance then, but you could always remove the calculati= on from the parameter group, and just hard code the value you want. I would p= robably make a copy of the parameter group do this in, so you don=E2=80=99t l= ose the formula if you might need it later. Remember that you need to restar= t the instance afterwards.

Sent from my iPad

On Jan 28, 2021, at 12:33 PM, d= batoCloud Solution <dbatocloud17@gmail.com> wrote:

=EF=BB=BF
I have verified it already as per the calculation. The current shared b= uffer is 2.5GB
(2694408/1024/1024).
=
Which I want to make it 8GB or 24G

How to update this is in AWS like belo= w
SUM({DBInstanceClassMemory/1= 2038},-50003)
=


On Thu, Jan 28, 2021, 22= :37 John Scalia <jayknowsunix@gmail.com> wrote:
Ok, it took a me a bit to locate on= e of my servers that is the same size as yours.  Now, I did not set thi= s one up, I only inherited it, but it is configured the same as yours, i.e.,= using that 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 accordin= g to AWS and by my calculations the value for shared_buffers is 20.56GB (215= 55264/1024/1024) Not quite the 75% value, but this is far greater than the 8= GB you=E2=80=99re asking for. So, are you trying to limit it to this lower v= alue, and have 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@gmail.com> wrote:

=EF=BB=BF
Hi,
Ok Sure. But in the parameter gro= up , 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, you should understand the AW= S recommends a 75% setting, or 24GB in their documentation. So, why don=E2=80= =99t you just set the value as something like that in your database paramete= r group settings.


Sent from my iPad

On Jan 28, 2021, at 10:55 AM, dbato= Cloud Solution <dbatocloud17@gmail.com> wrote:
=EF=BB=BF
Hi John,
Yes, I calculated as per pgt= une(https://pgtune.leopard.in.ua/#/)
&nbs= p;advisor. I took 25% of physical memory 32GB in AWS RDS PostgreSQL which is= 8GB. 

AWS PostgreSQL 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.blogspo= t.in/ | E: dbatocloud17@gmail.com



On Thu, Jan 28, 2021 at 6:05 PM dbatoCloud Solution <= dbatocloud17@gmail.com> wrote:
Hi All,

I want to increa= se the size of shared_buffers in AWS RDS postgreSQL 10.11.  When I see i= t in the DB parameter group in AWS it says "SUM({DBInstanceClassMemory/12038= },-50003)"  and at the instance level I see 2694408 .
=
Please let  me know how to c= alculate and  change the value 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.blogspo= t.in/ | E: dbatocloud17@gmail.com

= --Apple-Mail-0D8ECE07-66AD-46CA-A09B-E3373F1A2B5F--