search

igrishaev / pg2

A fast PostgreSQL driver for Clojure
https://github.com/igrishaev/pg2
The Unlicense
101 stars 2 forks source link

Add support for pipeline mode #19

Open thenonameguy opened 1 week ago

thenonameguy commented 1 week ago

It would be great if pg2 supported pipelining: https://www.postgresql.org/docs/current/libpq-pipeline-mode.html

Use-case: executing a large amount of independent CREATE statement against a remote server (with high roundtrip time)

Alternative: Creating a DO block of all the statements together, but this changes the semantics to be all-succeed / none-succeed.

igrishaev commented 1 week ago

I think it's possible using a mixture or SYNC and Execute commands. I need to have a deeper look at it.