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 A069FB43168 for ; Sat, 5 Jul 2003 20:58:21 +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 53190-04 for ; Sat, 5 Jul 2003 17:57:49 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 2F453B430BF for ; Sat, 5 Jul 2003 17:57:49 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19Yu6S-0002tW-00 for ; Sat, 05 Jul 2003 16:57:52 -0400 Received: by dba2 (Postfix, from userid 1019) id 871C4D75A; Sat, 5 Jul 2003 16:58:15 -0400 (EDT) Date: Sat, 5 Jul 2003 16:58:15 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Strange result: UNIX vs. TCP/IP sockets Message-ID: <20030705205815.GA7713@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> <20030704212053.GD5679@libertyrms.info> <8908.1057355247@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <8908.1057355247@sss.pgh.pa.us> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/99 X-Sequence-Number: 2392 On Fri, Jul 04, 2003 at 05:47:27PM -0400, Tom Lane wrote: > Andrew Sullivan 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: select count(*), min(id) from sometable where owner = int4; (Yeah, yeah, I know. I didn't write it.) But it's the EXPLAIN ANALYSE that's reporting different times depending on the transport. That's what I find so strange. > Do you have SSL enabled? SSL encryption overhead is nontrivial, > especially if any renegotiations happen. No. -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110