We load large tables in some customer installation (some millions of rows)
from file with:
TRUNCATE TABLE tableName ;
\COPY tableName FROM 'fileName' WITH ( DELIMITER '|' )
May be you could also make sure that loading actually stopped, by checking the size of the data directory. In another session, you could try
watch du -h -s <datadirectory>
Regards,
Jayadevan
