Author: Written by Tom Lane, from an e-mail message dated 1999-12-05.
One may need to do a large number of table insertions when first populating a database. Here are some tips and techniques for making that as efficient as possible.
Turn off auto-commit and just do one commit at the end. Otherwise Postgres is doing a lot of work for each record added. In general when you are doing bulk inserts, you want to turn off some of the database features to gain speed.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.