X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 678F89DC83D
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue,  3 Jan 2006 11:43:35 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 07371-06
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue,  3 Jan 2006 11:43:40 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id 33E0C9DC832
	for <pgsql-performance@postgresql.org>;
	Tue,  3 Jan 2006 11:43:33 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k03FhYew016085;
	Tue, 3 Jan 2006 10:43:35 -0500 (EST)
To: Jens-Wolfhard Schicke <j.schicke@asco.de>
cc: pgsql-performance@postgresql.org
Subject: Re: Materialize Subplan and push into inner index conditions 
In-reply-to: <B83CC5FD82571D5D9439CE4C@[192.168.1.72]> 
References: <B83CC5FD82571D5D9439CE4C@[192.168.1.72]>
Comments: In-reply-to Jens-Wolfhard Schicke <ml+pgsql-performance@asco.de>
	message dated "Tue, 03 Jan 2006 16:08:48 +0100"
Date: Tue, 03 Jan 2006 10:43:34 -0500
Message-ID: <16084.1136303014@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.063 required=5 tests=[AWL=0.063]
X-Spam-Score: 0.063
X-Spam-Level: 
X-Archive-Number: 200601/2
X-Sequence-Number: 16480

Jens-Wolfhard Schicke <ml+pgsql-performance@asco.de> writes:
> Is it possible to have the planner consider the second plan instead of the 
> first?

At the moment, only if you get rid of the inheritance.  The planner's
not very smart at all when faced with joining inheritance trees.

			regards, tom lane