On Thu, 2020-11-19 at 08:38 +0100, Matthias Apitz wrote: > We load large tables in some customer installation (some millions of rows) > from file with: > > TRUNCATE TABLE tableName ; > \COPY tableName FROM 'fileName' WITH ( DELIMITER '|' ) > > and got to know that the loading nearly stops (without any real CPU > consumption) in the middle. The wild guess is that we forgot to DROP the > indexes on > the tables.
If it does not consume CPU, it must be stalled somehow. Are there any wait events in "pg_stat_activity". Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
