Thread

1. socket slowdown using libpg and 7.1.1 ?

   Chris Storah <cstorah@emis-support.demon.co.uk> — 2001-05-15T15:44:57Z

   Are there any problems with 7.1.1 when using libpg and TCP/IP socket
   connections?
   I have three machines, two with 7.1.1 and the other with 7.0.3.
   
   The 7.1.1 machines are 40 times slower than the 7.0.3 machine at returning
   the result sets.
   
   I haven't included a query example/data as it is happening on all select
   queries.
   Running native psql is fine and returns the results in a comparative time,
   which points at the TCP socket side of things? All machines are on the same
   100Meg LAN, so networking is okay
   
   Do you need more details?
   If so, what logs etc. are helpful?
   
   Thanks,
   Chris
   
   
   

2. Re: socket slowdown using libpg and 7.1.1 ?

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-05-15T16:00:01Z

   Chris Storah <cstorah@emis-support.demon.co.uk> writes:
   > Are there any problems with 7.1.1 when using libpg and TCP/IP socket
   > connections?
   
   No one else has reported any such problem.
   
   > Running native psql is fine and returns the results in a comparative time,
   > which points at the TCP socket side of things?
   
   Are you sure you are talking to the same server in both cases?
   
   			regards, tom lane
   
   

3. Re: socket slowdown using libpg and 7.1.1 ?

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-05-15T16:33:53Z

   Chris Storah <cstorah@emis-support.demon.co.uk> writes:
   > Seems to be only when cursors are used
   
   Offhand I know of no reason why cursors would be slower than in 7.0.*.
   Please provide a self-contained example ...
   
   			regards, tom lane
   
   

4. Re: socket slowdown using libpg and 7.1.1 ?

   Chris Storah <cstorah@emis-support.demon.co.uk> — 2001-05-15T16:36:52Z

   managed to get a bit more info...
   
   Seems to be only when cursors are used - rewrote the code to do a PQexec and
   fetch the tuples and it is faster than 7.0.3 which is good :)
   
   I will hack about with the client code tonight to see if I can narrow it
   down more.
   
   Chris
   
   ----- Original Message -----
   From: "Tom Lane" <tgl@sss.pgh.pa.us>
   To: "Chris Storah" <cstorah@emis-support.demon.co.uk>
   Cc: <pgsql-bugs@postgresql.org>
   Sent: Tuesday, May 15, 2001 5:00 PM
   Subject: Re: [BUGS] socket slowdown using libpg and 7.1.1 ?
   
   
   > Chris Storah <cstorah@emis-support.demon.co.uk> writes:
   > > Are there any problems with 7.1.1 when using libpg and TCP/IP socket
   > > connections?
   >
   > No one else has reported any such problem.
   >
   > > Running native psql is fine and returns the results in a comparative
   > time,
   > > which points at the TCP socket side of things?
   >
   > Are you sure you are talking to the same server in both cases?
   >
   > regards, tom lane