Hi Jayadevan,
> On 19. Nov, 2020, at 11:07, Jayadevan M wrote:
>
> 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
that might be misleading if you have the pg_wal directory inside
>
> 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 direct
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
Hello,
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 g
