Re: Materialize Subplan and push into inner index conditions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jens-Wolfhard Schicke <j(dot)schicke(at)asco(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Materialize Subplan and push into inner index conditions
Date: 2006-01-03 15:43:34
Message-ID: 16084.1136303014@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jens-Wolfhard Schicke <ml+pgsql-performance(at)asco(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-01-03 16:35:56 Re: Stats collector performance improvement
Previous Message Jens-Wolfhard Schicke 2006-01-03 15:08:48 Materialize Subplan and push into inner index conditions