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 1l56j0-0007V8-3G for pgsql-admin@arkaria.postgresql.org; Thu, 28 Jan 2021 12:48:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l56ix-0008Hr-FZ for pgsql-admin@arkaria.postgresql.org; Thu, 28 Jan 2021 12:48:35 +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 1l56ix-0008Hk-4p for pgsql-admin@lists.postgresql.org; Thu, 28 Jan 2021 12:48:35 +0000 Received: from mail-qk1-x72f.google.com ([2607:f8b0:4864:20::72f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1l56iu-0001yS-D1 for pgsql-admin@postgresql.org; Thu, 28 Jan 2021 12:48:34 +0000 Received: by mail-qk1-x72f.google.com with SMTP id d85so5047876qkg.5 for ; Thu, 28 Jan 2021 04:48:31 -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=rHiWkOCJeXGGrx1ePfuas7aDt+UZKTHzpUbQKRi7CyI=; b=PCN/C6PbmEb50OleZhIKiZfLoc9r6/1ZO6YVhkIBB46w3yFtZADuVFqIPL+1Pnq/x+ elJ/5aXrABiIpkb9TsABf8pM4RIj+2scPGLaSV6WudFHIlqT4l3awOR+jGCQaeM27bTq 2OAPL7ugEkY3sxsW8GC856OVE5jd4nOlsZNsOiy6U0v1UE47iYcFAb9gWEYLM2EQM/z+ 1zcJcdr4M383TjuusCca2ppDfq3KT6Z7lljRcd57t5wPwKCAiJHW2cMTqb7dDDgCpdVL vS5UEJmTRxTfwVPbxIlUWA/0dmkXLJWnlHE1+F+ssATRubK7EWHb8we1QbDxecJzmoNP 2igQ== 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=rHiWkOCJeXGGrx1ePfuas7aDt+UZKTHzpUbQKRi7CyI=; b=WviSdZJj4xqCDPu/sV76lGu0Kvf9MpKfVbSZDlH4yeh2JnQMp/AkJRewlBn8V45NWp GzBYoRIYtwTJWjNPAYXmVWTUOcX/lBpVQz7JNsmkqzK+cQJ51a4xiyiAQu+Qka3FRfHN Ywnm5jBIKvViWBQZxukPwqcBg5pvmcsAlhINdqA/fM114J47z7j+fKHZm5iFAUnksOaQ P6K1V1ySqG0fU7pF3Qi7euuu5T0Nx+170myd0WTat38Jfh7mXt/yLFfz6QBsoTpDn+xZ W5M9ZYk/Yyy+3dNH/mrBrnjMtff4fR5s3NDbcDukFgiCwk1ME9qnjRwsjdRt4eDU4UKF PxIw== X-Gm-Message-State: AOAM531DWdf2gIZCv8MjP8Pv4Wl/3WqerIqP5I+jEbDlKJKAXQ7myUNB UP5NzG1m8BAhj/STXA+FSxU= X-Google-Smtp-Source: ABdhPJyhUVc7KCEGigE5ku8kf2D34wqOnSCx47lyIHo4yRfO/V8nIq0s01WWjjQUd2miYGIJZTD18Q== X-Received: by 2002:a37:5903:: with SMTP id n3mr15383256qkb.203.1611838110284; Thu, 28 Jan 2021 04:48:30 -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 n94sm3259214qtd.28.2021.01.28.04.48.28 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 28 Jan 2021 04:48:29 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-9A617E8F-3284-4A3E-A72D-ECE242CFB97E 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 07:48:27 -0500 Message-Id: <3602BA76-374D-440E-92E8-AC4AEF1B6E23@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-9A617E8F-3284-4A3E-A72D-ECE242CFB97E Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable In general, AWS RDS does not set shared_buffers in a manner similar to the c= ommunity version. =46rom the AWS documentation, the recommendation is to set= it at 75% of the instance=E2=80=99s memory size. So, does the 8Gb that you= =E2=80=99re requesting match the 75% recommendation? And if I=E2=80=99m not m= istaken about this, you could use the database parameter group to set this t= o the 8Gb level without using any sort of calculation. =E2=80=94 Jay Sent from my iPad > On Jan 28, 2021, at 7:35 AM, dbatoCloud Solution w= rote: >=20 > =EF=BB=BF > 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({DBInstanceCla= ssMemory/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-9A617E8F-3284-4A3E-A72D-ECE242CFB97E Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable In general, AWS RDS does not set shared_buf= fers in a manner similar to the community version. =46rom the AWS documentat= ion, the recommendation is to set it at 75% of the  instance=E2=80=99s m= emory size. So, does the 8Gb that you=E2=80=99re requesting match the 75% re= commendation? And if I=E2=80=99m not mistaken about this, you could use the d= atabase parameter group to set this to the 8Gb  level without using any= sort of calculation.
=E2=80=94
Jay

Sent from my iPad

On J= an 28, 2021, at 7:35 AM, dbatoCloud Solution <dbatocloud17@gmail.com> w= rote:

=EF= =BB=BF
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-9A617E8F-3284-4A3E-A72D-ECE242CFB97E--