post installing, did you run analyze verbose?
-Doron
-Doron
On Mon, Feb 17, 2025 at 4:23 PM Greg Sabino Mullane <htamfids@xxxxxxxxx> wrote:
On Mon, Feb 17, 2025 at 2:55 AM 馬 騰飛 <ma-tengfei@xxxxxx> 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
---
Sent with Gmail for Sidekick Browser
Sent with Gmail for Sidekick Browser
