logoalt Hacker News

philjohnyesterday at 7:31 PM1 replyview on HN

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.


Replies

sirfzyesterday at 8:34 PM

That doesn't work well with conflicts tho iirc