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 which demonstrated that the performance problem turned up over the UNIX socket, as well. It was just a statistical fluke that our smaller sample always found the problem on TCP/IP. Of course, now we have some other work to do, but we can rule out the transport at least. Chalk one up for sane results. If we discover any more, I'll post it here. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <[EMAIL PROTECTED]> M2P 2A8 +1 416 646 3304 x110 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster