On 2/16/25 23:55, 馬 騰飛 wrote:
Dear PostgreSQL Community,
I hope this message finds you well. I am reaching out to seek your technical
assistance regarding a performance issue we encountered after upgrading our
PostgreSQL version from 12.19 to 16.3.
We have noticed a significant performance pro
post installing, did you run analyze verbose?
-Doron
On Mon, Feb 17, 2025 at 4:23 PM Greg Sabino Mullane
wrote:
> On Mon, Feb 17, 2025 at 2:55 AM 馬 騰飛 wrote:
>
>> Interestingly, when we isolate the problematic SQL statement and replace
>> its parameters with actual values, it executes in just
On Mon, Feb 17, 2025 at 2:55 AM 馬 騰飛 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 ov
On Mon, Feb 17, 2025 at 2:55 AM 馬 騰飛 wrote:
> Dear PostgreSQL Community,
>
> I hope this message finds you well. I am reaching out to seek your
> technical assistance regarding a performance issue we encountered after
> upgrading our PostgreSQL version from 12.19 to 16.3.
> We have noticed a sign
On Mon, 2025-02-17 at 07:55 +, 馬 騰飛 wrote:
> I am reaching out to seek your technical assistance regarding a performance
> 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 query on
> one of