X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 40280B430C2 for ; Tue, 8 Jul 2003 20:54:56 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 50031-03 for ; Tue, 8 Jul 2003 17:54:25 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 7E6A3B430A6 for ; Tue, 8 Jul 2003 17:54:24 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19ZzTm-0003ev-00 for ; Tue, 08 Jul 2003 16:54:26 -0400 Received: by dba2 (Postfix, from userid 1019) id DE55AD75A; Tue, 8 Jul 2003 16:54:48 -0400 (EDT) Date: Tue, 8 Jul 2003 16:54:48 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Strange result: UNIX vs. TCP/IP sockets Message-ID: <20030708205448.GE13501@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <20030704172205.GH4707@libertyrms.info> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030704172205.GH4707@libertyrms.info> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/144 X-Sequence-Number: 2437 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 M2P 2A8 +1 416 646 3304 x110