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 1l59w3-0000jq-Ed for pgsql-admin@arkaria.postgresql.org; Thu, 28 Jan 2021 16:14:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l59w2-0001Yb-7K for pgsql-admin@arkaria.postgresql.org; Thu, 28 Jan 2021 16:14:18 +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 1l59w1-0001YN-SH for pgsql-admin@lists.postgresql.org; Thu, 28 Jan 2021 16:14:17 +0000 Received: from mail-qk1-x72a.google.com ([2607:f8b0:4864:20::72a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1l59vu-0003cA-RW for pgsql-admin@postgresql.org; Thu, 28 Jan 2021 16:14:17 +0000 Received: by mail-qk1-x72a.google.com with SMTP id n7so5745418qkc.4 for ; Thu, 28 Jan 2021 08:14:10 -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=LS4BNj2s3rMjwhdil1G1b6ZRRSb8iuG/Ham3ATPytbU=; b=O4jG7ypqiAScczi2V3itI5ewmTxZLdfzHUjghw+v9fM/7hw17czFgc7pNOrSRDVxQe pzcH1WGodJ5xOfmpriz5I5XCzTehv4a5buYGPejvUw/DcYrgV6fN3Nf3Me9geFHo5k0W xp7qPcNgmWONq8ivLXLtYhPuaQu3uonhmZzwzkLGdiodUEAyJjue0RBhHjKvdddpi0L5 rOQqMTjWULKebnySqQac55aZrM6oOOcF/u13tRlJySlUzGOrhSQTZaX+5JKSbhsfKdNu lceWzMUdk8KzECqMT5cKktu3xCXOArHCuwc6UUXCUNQqRomj3jGXRPMsEyIz7JOOabxk hkgg== 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=LS4BNj2s3rMjwhdil1G1b6ZRRSb8iuG/Ham3ATPytbU=; b=UueVXIkQ2hJeSrFZzBQGdoZOqn+svg8JmqkP1splKyLgTS7GnuoPTTkSqjCASc0XIa zz6f8L0E7QTMSFkhGpPr0kLjm66RRF3MZ5cFpbTsGkI2iu2ll4KDyF6sKSnGGoXHW3DR c9pA/SuDEaHJNoP0E09mlZGY0cMbLYOYLzj4F+CoAgihLlRZ8MS4XCuVUaNZYcV7VodO SkZJLFV/f/jpxcpaLCAAiKQmO1lPTT7TCqw5WhZRnV+7Wkbo4jPkahsUw6r+6ImkFewO QsRKUfwdxGkhhC7X13edT6rNimLtBYbjuREKv/ploiE7VHsk46UxlF8THZfxM6uxLBYY V2ag== X-Gm-Message-State: AOAM531e8zfrdSYIWxMgOqOhitdTtR+a5ZcEKNX2tsA/pO8wFxRQBIRK DlujzJMh8uTFE5r+Yv5AhJc= X-Google-Smtp-Source: ABdhPJwwhshL2FLptEbsrEyskJD4ALw/mr30HviDOLC8iqZqGtoIHU5vWxpik420yDhpC668wQiJIg== X-Received: by 2002:a37:a34f:: with SMTP id m76mr16153222qke.89.1611850448887; Thu, 28 Jan 2021 08:14:08 -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 o15sm3601331qtp.51.2021.01.28.08.14.07 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 28 Jan 2021 08:14:08 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-C1C65A00-503C-498F-AFA5-4E890864C975 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 11:14:06 -0500 Message-Id: <8EFCA485-5230-4E78-820E-F32097F4A47B@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-C1C65A00-503C-498F-AFA5-4E890864C975 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Well, you should understand the AWS recommends a 75% setting, or 24GB in the= ir documentation. So, why don=E2=80=99t you just set the value as something l= ike that in your database parameter group settings. Sent from my iPad > 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 i= s 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 he= re 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({DBInstanceCl= assMemory/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-C1C65A00-503C-498F-AFA5-4E890864C975 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Well, you should understand the AWS recomme= nds 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 parameter group s= ettings.


Sent from my iPad

On Jan 28, 2021, at 10:55 AM, dbatoCloud Sol= ution <dbatocloud17@gmail.com> wrote:

=EF=BB=BF
Hi J= ohn,
Yes, I calculated as per pgtune(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.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-C1C65A00-503C-498F-AFA5-4E890864C975--