Skip Navigation

What happens when you COPY in Postgres?

blog.benthem.io What actually happens when you COPY in Postgres?

I recently had someone ask me why the COPY command is more performant than INSERT INTO. While coming up with an answer, I discovered I was starting from a deficient: I didn’t know how COPY works under the hood. Trying to come up with an answer was at best a guess. Through this post, I hope to narrow...

There is a discussion on Hacker News, but feel free to comment here as well.

1
1 comments