X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 62AA98B9F68 for ; Thu, 10 Feb 2005 01:27:30 +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 58803-04 for ; Thu, 10 Feb 2005 01:27:18 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.197]) by svr1.postgresql.org (Postfix) with ESMTP id E4AD68BA076 for ; Thu, 10 Feb 2005 01:27:20 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id j1so15498rnf for ; Wed, 09 Feb 2005 17:27:18 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=LGisWLXArhba0Xl+YSHIodzohCYLn/kG2yY5kyMq7oPNvbMyxEs1Hf4oZ2gpFt7ncKr42abbBvadWwkxIgPT4zWjfLun07NAucT6/HvPIC+IRsTCFfp6JRB/gTUxmxWlbfIsLfctL9wWJaOZsryENMyw1HdQxNEpnWVdSkFLF4I= Received: by 10.38.65.51 with SMTP id n51mr47742rna; Wed, 09 Feb 2005 17:27:18 -0800 (PST) Received: by 10.38.126.43 with HTTP; Wed, 9 Feb 2005 17:27:16 -0800 (PST) Message-ID: Date: Thu, 10 Feb 2005 01:27:16 +0000 From: Mike Rylander Reply-To: Mike Rylander To: Chris Kratz Subject: Re: Performance Tuning Cc: Merlin Moncure , pgsql-performance@postgresql.org In-Reply-To: <200502091730.41997.chris.kratz@vistashare.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <6EE64EF3AB31D5448D0007DD34EEB3412A7615@Herge.rcsinc.local> <200502091730.41997.chris.kratz@vistashare.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.055 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/163 X-Sequence-Number: 10492 On Wed, 9 Feb 2005 17:30:41 -0500, Chris Kratz wrote: > The solutions appear to primarily be: > 1. Going to faster hardware of which probably Opterons would be about the only > choice. And even that probably won't be a huge difference. I'd beg to differ on that last part. The difference between a 3.6GHz Xeon and a 2.8GHz Opteron is ~150% speed increase on the Opteron on my CPU bound app. This is because the memory bandwidth on the Opteron is ENORMOUS compared to on the Xeon. Add to that the fact that you actually get to use more than about 2G of RAM directly and you've got the perfect platform for a high speed database on a budget. > 2. Moving to more materialized views and prepared statements where we can. Definitely worth investigating. I wish I could, but I can't get my customers to even consider slightly out of date stats.... :( > 3. Continue to tweak the sql behind our app. Short of an Opteron based system, this is by far your best bet. -- Mike Rylander mrylander@gmail.com GPLS -- PINES Development Database Developer http://open-ils.org