There's thread with exact same title and problem, but with no answer, NPGSQL driver takes very long time to execute queries, but other language drivers or terminal works fine.
From what I've found, it's related to parameter sniffing in other SQL databases, but I could not find much for Postgres.
I'm running UPDATE statement, so it doesn't return many rows.
.NET Core 3.0, NPGSQL 4.1.1, PostgreSQL 10.9 (Ubuntu)
Asked by iNeedHealing255
(1 rep)
Oct 25, 2019, 06:49 AM
Last activity: Oct 25, 2019, 09:33 AM
Last activity: Oct 25, 2019, 09:33 AM