Re: The performance issues caused by upgrading PostgreSQL to version 16.3.

2025-02-17 Thread Adrian Klaver
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

Re: The performance issues caused by upgrading PostgreSQL to version 16.3.

2025-02-17 Thread Doron Tsur
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

Re: The performance issues caused by upgrading PostgreSQL to version 16.3.

2025-02-17 Thread Greg Sabino Mullane
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

Re: The performance issues caused by upgrading PostgreSQL to version 16.3.

2025-02-17 Thread Ron Johnson
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

Re: The performance issues caused by upgrading PostgreSQL to version 16.3.

2025-02-17 Thread Laurenz Albe
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