> Right now, that implies quite a few round-trips to the server, about 1'100, but on the LAN with sub-ms latency;
How much sub-ms? I mean, I have 0.74 pings to my router, but this would be .82s, a good chunk of your quoted 2-3s, (and I'm not sure if libpq can do all queries in one RTT ).
Windows ping only says:
bytes=32 time<1ms TTL=64
But Linux ping does say:
icmp_seq=8 ttl=64 time=0.236 ms (I picked the worse one).
So even with 1K round-trips, that should account only for +/- 250ms (1/10th the total). --DD
