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
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:
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.
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
> 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
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
'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
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