Re: transitive pruning optimization on the right side of a join for partition tables

Hi,

On 30 September 2012 16:36, Waldo, Ethan <ewaldo@healthetechs.com> wrote:
> Once again I reiterate that I don't have control over the query construction
> and I am currently running postgresql 9.1.5.  My question is, does
> postgresql support transitive pruning optimization on the right side of a
> join for partition tables?  If so, how do I get that to work?  If not, are
> there plans for this and when should a release with this feature be
> expected?

No, postgres is not smart enough. You need to use same condition
("dates"."recorded_on_id" = ...) for myfact table
("myfact"."recorded_on_id" = ) but you do not have control over the
query construction...


--
Ondrej Ivanic
(ondrej.ivanic@gmail.com)