MIME-Version: 1.0
References: <BJSPR01MB04988FBD8D4EBA094B62FD91E2FBA@BJSPR01MB0498.CHNPR01.prod.partner.outlook.cn>
 <CAKAnmm+eSi+M6UevXJh6WH=yToNYD+fqVvBb7YsZ7u_=tKRtDA@mail.gmail.com>
In-Reply-To: <CAKAnmm+eSi+M6UevXJh6WH=yToNYD+fqVvBb7YsZ7u_=tKRtDA@mail.gmail.com>
From: Doron Tsur <qballer@gmail.com>
Date: Mon, 17 Feb 2025 18:04:57 +0200
Message-ID: <CAPZZA0rj2zU=K6yS=F9apn62P_Wj4ov1gh4KLvBL-E6of5b0bg@mail.gmail.com>
Subject: Re: The performance issues caused by upgrading PostgreSQL to version 16.3.
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: =?UTF-8?B?6aasIOmosOmjmw==?= <ma-tengfei@nec.cn>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000373de6062e58b046"
Archived-At: <https://www.postgresql.org/message-id/CAPZZA0rj2zU%3DK6yS%3DF9apn62P_Wj4ov1gh4KLvBL-E6of5b0bg%40mail.gmail.com>
Precedence: bulk

--000000000000373de6062e58b046
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

post installing, did you run analyze verbose?

-Doron


On Mon, Feb 17, 2025 at 4:23=E2=80=AFPM Greg Sabino Mullane <htamfids@gmail=
.com>
wrote:

> On Mon, Feb 17, 2025 at 2:55=E2=80=AFAM =E9=A6=AC =E9=A8=B0=E9=A3=9B <ma-=
tengfei@nec.cn> wrote:
>
>> Interestingly, when we isolate the problematic SQL statement and replace
>> its parameters with actual values, it executes in just a few seconds in
>> pgAdmin.
>> However, when we run the same SQL query through our application using
>> Npgsql, it takes over ten minutes to complete.
>>
>
> Another reason could be a poor type casting by your driver/middleware. Ca=
n
> you share the query that is problematic? (also, since you mentioned a
> version upgrade, also make sure you run ANALYZE; post-upgrade.)
>
> Cheers,
> Greg
>
> --
> Crunchy Data - https://www.crunchydata.com
> Enterprise Postgres Software Products & Tech Support
>
>

--=20
---
Sent with Gmail for Sidekick Browser <https://join.meetsidekick.com/_qi4a5>

--000000000000373de6062e58b046
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">post installing, did you run analyze verbose?=C2=A0<br><br=
>-Doron=C2=A0<div><br></div></div><br><div class=3D"gmail_quote gmail_quote=
_container"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Feb 17, 2025 at 4=
:23=E2=80=AFPM Greg Sabino Mullane &lt;<a href=3D"mailto:htamfids@gmail.com=
">htamfids@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quo=
te" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204=
);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Mon, Feb 17, 2025 =
at 2:55=E2=80=AFAM =E9=A6=AC=E3=80=80=E9=A8=B0=E9=A3=9B &lt;<a href=3D"mail=
to:ma-tengfei@nec.cn" target=3D"_blank">ma-tengfei@nec.cn</a>&gt; wrote:</d=
iv><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"ma=
rgin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:=
1ex">Interestingly, when we isolate the problematic SQL statement and repla=
ce its parameters with actual values, it executes in just a few seconds in =
pgAdmin. <br>
However, when we run the same SQL query through our application using Npgsq=
l, it takes over ten minutes to complete.<br>
</blockquote><div><br></div><div>Another reason could be a poor type castin=
g by your driver/middleware. Can you share the query that is problematic? (=
also, since you mentioned=C2=A0a version upgrade, also make sure you run AN=
ALYZE; post-upgrade.)</div><div><br></div><div>Cheers,</div><div>Greg</div>=
<div><br></div></div><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D=
"ltr"><div>--</div><div>Crunchy Data - <a href=3D"https://www.crunchydata.c=
om" target=3D"_blank">https://www.crunchydata.com</a></div><div>Enterprise =
Postgres Software Products &amp; Tech Support</div><div><br></div></div></d=
iv></div>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr">---<br>Sent with Gmail for <a href=3D"https://jo=
in.meetsidekick.com/_qi4a5" target=3D"_blank">Sidekick Browser</a></div></d=
iv>

--000000000000373de6062e58b046--