| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Shikha, Kumari - Dell Team" <Kumari(dot)Shikha(at)dellteam(dot)com> |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org, "Alampalli, Kishore" <Kishoreravishankar(dot)Alampalli(at)dellteam(dot)com>, "Kishore, Nanda - Dell Team" <Nanda(dot)Kishore(at)Dellteam(dot)com>, "Maind, Saurabh - Dell Team" <Saurabh(dot)Maind(at)Dellteam(dot)com>, "Sardar, Mansingh - Dell Team" <M(dot)Sardar(at)Dellteam(dot)com> |
| Subject: | Re: Need assistance in performance tuning of a particular query |
| Date: | 2023-04-07 17:36:23 |
| Message-ID: | 3049456.1680888983@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Shikha, Kumari - Dell Team" <Kumari(dot)Shikha(at)dellteam(dot)com> writes:
> I am writing to seek guidance regarding an issue that we have been facing recently. We have an escalation that after migrating to PG13 from PG10, a particular DB query is taking huge amount of time to fetch the results. It’s taking hours together 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Guo | 2023-04-10 07:16:06 | ERROR: no NOT NULL constraint found to drop |
| Previous Message | Shikha, Kumari - Dell Team | 2023-04-07 16:46:34 | Need assistance in performance tuning of a particular query |