Postgres Pro
Downloads
Home   >   mailing lists

Re: Query hangs (and then timeout) after using COPY to import data - Mailing list pgsql-general

From Ron Johnson
Subject Re: Query hangs (and then timeout) after using COPY to import data
Date
Msg-id CANzqJaANOyfYP-hdwRbT6aLUVL=jBTWmVHo18y_8cuh92hm_zQ@mail.gmail.com
Whole thread Raw
In response to Re: Query hangs (and then timeout) after using COPY to import data  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
On Sun, Feb 11, 2024 at 4:41 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 2/11/24 13:37, steott@gmail.com wrote:
[snip] 
>
> The same query, executed from pgAdmin, returns the result in less than a
> second (even if it’s executed while the query from my app is running).
>
> (actually the result are 0 record, but it’s correct: the query it’s just
> a validation that there are no records in that query)
[snip] 
> Do you have any suggestions to solve this problem?
>

Run ANALYZE on the tables/database.
 
If ANALYZE was the cure, why does it successfully run from PgAdmin?

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: How to do faster DML
Next
From:
Date:
Subject: RE: Query hangs (and then timeout) after using COPY to import data