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
Hi Team,
We are running the below query in PostgreSQL and its taking approx. 8 to 9 sec
to run the query.
Query - 1
Select * from
(
Select payment_sid_c,
lms_app.translate_payment_status(payment_sid_c) AS paymentstatus
from
lms_app.lms_payment_check_request
group by payment_sid_c) a
Em qui., 14 de abr. de 2022 às 08:01, Kumar, Mukesh <
mku...@peabodyenergy.com> escreveu:
> Hi Team,
>
>
>
> We are running the below query in PostgreSQL and its taking approx. 8 to 9
> sec to run the query.
>
>
>
> Query – 1
>
>
>
> Select * from
>
> (
>
> Select payment_sid_c,
>
> lms_app.
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
Hi Rainer ,
We tried to create the partial ‘index on table but it did not help, and it is
taking approx. 7 sec now.
Also we tried to force the query to use the index by enabling the parameter at
session level
set enable_seqscan=false;
and it is still taking the time below is the explain plan
Hi,
This part of the function is odd and must be dropped:
IF (ret_status = payment_rec)
THEN
ret_status := payment_rec;
I didn’t look really the function code and stopped on the view referenced by
the cursor.
The view (we know it just by its name) used i
Hi Michael ,
We tried dropping the below values from the function, but it did not help.
Also, the values PAID and MANUALLY PAID constitutes about 60 % of the values in
table , and infact we tried creating the partial index and it did not help.
The Strange thing is that we are trying to run th
Azure VM's are incredibly slow. I couldn't host a OpenStreetMap
database because the disk IO would die off from reasonable performance
to about 5KB/s and the data import wouldn't finish. Reboot and it would
be fine for a while then repeat. $400 a month for that.
You are better off on bare metal o
Can you paste from oracle for
Set lines 1
Select text from dba_source
Where name =
UPPER('translate_payment_status')
And owner = 'IMS_APP'
Thanks.
On Thu, Apr 14, 2022, 12:07 PM Kumar, Mukesh
wrote:
> Hi Michael ,
>
>
>
>
>
> We tried dropping the below values from the function, but it di
