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 01178B438DC for ; Fri, 4 Jul 2003 21:20:39 +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 19991-07 for ; Fri, 4 Jul 2003 18:20:29 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 0F642B43175 for ; Fri, 4 Jul 2003 18:20:29 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19YXyp-0003U2-00 for ; Fri, 04 Jul 2003 17:20:31 -0400 Received: by dba2 (Postfix, from userid 1019) id E906FD75A; Fri, 4 Jul 2003 17:20:53 -0400 (EDT) Date: Fri, 4 Jul 2003 17:20:53 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Strange result: UNIX vs. TCP/IP sockets Message-ID: <20030704212053.GD5679@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <20030704172205.GH4707@libertyrms.info> <20030704143143.U45926@hub.org> <20030704175512.GB24859@md2.mediadesign.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030704175512.GB24859@md2.mediadesign.nl> User-Agent: Mutt/1.5.4i X-Archive-Number: 200307/95 X-Sequence-Number: 2388 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 think that's wat Andrew is experiencing. No, it's not. And my colleague Sorin Iszlai pointed out to me something else about it: we're getting different numbers reported by EXPLAIN ANALYSE itself. How is that even possible? If we try it here on a moderately-loaded Sun box, it seems we're able to reproduce it, as well. How could it be the transport affects the time for the query as reported by the back end? A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110