I sent these earlier, but they didn’t get to the list, so I’m resending — sorry about that.
Which version of postgres?
PostgreSQL 10.8 (Ubuntu 10.8-0ubuntu0.18.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.3.0-16ubuntu3) 7.3.0, 64-bit
How are you loading the data? (application, psql, pg_restore) using
(insert, copy)?
I have a SQL file I’m using filled with statements like:
\copy eis_entity from program 'gzcat /u2/hdhdata/xxx/out1000.txt.gz';
select now();
\copy eis_entity from program 'gzcat /u2/hdhdata/xxx/out1001.txt.gz';
select now();
Thanks