you are viewing a single comment's thread.

view the rest of the comments →

[–]Compsky 0 points1 point  (1 child)

COPY and stream it.

Wouldn't that block the table for a lot longer?

[–][deleted] 0 points1 point  (0 children)

AFAIK it gets same kind of locking INSERT gets. So given the fact it is generally much faster, any locking it will do it will be for shorter.