Thread: Test mail for pgsql-admin

Test mail for pgsql-admin

From
"Shikha, Kumari - Dell Team"
Date:
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

Need assistance in performance tuning of a particular query

From
"Shikha, Kumari - Dell Team"
Date:
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

Re: Need assistance in performance tuning of a particular query

From
Tom Lane
Date:
"Shikha, Kumari - Dell Team" <Kumari.Shikha@dellteam.com> writes:
> 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.    

This is not a bug report; please do not use the -bugs list for it.
pgsql-performance would be an appropriate venue.

Please see

https://wiki.postgresql.org/wiki/Slow_Query_Questions

for some guidance about asking performance questions.

            regards, tom lane