From: =?iso-2022-jp?B?GyRCR08hIUYtSHQbKEI=?= <ma-tengfei@nec.cn>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: The performance issues caused by upgrading PostgreSQL to version
 16.3.
Thread-Topic: The performance issues caused by upgrading PostgreSQL to version
 16.3.
Thread-Index: AduBEGnuRrpuSTSuSQeWXz9MB+J6AQ==
Date: Mon, 17 Feb 2025 07:55:01 +0000
Message-ID:
 <BJSPR01MB04988FBD8D4EBA094B62FD91E2FBA@BJSPR01MB0498.CHNPR01.prod.partner.outlook.cn>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-2022-jp?B?QUhST0lFVGE0Sk5Lc09rL243QnRwYjlZb3pneWRQTkRJRktua3pXTE0z?=
 =?iso-2022-jp?B?cGgrUXlnUFVPbjM4OXNWa3R0TzVwN1NLNndPN1c0d1M5b3VheC9md1JS?=
 =?iso-2022-jp?B?ZHBXUkdNWDlRVjRKN281MVo5b3ErdTl5ZUxOcXI5c21KTERkVWlHVkE5?=
 =?iso-2022-jp?B?L3V5QVdVdldWVFM5VVI0U1FWelZHbXp3bmVVSmx1NGd3OHhRc0o3SDI0?=
 =?iso-2022-jp?B?SllDQkhzc21SVldCS3V2U1hDZWo1UGxsdFB6QU5MZUcxdUM3MGxRS1dC?=
 =?iso-2022-jp?B?Vml5NSt6SDMrUlpuTjVsMFR4alJ5eHFiQWZwTkFOVStwTFo3Unc5d2Zp?=
 =?iso-2022-jp?B?aFI0aVJUZTlZaVBvdkJwbEJ5Z3BUOCtUUG1nVktvdzBzZHl4VXlKRUpP?=
 =?iso-2022-jp?B?LzdKUktRVEM2enlMNklGbTBONkQvT2Y2aGR3MnJkUTVDZUdjNlo1ZnRz?=
 =?iso-2022-jp?B?WUJ6OUUvSTRTZFZEbytaZFNXOFNOMXE5bElxOFY1Vzh1QlJnYjVlMFla?=
 =?iso-2022-jp?B?ZHlxK3ZQUXp6VVc1ajgyRzNQUXpoNGEvT09YNFhJdlZTZXpHMStySUcx?=
 =?iso-2022-jp?B?Vm92bnFZZUd0aXJIQTBqdkxCRnlReUxjQnFoeHJmd1ZzQTNLUXFLaE5K?=
 =?iso-2022-jp?B?R2JXTll4TGJ5RzhqTDYwOVIvRW55NlZva1FuNEdCUTFyeFJrNUR3VDFF?=
 =?iso-2022-jp?B?WFVRQk95enJtbloyOWMxZDUyeTFaVUdrSExxb1RENlNQbGNYV1NsMFFs?=
 =?iso-2022-jp?B?cDJLdkIzcEZpVHVZWklyc05laTJ5bmNpMDJRV0R5RTdndFBIN00yRXND?=
 =?iso-2022-jp?B?MEE3L2p5TmNraHp6NzVzcTdhUE1pNWVFeEZudlJKbHhNL1gxanRaZjRD?=
 =?iso-2022-jp?B?d2huaXlEVDI1aE9xS3M5U0dGVytrc201bzZsQ1VxcjFjSWs2czdqVCtN?=
 =?iso-2022-jp?B?TmtrbnBxUnhqRG9RTTc0WFlsMXZ1ZTU3RHlGL1BCRWswOXpTYTRVRWJI?=
 =?iso-2022-jp?B?SkUzUnVPYmZ4Z3V2YzZjb3lRbGlNZkxJVVVCOThIL0Y4M3grNk4zZkNF?=
 =?iso-2022-jp?B?Y0FWd0VHN0FmYkg0YTZpMnJqN0l6c29YOXBFV2tRQXo1ZWRCMEhONk1j?=
 =?iso-2022-jp?B?L25sWmFKeCtPbXZrNmNvWE54ZjM3L01aQTNCQVFNUTRSeWhMbWpVRGh0?=
 =?iso-2022-jp?B?R3VBbW5aeHZINEdGdm9QSlpETmJPQU01cnBCc1lvUmJMMUhDcC9BYUt3?=
 =?iso-2022-jp?B?dFIzak00ZkI1ZjFXVU91cUE4M0doaDdQck5yUGRnaXFJRExscTVTQkx3?=
 =?iso-2022-jp?B?dGhMUGFNdk9vQWRDMG14UGRiemNvVVJpMEFvV0t1QlpoYkF3Wi9Fc09q?=
 =?iso-2022-jp?B?UzJleEQwZzFqVTFWWEpxY2dja0pBdXU1T1QwaDVNQ2pUOGhRb3B5T2NT?=
 =?iso-2022-jp?B?dWtiL0FJbVlINlFjb2E2L09vUGxqNG1uaUZDQnVWUk95VWJ3VThCNk5a?=
 =?iso-2022-jp?B?NTNoWCt0WkNhWk9VL3RQSEs3M1REM3czTnVRVmlJb2pybDZrRTUzUitp?=
 =?iso-2022-jp?B?UUdBMnhNYUk2bTkwcmhWTEhjKzZ6MVB5VUxvZGM3T3Y5bW9rcHBISkhy?=
 =?iso-2022-jp?B?NnJmT3dRa25yZXRsZmFSOUpma09NU2oyczVEaG1mMlhDczhvOWoxblp0?=
 =?iso-2022-jp?B?RXNoNG8zY0dCczg4WTZzU1JPenBkOWVWWGg4LzVYRTlnbnpDbzZ2TURI?=
 =?iso-2022-jp?B?NUVFbnJjQVlyVUxzcTI5Y3lock4yT2NMNUpvSVpabElxeDZyVUZLRllh?=
 =?iso-2022-jp?B?REJZeHgramdhQVgxdS9RRDlGRDVPbmJuYmp5QUhJNUFJMVBPRHNSUXhv?=
 =?iso-2022-jp?B?TWgrYnFOZmgrWnA5ZnY1bTgrRjJLUDkycFdEQk9pTGF6Q1ZwMVB2dCtu?=
 =?iso-2022-jp?B?UE93T3E2ZjhKck9Ib2xOQkZDWFozbGFLeVRiays0ZDJjazc5L2RhOGc1?=
 =?iso-2022-jp?B?QW5uTzBlZThHNzkyOWJuZU5oYVBlRlJWWksrL2Fxc0ZkY3ZMQy9va1Bh?=
 =?iso-2022-jp?B?ZjRES3cwNWM5MlhxcVIzUzg5WUNzSWFaUHc2WjVad1d6VFYzNWE4RjMv?=
 =?iso-2022-jp?B?WCtPd2h5bXQvVWpKTzVpN1ZXa0lpZjNRaE1rVHpyRTBQaHpxeXJHc3p5?=
 =?iso-2022-jp?B?QzlLbVBYNWc3clRIcm4yT3NXYnNxRUN4VFBzUC91c2R6Qk1lOEF6eU5m?=
 =?iso-2022-jp?B?NnNJNDlLd2NIOXdhWVVzaGNZWUVFN1N2OD0=?=
