pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedNeed assistance in performance tuning of a particular query
2+ messages / 2 participants
[nested] [flat]
* Need assistance in performance tuning of a particular query
@ 2023-04-07 16:46 Shikha, Kumari - Dell Team <Kumari.Shikha@dellteam.com>
0 siblings, 1 reply; 2+ messages in thread
From: Shikha, Kumari - Dell Team @ 2023-04-07 16:46 UTC (permalink / raw)
To: pgsql-admin Owner <pgsql-admin-owner@lists.postgresql.org>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>; +Cc: Alampalli, Kishore <Kishoreravishankar.Alampalli@dellteam.com>; Kishore, Nanda - Dell Team <Nanda.Kishore@Dellteam.com>; Maind, Saurabh - Dell Team <Saurabh.Maind@Dellteam.com>; Sardar, Mansingh - Dell Team <M.Sardar@Dellteam.com>
Hi Team,
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.
We are not sure what could be causing this problem and we would greatly appreciate any suggestions and insights that you may have.
Kindly assist us in troubleshooting this issue.
Thanks & Regards,
Shikha
Internal Use - Confidential
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Need assistance in performance tuning of a particular query
@ 2023-04-07 17:36 Tom Lane <tgl@sss.pgh.pa.us>
parent: Shikha, Kumari - Dell Team <Kumari.Shikha@dellteam.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2023-04-07 17:36 UTC (permalink / raw)
To: Shikha, Kumari - Dell Team <Kumari.Shikha@dellteam.com>; +Cc: pgsql-bugs@lists.postgresql.org, "Alampalli, Kishore" <Kishoreravishankar.Alampalli@dellteam.com>; Kishore, Nanda - Dell Team <Nanda.Kishore@Dellteam.com>; Maind, Saurabh - Dell Team <Saurabh.Maind@Dellteam.com>; Sardar, Mansingh - Dell Team <M.Sardar@Dellteam.com>
"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 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-04-07 17:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-04-07 16:46 Need assistance in performance tuning of a particular query Shikha, Kumari - Dell Team <Kumari.Shikha@dellteam.com>
2023-04-07 17:36 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox