Ron Johnson <ronljohnso...@gmail.com> writes: > Since the query works in PgAdmin, but not in npgsql, the problem has to be > somewhere in Npgsql.
I'm wondering if npgsql is executing the query as a cursor and that
is causing the planner to make a poor choice of plan. There is a
bias towards fast-start plans if you use a cursor, and that doesn't
always work well :-(
regards, tom lane
