Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL

[dbatoCloud Solution <dbatocloud17@xxxxxxxxx>]

Hi,

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

What is meant by DBInstanceClassMemory? My RDS instance shape is "db.r5.xlarge". I am confused with this parameter?

Can you please help me?

 

Thanks & Best Wishes,

Ashok

 

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UAE | BLR , INDIA

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

W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@xxxxxxxxx

On Thu, Jan 28, 2021 at 9:44 PM John Scalia <jayknowsunix@xxxxxxxxx> wrote:

Well, you should understand the AWS recommends a 75% setting, or 24GB in their documentation. So, why don’t you just set the value as something like that in your database parameter group settings.

Sent from my iPad

On Jan 28, 2021, at 10:55 AM, dbatoCloud Solution <dbatocloud17@xxxxxxxxx> wrote:



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. 

AWS PostgreSQL Configuration: -

<image.png>

 

<image.png>

How to update the shared_buffer into 8GB in the AWS RDS Parameter Group here below?

<image.png>

Thanks & Best Wishes,

Ashok

 

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UAE | BLR , INDIA

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

W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@xxxxxxxxx

On Thu, Jan 28, 2021 at 6:05 PM dbatoCloud Solution <dbatocloud17@xxxxxxxxx> wrote:

Hi All,

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({DBInstanceClassMemory/12038},-50003)"  and at the instance level I see 2694408 .

Please let  me know how to calculate and  change the value for 8GB?

 

 

Thanks & Best Wishes,

Ashok

 

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UAE | BLR , INDIA

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

W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@xxxxxxxxx