Re: Aurora PostgreSQL Support

Dear Rakesh

Prince is correct.

@Rakesh T # The below parameter value cannot be changed in aurora database.
I tried to change in parameter group level but there is no option even I
checked with AWS
It is not possible to change this setting. In our environment is Dataware
where we are having huge DML,Select & I/O happening I asked AWS to
support/give Dataware house best practice
so that I can follow but no support from AWS.

min_wal_size
max_wal_size
effective_io_concurrency
checkpoint_completion_target

It can be done in the community version.

My suggestion better to go-ahead with RDS-PostgreSQL, or EC2-> PostgreSQL
but not Aurora postgreSQL.

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

On Thu, Feb 18, 2021 at 11:47 AM Prince Pathria <prince(dot)pathria(at)goevive(dot)com>
wrote:

> One of the issues I faced in the past is limited(not expandable) tmp
> storage. If your query is huge, it may fail.
> AWS docs don't tell such things explicitly so have intensive testing on
> Aurora before planning to migrate.
> RDS seems to be a safe choice.
>
> Quoting from the doc - "Each Aurora DB instance contains a limited amount
> of local storage that is determined by the DB instance class. Typically,
> the amount of local storage is twice the amount of memory on the DB
> instance."
> ref.
> https://aws.amazon.com/premiumsupport/knowledge-center/postgresql-aurora-storage-issue/
>
>
> Happy to help :)
> Prince Pathria Cloud Engineer II| Certified Kubernetes Administrator |
> AWS Certified Solutions Architect Evive +91 9478670472 goevive.com
>
>
> On Thu, Feb 18, 2021 at 11:33 AM dbatoCloud Solution <
> dbatocloud17(at)gmail(dot)com> wrote:
>
>> Hi Rakesh
>> I would suggest to go for EC2 then install PostgreSQL then use it. I am
>> facing lot of problems in Aurora PostgreSQL
>>
>> Thanks
>> Ashok
>>
>> On Thu, Feb 18, 2021, 10:04 Rakesh T <aryan(dot)goti(at)gmail(dot)com> wrote:
>>
>>> Hi Listeres,
>>>
>>> I am looking for suggestions from people who have experience with Aurora
>>> PostgreSQL.
>>>
>>> I work as a database admin in my company. We are migrating some of our
>>> Oracle databases to Aurora PostgreSQL. Since this falls under the RDS
>>> category I understand that the majority of the admin work will be managed
>>> by AWS team itself. But from a business unit perspective, they are looking
>>> for support from my team with regards to general BU work and performance
>>> and tuning. Can someone shed some light on possible areas which we can
>>> support in the RDS Aurora PostgreSQL world?
>>>
>>> Thanks in Advance!
>>>
>>> Thanks,
>>> Goti
>>>
>>