X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 798E632A05F for ; Tue, 19 Oct 2004 17:28:31 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52382-08 for ; Tue, 19 Oct 2004 16:28:24 +0000 (GMT) Received: from smtp103.rog.mail.re2.yahoo.com (smtp103.rog.mail.re2.yahoo.com [206.190.36.81]) by svr1.postgresql.org (Postfix) with SMTP id 51EFF329EB7 for ; Tue, 19 Oct 2004 17:28:23 +0100 (BST) Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@65.49.125.184 with login) by smtp103.rog.mail.re2.yahoo.com with SMTP; 19 Oct 2004 16:28:22 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 62E6C4055; Tue, 19 Oct 2004 12:28:21 -0400 (EDT) Date: Tue, 19 Oct 2004 12:28:21 -0400 From: Andrew Sullivan To: "Pgsql-Admin@Postgresql. Org" Subject: Re: NIC to NIC connection Message-ID: <20041019162821.GJ3359@phlogiston.dyndns.org> Mail-Followup-To: "Pgsql-Admin@Postgresql. Org" References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6+20040722i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/234 X-Sequence-Number: 15227 On Tue, Oct 19, 2004 at 12:05:05PM -0400, Kent Anderson wrote: > We are upgrading our servers and have run into an interesting situation. It > has been proposed that we have a direct connection from the web servers to > the postgres server via extra NICs. > Before we even waste time installing the NIC's I would like a sense of how > hard it is to get postgres to use that kind of a connection vs over the > Internet. I don't understand. What interface other than a NIC are you now using to go "over the Internet"? Or do you mean that you want an _extra_ IP address so that the web servers don't have to compete for the bandwidth? In that case, sure, you'll probably get a minor performance increase, depending on your current network traffic. A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland