Postgres Pro
Downloads
Home   >   mailing lists

Re: Materialize Subplan and push into inner index conditions - Mailing list pgsql-performance

From Tom Lane
Subject Re: Materialize Subplan and push into inner index conditions
Date
Msg-id 16084.1136303014@sss.pgh.pa.us
Whole thread Raw
In response to Materialize Subplan and push into inner index conditions  (Jens-Wolfhard Schicke <ml+pgsql-performance@asco.de>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Jens-Wolfhard Schicke
Date:
Subject: Materialize Subplan and push into inner index conditions
Next
From: Steve Eckmann
Date:
Subject: improving write performance for logging application