[philjohn]

If you're doing large batch inserts, I've found using the COPY INTO the fastest way, especially if you use the binary data format so there's no overhead on the postgres server side.

[sirfz]

That doesn't work well with conflicts tho iirc

[nicwolff]

COPY INTO a temp table and INSERT INTO... SELECT FROM... ON CONFLICT UPDATE...