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 12791D1B481 for ; Fri, 12 Dec 2003 16:53:50 +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 53512-08 for ; Fri, 12 Dec 2003 12:53:18 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 3EC1BD1B8BE for ; Fri, 12 Dec 2003 12:53:17 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hBCGqu19020395; Fri, 12 Dec 2003 11:53:16 -0500 (EST) To: "david@shadovitz.com" Cc: "'pgsql-performance@postgresql.org'" Subject: Re: Query plan - now what? In-reply-to: <01C3C084.156718C0.david@shadovitz.com> References: <01C3C084.156718C0.david@shadovitz.com> Comments: In-reply-to David Shadovitz message dated "Fri, 12 Dec 2003 07:46:36 -0800" Date: Fri, 12 Dec 2003 11:52:56 -0500 Message-ID: <20394.1071247976@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/202 X-Sequence-Number: 5062 David Shadovitz writes: > If you think that you or anyone else would invest the time, I could post more > info. I doubt you will get any useful help if you don't post more info. > I will also try Shridhar's suggestions on statistics_target and > enable_hash_join. It seemed to me that the row estimates were not so far off that I would call it a statistical failure; you can try increasing the stats target but I'm not hopeful about that. My guess is that you will have to look to revising either the query or the whole database structure (ie, merging tables). We'll need the info I asked for before we can make any recommendations, though. regards, tom lane