Postgres Pro
Downloads
Home   >   mailing lists

Re: \COPY command and indexes in tables - Mailing list pgsql-general

From Jayadevan M
Subject Re: \COPY command and indexes in tables
Date
Msg-id CAFS1N4gBNKFAvqoiZrZ_3r7KRHBGYXKCBJsSoT1eP6oR17+huw@mail.gmail.com
Whole thread Raw
In response to \COPY command and indexes in tables  (Matthias Apitz <guru@unixarea.de>)
Responses Re: \COPY command and indexes in tables
List pgsql-general
Tree view




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

pgsql-general by date:

Previous
From: Alastair McKinley
Date:
Subject: Performance degradation with non-null proconfig
Next
From: Paul Förster
Date:
Subject: Re: \COPY command and indexes in tables