Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL

From: dbatoCloud Solution <dbatocloud17(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
Date: 2021-01-28 12:35:15
Message-ID: CAEz7P_vWUNs8a+FgTjoTFo2hygLCOzpww9z8TSKY547LXCrg4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/
<http://dbatocloudsolution.blogspot.in/> | E: dbatocloud17(at)gmail(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2021-01-28 12:48:27 Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
Previous Message Dischner, Anton 2021-01-27 09:05:09 AW: productive usage of PostgreSQL with Windows Server