-Original Message-
From: Tomas Vondra
Sent: Tuesday, March 1, 2022 7:35 PM
To: Jeff Janes ; Kumar, Mukesh
Cc: pgsql-performa...@postgresql.org
Subject: Re: Never Ending query in PostgreSQL
On 2/27/22 18:20, Jeff Janes wrote:
>
> On Sun, Feb 27, 2022 at 7:09 AM Kumar, Mukesh
> m
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 q
on it.
Thanks and Regards,
Mukesh Kumar
-Original Message-
From: Laurenz Albe
Sent: Friday, March 25, 2022 4:13 PM
To: Kumar, Mukesh ; pgsql-performa...@postgresql.org
Subject: Re: View taking time to show records
On Thu, 2022-03-24 at 15:59 +, Kumar, Mukesh wrote:
> We h
Hi Team,
Greetings !!
We have recently done the migration from Oracle Database Version 12C to Azure
PostgreSQL PaaS instance version 11.4 and most of the application functionality
testing has been over and tested successfully
However, there is 1 process at application level which is taking app
-
From: Laurenz Albe
Sent: Wednesday, April 13, 2022 2:04 PM
To: Kumar, Mukesh ; pgsql-performa...@postgresql.org;
MUKESH KUMAR
Subject: Re: Performance for SQL queries on Azure PostgreSQL PaaS instance
On Tue, 2022-04-12 at 09:10 +, Kumar, Mukesh wrote:
> We have recently done the migrat
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
: Ranier Vilela
Sent: Thursday, April 14, 2022 7:56 PM
To: Kumar, Mukesh
Cc: pgsql-performa...@postgresql.org; MUKESH KUMAR
Subject: Re: Query Tunning related to function
Em qui., 14 de abr. de 2022 às 08:01, Kumar, Mukesh
mailto:mku...@peabodyenergy.com>> escreveu:
Hi Team,
We are running the
ciated.
Thanks and Regards,
Mukesh Kumar
From: Michel SALAIS
Sent: Thursday, April 14, 2022 11:45 PM
To: Kumar, Mukesh ; 'Ranier Vilela'
Cc: pgsql-performa...@postgresql.org; 'MUKESH KUMAR'
Subject: RE: Query Tunning related to function
Hi,
This part of the function
Hi Babu ,
Please find below the script for the function from Oracle
Hi babu ,
Please find attached the script for function from Oracle .
Please revert in case of any query.
Thanks and Regards,
Mukesh Kumar
From: Bhupendra Babu
Sent: Friday, April 15, 2022 3:44 AM
To: Kumar, Mukesh
Cc
Hi All ,
We request you to please provide some assistance on below issue and it is
impacting the migration project.
Thanks and Regards,
Mukesh Kumar
From: Kumar, Mukesh
Sent: Friday, April 15, 2022 11:43 AM
To: Bhupendra Babu
Cc: Michel SALAIS ; Ranier Vilela ;
postgres performance list
Hi Team,
We are facing an issue in running the query which takes at least 30 sec to run
in PostgreSQL.
We have tried to create the indexes and done the maintenance and still that
query is taking same time.
Below are the explain plan for the query.
https://explain.depesz.com/s/sPo2#html
We ha
Hi Justin ,
Thanks for your help , After committing 1 parameter , the whole query executed
in less than 1 min.
Thanks and Regards,
Mukesh Kumar
-Original Message-
From: Justin Pryzby
Sent: Wednesday, February 23, 2022 2:57 AM
To: Kumar, Mukesh
Cc: pgsql-performa
Hi Team,
Can you please help in tunning the attached query as , i am trying to run this
query and it runs for several hours and it did not give any output.
I am not able to generate the explain analyze plan as well and it keeps on
running for several hours and did not give output.
I have attac
13 matches
Mail list logo
