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

Hello, I'm new to PostgreSQL. I'm trying to migrate an app from SqlServer to Postgres (it's written in C# and uses Npgsql) I've tried with Postgres 16.1 and 16.2 on Windows Server 2019. This app used SqlServer's Bulk Insert to import some tables (about 50 tables) from another database, I rep

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

Thanks, Adrian, for the suggestion, but same problem. I've just tried to execute "ANALYZE" (on the whole database) after the import of all the tables (with COPY) and before the other queries, but the query always hangs (I hope this was the way you suggested). Stefano > -Original Message---