Postgres Pro
Downloads
Home   >   mailing lists

Best practices for Large import in empty database? - Mailing list pgsql-general

From Daniel Begin
Subject Best practices for Large import in empty database?
Date
Msg-id COL129-DS24174E61E56DB5BB5E51F894B80@phx.gbl
Whole thread Raw
Responses Re: Best practices for Large import in empty database?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Best practices for Large import in empty database?  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Emanuel Araújo
Date:
Subject: Extract especific text from a sql statement
Next
From: Tom Lane
Date:
Subject: Re: Best practices for Large import in empty database?