Re: Query hangs (and then timeout) after using COPY to import data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Query hangs (and then timeout) after using COPY to import data
Date: 2024-02-11 23:43:58
Message-ID: 2077733.1707695038@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron Johnson <ronljohnsonjr(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message veem v 2024-02-12 06:50:11 Re: How to do faster DML
Previous Message Ron Johnson 2024-02-11 23:27:04 Re: Query hangs (and then timeout) after using COPY to import data