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 92D6F3A5F30 for ; Mon, 6 Dec 2004 16:26:32 +0000 (GMT) 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 88237-01 for ; Mon, 6 Dec 2004 16:26:27 +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 A93EB3A5F1D for ; Mon, 6 Dec 2004 16:26:25 +0000 (GMT) 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; 6 Dec 2004 16:26:24 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 539F04055; Mon, 6 Dec 2004 11:26:17 -0500 (EST) Date: Mon, 6 Dec 2004 11:26:17 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Load Balancing/Multiple Postgres Machines Message-ID: <20041206162617.GB22712@phlogiston.dyndns.org> Mail-Followup-To: pgsql-admin@postgresql.org References: <41AB78C8.2070605@commandprompt.com> <200411291606.50825.darcy@wavefire.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200411291606.50825.darcy@wavefire.com> User-Agent: Mutt/1.5.6+20040722i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.03 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/42 X-Sequence-Number: 15628 On Mon, Nov 29, 2004 at 04:06:50PM -0800, Darcy Buskermolen wrote: > > You may also want to look at upgrading to PostgreSQL 7.4.6 or 8.0 since they > both go a long way to improve performance, which might mittage your CPU bound > problem as it is now. What Darcy said. We had an immense speed improvement by moving from 7.2.x to 7.4.x -- so much so that my QA guys didn't believe their tests the first time, and ran them all again. A -- Andrew Sullivan | ajs@crankycanuck.ca Information security isn't a technological problem. It's an economics problem. --Bruce Schneier