From: Tom Lane <tgl@sss.pgh.pa.us>
To: Shikha, Kumari - Dell Team <Kumari.Shikha@dellteam.com>
Cc: pgsql-bugs@lists.postgresql.org, "Alampalli, Kishore" <Kishoreravishankar.Alampalli@dellteam.com>
Cc: Kishore, Nanda - Dell Team <Nanda.Kishore@Dellteam.com>
Cc: Maind, Saurabh - Dell Team <Saurabh.Maind@Dellteam.com>
Cc: Sardar, Mansingh - Dell Team <M.Sardar@Dellteam.com>
Subject: Re: Need assistance in performance tuning of a particular query
Date: Fri, 07 Apr 2023 13:36:23 -0400
Message-ID: <3049456.1680888983@sss.pgh.pa.us> (raw)
In-Reply-To: <BY5PR19MB4034C6F9A2CA15755EBA10629E969@BY5PR19MB4034.namprd19.prod.outlook.com>
References: <168088399043.1074.17126982733110935657@malur.postgresql.org>
<BY5PR19MB40341216DE1F02AC760287E19E969@BY5PR19MB4034.namprd19.prod.outlook.com>
<BY5PR19MB4034C6F9A2CA15755EBA10629E969@BY5PR19MB4034.namprd19.prod.outlook.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, Kumari.Shikha@dellteam.com, Kishoreravishankar.Alampalli@dellteam.com, Nanda.Kishore@Dellteam.com, Saurabh.Maind@Dellteam.com, M.Sardar@Dellteam.com
Subject: Re: Need assistance in performance tuning of a particular query
In-Reply-To: <3049456.1680888983@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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