On 2024-01-15 14:16, veem v wrote:
Hello Experts,
If some teams are well versed with the Oracle database architecture and
its
optimizers working and designing applications on top of this. Now
moving
same team to work on AWS aurora postgresql databases design/development
projects. Is any key design/architectural changes should the app
development team or the database design team, should really aware
about, so
as to take right decision on any new development project in AWS aurora
postgresql database?
Or
Is there any list of differences(as compared to Oracle database) in key
concepts like for example basic design concepts, Normalization,
Partitioning, clustering, backup and recovery, Indexing strategy,
isolation
level, performance which one should definitely be aware of?
Is this the kind of thing you're looking for?
https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresql-migration-guide-tutorial-move-convert-database-oracle-alternative
Regards and best wishes,
Justin Clift
