socket slowdown using libpg and 7.1.1 ?
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
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
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
Import Notes
Reply to msg id not found: 023e01c0dd5d$4adcdf60$c60215ac@wkcws2k1
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 ?
Show quoted text
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