On Wed, 4 May 2005, Mischa Sandberg wrote:

> Copy makes better use of the TCP connection for transmission. COPY uses
> the TCP connection like a one-way pipe. INSERT is like an RPC: the
> sender has to wait until the insert's return status roundtrips.

Not true.  A client may send any number of Bind/Execute messages on a 
prepared statement before a Sync message.  So multiple inserts may be sent 
in one network roundtrip.  This is exactly how the JDBC driver 
implements batch statements.  There is some limit to the number of queries 
in flight at any given moment because there is the potential to deadlock 
if both sides of network buffers are filled up and each side is blocked 
waiting on a write.  The JDBC driver has conservatively selected 256 as 
the maximum number of queries to send at once.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to