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
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
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
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
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
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
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,
>
>
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)
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