Re: [PERFORM] Strange result: UNIX vs. TCP/IP sockets

2003-07-08 Thread Andrew Sullivan
Hi all, You may remember in my last report, I said that it appeared that TCP/IP connections caused EXPLAIN ANALYSE to return (repeatably but not consistently) slower times than when connected over UNIX domain sockets. This turns out to be false. We (well, Chris Browne, actually) ran some tests

Re: [PERFORM] Strange result: UNIX vs. TCP/IP sockets

2003-07-05 Thread Andrew Sullivan
On Fri, Jul 04, 2003 at 05:47:27PM -0400, Tom Lane wrote: > Andrew Sullivan <[EMAIL PROTECTED]> writes: > > How could it be the transport affects the time for the query as > > reported by the back end? > > How much data is being sent back by the query? In this case, it's an all-aggregate query:

Re: [PERFORM] Strange result: UNIX vs. TCP/IP sockets

2003-07-04 Thread Tom Lane
Andrew Sullivan <[EMAIL PROTECTED]> writes: > How could it be the transport affects the time for the query as > reported by the back end? How much data is being sent back by the query? Do you have SSL enabled? SSL encryption overhead is nontrivial, especially if any renegotiations happen.

Re: [PERFORM] Strange result: UNIX vs. TCP/IP sockets

2003-07-04 Thread Andrew Sullivan
On Fri, Jul 04, 2003 at 07:55:12PM +0200, Vincent van Leeuwen wrote: > But since this only relates to making and breaking TCP connections, > I don't think this is relevant for a larger query time. It's > probably normal for a TCP connection to be slightly slower than a > unix socket, but I don't t

Re: [PERFORM] Strange result: UNIX vs. TCP/IP sockets

2003-07-04 Thread Rod Taylor
> If I connect using -h 127.0.0.1, however, I can _sometimes_ get the > query to take as long as 1200 msec. The effect is sporadic (of SSL plays havoc with our system when using local loopback for the host on both Solaris 7 and 8. It was probably key renegotiation which 7.4 has addressed. si

Re: [PERFORM] Strange result: UNIX vs. TCP/IP sockets

2003-07-04 Thread Vincent van Leeuwen
http://grotto11.com/blog/slash.html?+1039831658 Summary: IE and IIS cheat at TCP level by leaving out various SYN and ACK packets, thereby making IE requests from IIS servers blazingly fast, and making IE requests to non-IIS servers infuriatingly slow. But since this only relates to making and br

Re: [PERFORM] Strange result: UNIX vs. TCP/IP sockets

2003-07-04 Thread The Hermit Hacker
'K, this is based on "old information", I don't know if Sun changed it 'yet again' ... but, when I was working at the University, one of our IT directors gave me a report that deal with something Sun did (god, I'm so detailed here, eh?) to "mimic" how Microsoft broke the TCP/IP protocol ... the r

[PERFORM] Strange result: UNIX vs. TCP/IP sockets

2003-07-04 Thread Andrew Sullivan
Hi all, We're run into a rather odd problem here, and we're puzzling out what's going on. But while we do, I thought I'd see if anyone else has anything similar to report. This is for 7.2.4 on Solaris 8. We have a query for which EXPLAIN ANALYSE on a local psql connection always returns a time