Hot answers tagged

1

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://...


1

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