On 10/1/2014 9:13 AM, Daniel Begin wrote:
> I am about to feed an empty database with a large import of data (the
> size of csv files is about 500 GB). Tables are created but I haven't
> added any constraints or indexes yet. I wonder whether the best practice
> is to add them before or after the import. Are there other good
> practices that would ease the import process?
>
> Cheers,
>
> Daniel
>
create index after, as long as you dont need it for uniqueness checking.
then:
begin;
truncate table junk;
copy ... with freeze;
commit;
Even though the table is empty, the begin,trunc,copy lets PG skip a
bunch of extra WAL.
-Andy