X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C6A7ED1E139 for ; Fri, 12 Dec 2003 15:47:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 42827-04 for ; Fri, 12 Dec 2003 11:47:26 -0400 (AST) Received: from grouse.mail.pas.earthlink.net (grouse.mail.pas.earthlink.net [207.217.120.116]) by svr1.postgresql.org (Postfix) with ESMTP id DB06ED1B4AE for ; Fri, 12 Dec 2003 11:46:50 -0400 (AST) Received: from user-11202lf.dsl.mindspring.com ([66.32.10.175] helo=shadovitzcmptr) by grouse.mail.pas.earthlink.net with smtp (Exim 3.33 #1) id 1AUpVF-0001ZS-00; Fri, 12 Dec 2003 07:46:53 -0800 Received: by localhost with Microsoft MAPI; Fri, 12 Dec 2003 07:46:42 -0800 Message-ID: <01C3C084.156718C0.david@shadovitz.com> From: David Shadovitz Reply-To: "david@shadovitz.com" To: "'pgsql-performance@postgresql.org'" Cc: 'Tom Lane' Subject: Re: Query plan - now what? Date: Fri, 12 Dec 2003 07:46:36 -0800 X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/199 X-Sequence-Number: 5059 > This is not very informative when you didn't show us the query nor > the table schemas.. > BTW, what did you do with this, print and OCR it? Tom, I work in a classified environment, so I had to sanitize the query plan, print it, and OCR it. I spent a lot of time fixing typos, but I guess at midnight my eyes missed some. This hassle is why I posted neither the query nor the schema. The database is normalized, though, but my use of animal names of couse masks this. If you think that you or anyone else would invest the time, I could post more info. I will also try Shridhar's suggestions on statistics_target and enable_hash_join. Thanks. -David