choice of db engine | Community
Skip to main content
S
sean_kim
November 24, 2023
Question

choice of db engine

  • November 24, 2023
  • 1 reply
  • 558 views

Hello there,

I don't think many people know the answer to this question. 

I am having some issue with postgresql repository database(aurora rds postgresql)

seems like the root cause of the problem is that IO performance is not fast enough.

as the nature of AWS aurora postgresql is that IOPS will be limited by network bandwidth.

and it's currently 12 Gbit/s. 

So my company is considering to switch the database to the ORACLE on premise. 

I'm expecting to get hugh performance benefit from ORACLE engine and modern NVME disks.

So I was wondering anyone has similar experience and would like to get an opinion about that.(like migration effort, performance benefit)

 

Any advice would be appreciated.

regards, sean

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    Manoj_Kumar
    Community Advisor
    Manoj_KumarCommunity Advisor
    Community Advisor
    November 28, 2023

    Hello @sean_kim 

     

    Are you sure the root cause of the problem is I/Os? As far as I know, All the hosted instances of AC use RDS and they work fine.

     

    If you are looking at performance only then have you considered moving to v8?

     

     

    Manoj     Find me on LinkedIn
    Terms & ConditionsAccessibility statement

    Loading footer...