Message-ID: <8f12fbb4f4df89717d3d18a2b0776526f8a45eec.camel@cybertec.at>
Subject: Re: The performance issues caused by upgrading PostgreSQL to
 version 16.3.
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: =?UTF-8?Q?=E9=A6=AC=E3=80=80=E9=A8=B0=E9=A3=9B?= <ma-tengfei@nec.cn>, 
 "pgsql-general@lists.postgresql.org"
	 <pgsql-general@lists.postgresql.org>
Date: Mon, 17 Feb 2025 10:15:10 +0100
In-Reply-To: <BJSPR01MB04988FBD8D4EBA094B62FD91E2FBA@BJSPR01MB0498.CHNPR01.prod.partner.outlook.cn>
References: 
	<BJSPR01MB04988FBD8D4EBA094B62FD91E2FBA@BJSPR01MB0498.CHNPR01.prod.partner.outlook.cn>
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/8f12fbb4f4df89717d3d18a2b0776526f8a45eec.camel%40cybertec.at>
Precedence: bulk

On Mon, 2025-02-17 at 07:55 +0000, =E9=A6=AC=E3=80=80=E9=A8=B0=E9=A3=9B wro=
te:
> I am reaching out to seek your technical assistance regarding a performan=
ce
> issue we encountered after upgrading our PostgreSQL version from 12.19 to=
 16.3.
> We have noticed a significant performance problem with a specific SQL que=
ry on
> one of our application screens.=20
> Interestingly, when we isolate the problematic SQL statement and replace =
its
> parameters with actual values, it executes in just a few seconds in pgAdm=
in.=20
> However, when we run the same SQL query through our application using Npg=
sql,
> it takes over ten minutes to complete.

I recommend using the auto_explain module to capture the plan of the statem=
ent
when the application executes it.

You best write the fast and the slow plan to the list, in plain text.

Yours,
Laurenz Albe

--=20

*E-Mail Disclaimer*
Der Inhalt dieser E-Mail ist ausschliesslich fuer den=20
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat=
=20
dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,=20
dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder=
=20
Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich=
=20
in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.

*CONFIDENTIALITY NOTICE & DISCLAIMER
*This message and any attachment are=20
confidential and may be privileged or otherwise protected from disclosure=
=20
and solely for the use of the person(s) or entity to whom it is intended.=
=20
If you have received this message in error and are not the intended=20
recipient, please notify the sender immediately and delete this message and=
=20
any attachment from your system. If you are not the intended recipient, be=
=20
advised that any use of this message is prohibited and may be unlawful, and=
=20
you must not copy this message or attachment or disclose the contents to=20
any other person.