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