post installing, did you run analyze verbose? -Doron
On Mon, Feb 17, 2025 at 4:23 PM Greg Sabino Mullane <htamf...@gmail.com> wrote: > On Mon, Feb 17, 2025 at 2:55 AM 馬 騰飛 <ma-teng...@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. Can > 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 > > -- --- Sent with Gmail for Sidekick Browser <https://join.meetsidekick.com/_qi4a5>
