Re: Moving to Postgresql database

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