Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL - Mailing list pgsql-admin
From | John Scalia |
---|---|
Subject | Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL |
Date | |
Msg-id | 203AACAF-0E4E-4FCF-8A28-F3363663037B@gmail.com Whole thread Raw |
In response to | Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL (dbatoCloud Solution <dbatocloud17@gmail.com>) |
Responses |
Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
|
List | pgsql-admin |
On Jan 28, 2021, at 11:30 AM, dbatoCloud Solution <dbatocloud17@gmail.com> wrote:
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@gmail.com
On Thu, Jan 28, 2021 at 9:44 PM John Scalia <jayknowsunix@gmail.com> 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 iPadOn Jan 28, 2021, at 10:55 AM, dbatoCloud Solution <dbatocloud17@gmail.com> 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@gmail.com
On Thu, Jan 28, 2021 at 6:05 PM dbatoCloud Solution <dbatocloud17@gmail.com> 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@gmail.com
pgsql-admin by date: