Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Hi Team and All , Greeting for the day. We have recently migrated from Oracle to PostgreSQL on version 11.4 on azure postgres PaaS instance. There is 1 query which is taking approx. 10 secs in Oracle and when we ran the same query it is taking approx. 1 min Can anyone suggest to improve the query as from application end 1 min time is not accepted by client. Please find the query and explain analyze report from below link https://explain.depesz.com/s/RLJn#stats Thanks and Regards, Mukesh Kumar
Hi Team and All ,
Greeting for the day.
We have recently migrated from Oracle to PostgreSQL on version 11.4 on azure postgres PaaS instance.
There is 1 query which is taking approx. 10 secs in Oracle and when we ran the same query it is taking approx. 1 min
Can anyone suggest to improve the query as from application end 1 min time is not accepted by client.
Please find the query and explain analyze report from below link
https://explain.depesz.com/s/RLJn#stats
Thanks and Regards,
Mukesh Kumar
В списке pgsql-performance по дате отправления: