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

On 2/11/24 13:37, steott@gmail.com wrote:

>
> 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)

> Do you have any suggestions to solve this problem?
>

Run ANALYZE on the tables/database.