Re: SQL performance issue after migration from Oracle to Aurora postgres

2022-04-14 Thread Andrew Dunstan
On 2022-04-14 Th 05:35, Goti wrote: > Hi All, > > We migrated from Oracle 12.1 to Aurora postgresĀ 12.8.1. The query in > Oracle takes less than a millisecond however the same query in aurora > is taking more than a second. We have a larger number of executions > for the SQL which is causing an ov

SQL performance issue after migration from Oracle to Aurora postgres

2022-04-14 Thread Goti
Hi All, We migrated from Oracle 12.1 to Aurora postgres 12.8.1. The query in Oracle takes less than a millisecond however the same query in aurora is taking more than a second. We have a larger number of executions for the SQL which is causing an overall latency for the application. I am new to po