Hot answers tagged import
The default postgresql configuration is not good for bulk import of data. The main thing you need to do before importing that much data is to increase max_wal_size to reduce the number of times postgresql will need to perform a checkpoint during the import. Also, if you are certain about the quality of the data, import it within a transaction. See https://...
If you get an error from zcat, in which the error message contains the file name with an extra suffix .Z, then try using gzcat instead, as described at http://stackoverflow.com/questions/296717/zcat-wont-unzip-files-properly
Only top voted, non community-wiki answers of a minimum length are eligible