pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedIncrease the size of shared_buffers in AWS RDS 10.11 postgreSQL
9+ messages / 3 participants
[nested] [flat]
* Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
@ 2021-01-28 12:35 dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 12:48 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia <jayknowsunix@gmail.com>
2021-01-28 15:54 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
0 siblings, 2 replies; 9+ messages in thread
From: dbatoCloud Solution @ 2021-01-28 12:35 UTC (permalink / raw)
To: 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@gmail.com
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
2021-01-28 12:35 Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
@ 2021-01-28 12:48 ` John Scalia <jayknowsunix@gmail.com>
1 sibling, 0 replies; 9+ messages in thread
From: John Scalia @ 2021-01-28 12:48 UTC (permalink / raw)
To: dbatoCloud Solution <dbatocloud17@gmail.com>; +Cc: pgsql-admin
In general, AWS RDS does not set shared_buffers in a manner similar to the community version. From the AWS documentation, the recommendation is to set it at 75% of the instance’s memory size. So, does the 8Gb that you’re requesting match the 75% recommendation? And if I’m not mistaken about this, you could use the database parameter group to set this to the 8Gb level without using any sort of calculation.
—
Jay
Sent from my iPad
> On Jan 28, 2021, at 7:35 AM, 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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
2021-01-28 12:35 Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
@ 2021-01-28 15:54 ` dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 16:14 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia <jayknowsunix@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: dbatoCloud Solution @ 2021-01-28 15:54 UTC (permalink / raw)
To: pgsql-admin
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: image.png]
[image: image.png]
How to update the shared_buffer into 8GB in the AWS RDS Parameter Group
here below?
[image: 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/
<http://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/
> <http://dbatocloudsolution.blogspot.in/; | E: dbatocloud17@gmail.com
>
Attachments:
image.png (image/png, 140.7K) download
view image
image.png (image/png, 26.2K) download
view image
image.png (image/png, 40.5K) download
view image
* Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
2021-01-28 12:35 Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 15:54 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
@ 2021-01-28 16:14 ` John Scalia <jayknowsunix@gmail.com>
2021-01-28 16:30 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: John Scalia @ 2021-01-28 16:14 UTC (permalink / raw)
To: dbatoCloud Solution <dbatocloud17@gmail.com>; +Cc: pgsql-admin
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@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 =
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
2021-01-28 12:35 Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 15:54 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 16:14 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia <jayknowsunix@gmail.com>
@ 2021-01-28 16:30 ` dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 17:07 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: dbatoCloud Solution @ 2021-01-28 16:30 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; pgsql-admin
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/
<http://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 iPad
>
> On 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/
> <http://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/
>> <http://dbatocloudsolution.blogspot.in/; | E: dbatocloud17@gmail.com
>>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
2021-01-28 12:35 Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 15:54 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 16:14 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia <jayknowsunix@gmail.com>
2021-01-28 16:30 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
@ 2021-01-28 17:07 ` John Scalia <jayknowsunix@gmail.com>
2021-01-28 17:33 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: John Scalia @ 2021-01-28 17:07 UTC (permalink / raw)
To: dbatoCloud Solution <dbatocloud17@gmail.com>; +Cc: pgsql-admin
Ok, it took a me a bit to locate one of my servers that is the same size as yours. Now, I did not set this one up, I only inherited it, but it is configured the same as yours, i.e., using that same formula. When I log into it, however, and type: show shared_buffers; it reports 21555264kB. A db.r5.xlarge has 32 GB of memory according to AWS and by my calculations the value for shared_buffers is 20.56GB (21555264/1024/1024) Not quite the 75% value, but this is far greater than the 8GB you’re asking for. So, are you trying to limit it to this lower value, and have you queried yours to see what the shared_buffers is set to?
Sent from my iPad
> 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 iPad
>>
>>>> On 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 =
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
2021-01-28 12:35 Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 15:54 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 16:14 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia <jayknowsunix@gmail.com>
2021-01-28 16:30 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 17:07 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia <jayknowsunix@gmail.com>
@ 2021-01-28 17:33 ` dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 18:05 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL R.R. PRAVEEN RAJA <rrpraveenraja@live.com>
2021-01-28 18:25 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia <jayknowsunix@gmail.com>
0 siblings, 2 replies; 9+ messages in thread
From: dbatoCloud Solution @ 2021-01-28 17:33 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin
I have verified it already as per the calculation. The current shared
buffer is 2.5GB
(2694408/1024/1024).
Which I want to make it 8GB or 24G
How to update this is in AWS like below
SUM({DBInstanceClassMemory/12038},-50003)
On Thu, Jan 28, 2021, 22:37 John Scalia <jayknowsunix@gmail.com> wrote:
> Ok, it took a me a bit to locate one of my servers that is the same size
> as yours. Now, I did not set this one up, I only inherited it, but it is
> configured the same as yours, i.e., using that same formula. When I log
> into it, however, and type: show shared_buffers; it reports 21555264kB. A
> db.r5.xlarge has 32 GB of memory according to AWS and by my calculations
> the value for shared_buffers is 20.56GB (21555264/1024/1024) Not quite the
> 75% value, but this is far greater than the 8GB you’re asking for. So, are
> you trying to limit it to this lower value, and have you queried yours to
> see what the shared_buffers is set to?
>
> Sent from my iPad
>
> 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/
> <http://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 iPad
>>
>> On 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/
>> <http://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/
>>> <http://dbatocloudsolution.blogspot.in/; | E: dbatocloud17@gmail.com
>>>
>>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
2021-01-28 12:35 Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 15:54 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 16:14 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia <jayknowsunix@gmail.com>
2021-01-28 16:30 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 17:07 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia <jayknowsunix@gmail.com>
2021-01-28 17:33 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
@ 2021-01-28 18:05 ` R.R. PRAVEEN RAJA <rrpraveenraja@live.com>
1 sibling, 0 replies; 9+ messages in thread
From: R.R. PRAVEEN RAJA @ 2021-01-28 18:05 UTC (permalink / raw)
To: dbatoCloud Solution <dbatocloud17@gmail.com>; John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin
Hi Ashok,
It's simple remove the SUM({DBInstanceClassMemory/12038},-50003) and update the value as per the below formula in the parameter group of aurora postgres RDS.
Note:
If you want to change value in the parameter group then you need to create new parameter group and attach it to the RDS. This would require reboot. In configuration tab it should not show as pending reboot, if yes another reboot is required.
Regards
Praveen
Sent from Outlook Mobile<https://aka.ms/blhgte;
________________________________
From: dbatoCloud Solution <dbatocloud17@gmail.com>
Sent: Thursday, 28 January, 2021, 11:03 pm
To: John Scalia
Cc: pgsql-admin@postgresql.org
Subject: Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
I have verified it already as per the calculation. The current shared buffer is 2.5GB
(2694408/1024/1024).
Which I want to make it 8GB or 24G
How to update this is in AWS like below
SUM({DBInstanceClassMemory/12038},-50003)
On Thu, Jan 28, 2021, 22:37 John Scalia <jayknowsunix@gmail.com<mailto:jayknowsunix@gmail.com>> wrote:
Ok, it took a me a bit to locate one of my servers that is the same size as yours. Now, I did not set this one up, I only inherited it, but it is configured the same as yours, i.e., using that same formula. When I log into it, however, and type: show shared_buffers; it reports 21555264kB. A db.r5.xlarge has 32 GB of memory according to AWS and by my calculations the value for shared_buffers is 20.56GB (21555264/1024/1024) Not quite the 75% value, but this is far greater than the 8GB you’re asking for. So, are you trying to limit it to this lower value, and have you queried yours to see what the shared_buffers is set to?
Sent from my iPad
On Jan 28, 2021, at 11:30 AM, dbatoCloud Solution <dbatocloud17@gmail.com<mailto: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/<http://dbatocloudsolution.blogspot.in/; | E: dbatocloud17@gmail.com<mailto:dbatocloud17@gmail.com>
On Thu, Jan 28, 2021 at 9:44 PM John Scalia <jayknowsunix@gmail.com<mailto: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 iPad
On Jan 28, 2021, at 10:55 AM, dbatoCloud Solution <dbatocloud17@gmail.com<mailto: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/<http://dbatocloudsolution.blogspot.in/; | E: dbatocloud17@gmail.com<mailto:dbatocloud17@gmail.com>
On Thu, Jan 28, 2021 at 6:05 PM dbatoCloud Solution <dbatocloud17@gmail.com<mailto: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/<http://dbatocloudsolution.blogspot.in/; | E: dbatocloud17@gmail.com<mailto:dbatocloud17@gmail.com>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL
2021-01-28 12:35 Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 15:54 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 16:14 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia <jayknowsunix@gmail.com>
2021-01-28 16:30 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 17:07 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL John Scalia <jayknowsunix@gmail.com>
2021-01-28 17:33 ` Re: Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
@ 2021-01-28 18:25 ` John Scalia <jayknowsunix@gmail.com>
1 sibling, 0 replies; 9+ messages in thread
From: John Scalia @ 2021-01-28 18:25 UTC (permalink / raw)
To: dbatoCloud Solution <dbatocloud17@gmail.com>; +Cc: pgsql-admin
That really doesn’t seem to correspond to an r5.xlarge instance then, but you could always remove the calculation from the parameter group, and just hard code the value you want. I would probably make a copy of the parameter group do this in, so you don’t lose the formula if you might need it later. Remember that you need to restart the instance afterwards.
Sent from my iPad
> On Jan 28, 2021, at 12:33 PM, dbatoCloud Solution <dbatocloud17@gmail.com> wrote:
>
>
> I have verified it already as per the calculation. The current shared buffer is 2.5GB
> (2694408/1024/1024).
>
> Which I want to make it 8GB or 24G
>
> How to update this is in AWS like below
> SUM({DBInstanceClassMemory/12038},-50003)
>
>
>> On Thu, Jan 28, 2021, 22:37 John Scalia <jayknowsunix@gmail.com> wrote:
>> Ok, it took a me a bit to locate one of my servers that is the same size as yours. Now, I did not set this one up, I only inherited it, but it is configured the same as yours, i.e., using that same formula. When I log into it, however, and type: show shared_buffers; it reports 21555264kB. A db.r5.xlarge has 32 GB of memory according to AWS and by my calculations the value for shared_buffers is 20.56GB (21555264/1024/1024) Not quite the 75% value, but this is far greater than the 8GB you’re asking for. So, are you trying to limit it to this lower value, and have you queried yours to see what the shared_buffers is set to?
>>
>> Sent from my iPad
>>
>>>> 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 iPad
>>>>
>>>>>> On 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
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2021-01-28 18:25 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-01-28 12:35 Increase the size of shared_buffers in AWS RDS 10.11 postgreSQL dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 12:48 ` John Scalia <jayknowsunix@gmail.com>
2021-01-28 15:54 ` dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 16:14 ` John Scalia <jayknowsunix@gmail.com>
2021-01-28 16:30 ` dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 17:07 ` John Scalia <jayknowsunix@gmail.com>
2021-01-28 17:33 ` dbatoCloud Solution <dbatocloud17@gmail.com>
2021-01-28 18:05 ` R.R. PRAVEEN RAJA <rrpraveenraja@live.com>
2021-01-28 18:25 ` John Scalia <jayknowsunix@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox