How do you insert or update millions of rows efficiently?

Question

Accepted Answer

Row-by-row INSERT over JDBC is the slowest way to load data. Batch many rows per round trip, use COPY for bulk loads, and drop non-essential indexes until the load finishes.