Ron Johnson <ronljohnsonjr@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