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 7422EB439CA for ; Fri, 4 Jul 2003 21:47:40 +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 29892-01 for ; Fri, 4 Jul 2003 18:47:30 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id AAADBB439C2 for ; Fri, 4 Jul 2003 18:47:29 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h64LlSQQ008909; Fri, 4 Jul 2003 17:47:30 -0400 (EDT) To: Andrew Sullivan Cc: pgsql-performance@postgresql.org Subject: Re: Strange result: UNIX vs. TCP/IP sockets In-reply-to: <20030704212053.GD5679@libertyrms.info> References: <20030704172205.GH4707@libertyrms.info> <20030704143143.U45926@hub.org> <20030704175512.GB24859@md2.mediadesign.nl> <20030704212053.GD5679@libertyrms.info> Comments: In-reply-to Andrew Sullivan message dated "Fri, 04 Jul 2003 17:20:53 -0400" Date: Fri, 04 Jul 2003 17:47:27 -0400 Message-ID: <8908.1057355247@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200307/96 X-Sequence-Number: 2389 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? Do you have SSL enabled? SSL encryption overhead is nontrivial, especially if any renegotiations happen. regards, tom lane