What’s the fastest way to do a bulk insert into Postgres?

by

PostgreSQL has a guide on how to best populate a database initially, and they suggest using the COPY command for bulk loading rows. The guide has some other good tips on how to speed up the process, like removing indexes and foreign keys before loading the data (and adding them back afterwards).

More Related Contents:

  1. How do I temporarily disable triggers in PostgreSQL?
  2. In psql, why do some commands have no effect?
  3. How to log PostgreSQL queries?
  4. psql: FATAL: Ident authentication failed for user “postgres”
  5. Use multiple conflict_target in ON CONFLICT clause
  6. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  7. How to find table creation time?
  8. What is the format for the PostgreSQL connection string / URL?
  9. Where does PostgreSQL store the database?
  10. How to add “on delete cascade” constraints?
  11. Is there a way to disable function overloading in Postgres
  12. Grant all on a specific schema in the db to a group role in PostgreSQL
  13. Can I make a plpgsql function return an integer without using a variable?
  14. Migrate database from Postgres to MySQL [closed]
  15. How can I start PostgreSQL on Windows?
  16. PostgreSQL – max number of parameters in “IN” clause?
  17. SQLAlchemy, Psycopg2 and Postgresql COPY
  18. Why can I create a table with PRIMARY KEY on a nullable column?
  19. Oracle SQL Developer and PostgreSQL
  20. PostgreSQL array of elements that each are a foreign key
  21. How to reset sequence in postgres and fill id column with new data?
  22. Postgres ERROR: could not open file for reading: Permission denied
  23. Custom ORDER BY Explanation
  24. Configure JPA to let PostgreSQL generate the primary key value
  25. ERROR: unterminated quoted string at or near
  26. How can I send some http request from postgresql function or trigger
  27. Alternate output format for psql showing one column per line with column name
  28. Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib
  29. Destroying a Postgres DB on Heroku
  30. Selecting rows ordered by some column and distinct on another

Leave a Comment