Content-Type: text/plain; charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: nec.cn
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: BJSPR01MB0498.CHNPR01.prod.partner.outlook.cn
X-MS-Exchange-CrossTenant-Network-Message-Id: 567b6c96-bf6d-48ee-38b7-08dd4f2861f6
X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Feb 2025 07:55:01.7252
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: b6684222-561e-42ef-bf08-0dc02fa36535
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: PEdAOFA4AHM5JiSNIxQadbG08ywG/PD9pURE6KpGEG9HTnaQ8gRGNZCswNrGyg+JWcdcOzzBmyVnzkd/LiWXTg==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: BJSPR01MB0817
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/BJSPR01MB04988FBD8D4EBA094B62FD91E2FBA%40BJSPR01MB0498.CHNPR01.prod.partner.outlook.cn>
Precedence: bulk

Dear PostgreSQL Community,

I hope this message finds you well. I am reaching out to seek your technica=
l assistance regarding a performance issue we encountered after upgrading o=
ur PostgreSQL version from 12.19 to 16.3.
We have noticed a significant performance problem with a specific SQL query=
 on one of our application screens.=20
Interestingly, when we isolate the problematic SQL statement and replace it=
s 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 Npgsq=
l, it takes over ten minutes to complete.
We are using NpgsqlCommand.ExecuteReader to execute the SQL query, and the =
parameters are set using NpgsqlCommand.Parameters.Add.=20
The main table involved in this query contains approximately 800,000 record=
s.
We believe that the SQL statement itself does not have performance issues, =
but there may be problems related to how the SQL is executed in the applica=
tion or how the parameters are set.=20
However, we are unable to pinpoint the exact cause of the performance degra=
dation.
Could you please provide us with some possible reasons or suggestions for i=
mprovement? Your insights would be greatly appreciated.
Thank you for your assistance, and I look forward to your response.

Best regards,
Ma