Would be interesting to see these comparisons with pipeline mode, since it seems like it would address a lot of the issues covered in this post
In my experience pipelining inserts is not nearly as fast as COPY, although obviously it’s a lot more flexible.