Postgres Pro
Downloads
Home   >   mailing lists

Need assistance in performance tuning of a particular query - Mailing list pgsql-bugs

From Shikha, Kumari - Dell Team
Subject Need assistance in performance tuning of a particular query
Date
Msg-id BY5PR19MB4034C6F9A2CA15755EBA10629E969@BY5PR19MB4034.namprd19.prod.outlook.com
Whole thread Raw
In response to Test mail for pgsql-admin  ("Shikha, Kumari - Dell Team" <Kumari.Shikha@dellteam.com>)
Responses Re: Need assistance in performance tuning of a particular query
List pgsql-bugs
Tree view 
Hi Team,

I am writing to seek guidance regarding an issue that we have been facing recently. We have an escalation that after
migratingto PG13 from PG10, a particular DB query is taking huge amount of time to fetch the results.  It’s taking
hourstogether to fetch the data while it used to run smoothly and fetched data within minutes on PG10.   
 

We are not sure what could be causing this problem and we would greatly appreciate any suggestions and insights that
youmay have.
 
Kindly assist us in troubleshooting this issue.

Thanks & Regards,
Shikha


Internal Use - Confidential

pgsql-bugs by date:

Previous
From: "Shikha, Kumari - Dell Team"
Date:
Subject: Test mail for pgsql-admin
Next
From: Tom Lane
Date:
Subject: Re: Need assistance in performance tuning of a particular query