X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 089979FB47C for ; Thu, 20 Jul 2006 16:54:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 21260-01-4 for ; Thu, 20 Jul 2006 19:54:42 +0000 (UTC) X-Greylist: delayed 00:30:02.395199 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 635659FB224 for ; Thu, 20 Jul 2006 11:26:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from skunk.mtbrook.bozemanpass.com (unknown [69.145.82.195]) by svr4.postgresql.org (Postfix) with ESMTP id 3D4B15AF042 for ; Thu, 20 Jul 2006 13:55:43 +0000 (GMT) Received: from [69.145.82.254] (unknown [69.145.82.254]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by skunk.mtbrook.bozemanpass.com (Postfix) with ESMTP id CEE9C738006 for ; Thu, 20 Jul 2006 06:55:06 -0700 (PDT) Message-ID: <44BF8B32.8020507@boreham.org> Date: Thu, 20 Jul 2006 07:54:58 -0600 From: David Boreham User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Performance penalty for remote access of postgresql References: <003d01c6abc6$5039aff0$74304c93@eddy> In-Reply-To: <003d01c6abc6$5039aff0$74304c93@eddy> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200607/199 X-Sequence-Number: 20059 Guoping Zhang wrote: > >a) SERVER A to SERVER B: 0.35ms > SERVER A to itself (Local host): 0.022ms > > > 0.35ms seems rather slow. You might try investigating what's in the path. For comparison, between two machines here (three GigE switches in the path), I see 0.10ms RTT. Between two machines on the same switch I get 0.08ms.