Pipelining in psql (PostgreSQL 18)
What is pipelining in Postgres?
Pipelining is a client-side feature supported by the network protocol
that basically consists of
not waiting for the results of previously sent queries before sending the next.
This increases the throughput in two ways:
The client, network and server can work in parallel. For instance,
the network may transmit the results of the (N-1)th query while the
server executes the Nth query and the client sends the (N+1)th query,
all this at the same time.
The network is b...
Read more at postgresql.verite.pro