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 DBA2A8BA2F9; Tue, 15 Feb 2005 21:30:18 +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 24250-05; Tue, 15 Feb 2005 21:30:14 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id A1BB28BA0E9; Tue, 15 Feb 2005 21:30:12 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 15 Feb 2005 15:30:09 -0600 Subject: Re: who is best for support? From: Scott Marlowe To: Joel Fradkin Cc: "'Marc G. Fournier'" , pgsql-admin@postgresql.org In-Reply-To: <000c01c513a4$4a562110$797ba8c0@jfradkin> References: <000c01c513a4$4a562110$797ba8c0@jfradkin> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1108503008.11967.194.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 15 Feb 2005 15:30:09 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/133 X-Sequence-Number: 16301 On Tue, 2005-02-15 at 15:21, Joel Fradkin wrote: > Us? :) Can you provide some more details? > > Hardware configuration, > Dell 6560 4 processor, 8 gig memory, I think I have Postgres on two raids four processors, or two hyperthreaded cpus? My experience has been that hyperthreading usually doesn't help, and often hurts performance. This may have improved with later model 2.6 kernels. > separate from the OS (pgsql is a raid 10 4 10kdrive array) and /wal is 2 15k > drives). I am running postgres 8 and am using the conf in > /var/lib/pgslq/data to point the data at /pgsql and a link to point the /wal > I set up inside the /pgsql/data folder to /wal. Which RAID Controller are you using? Does it have battery backed cache? > I have cut out most of the query but even the first join makes it go to 27 > seconds. In MSSQL with the first two left outers it takes 3 seconds. Are the columns you are joining on the same type? Are they integers (the fastest) or numerics (slow) or text (also slow)? Is there a reason you're joining on so many different fields for each table? If there is a good model of FK relations, that isn't usually necessary. IT looks kinda like there's some redundancy in the join on clauses by how may of them are from all over the place in there.