News for hackers. Stuff that matters.
Re:Thinking Psycopg3 by anarazel on Friday March 13, 2020 @02:09PM (#22569498)
And relevant to the roundtrip issue at hand here: You can send bind/execute in a pipelined manner.

I'd benchmarked batch upserting at some point, and at that time for large amounts of data the fastest approach was somewhat unintuitive: A separate view with an INSTEAD trigger doing the upserting. That allows for use of COPY based streaming (less traffic than doing separate bind/exec, less dispatch overhead), and still allows use of upsert. Not a great solution, but ...

There are no comments on this comment yet.