Postgres Pro
Downloads
Home   >   mailing lists

Re: transitive pruning optimization on the right side of a join for partition tables - Mailing list pgsql-general

From madhukiranj
Subject Re: transitive pruning optimization on the right side of a join for partition tables
Date
Msg-id 1350382979906-5728401.post@n5.nabble.com
Whole thread Raw
In response to Re: transitive pruning optimization on the right side of a join for partition tables  ("Waldo, Ethan" <ewaldo@healthetechs.com>)
List pgsql-general
Tree view 
Hi,

I have tried more on this, if you just use an equality constraint on the
foreign key in the right side of the join, it works. Other constraints like
between, in, >,< do not work. Anyone else got to achieve this in postgresql?



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/transitive-pruning-optimization-on-the-right-side-of-a-join-for-partition-tables-tp5726019p5728401.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Who is LISTENing?
Next
From: Maximilian Tyrtania
Date:
Subject: Re: return query execute SQL-problem