On Mon, Apr 27, 2015 at 5:05 AM, Shigeru HANADA
<shigeru.hanada@gmail.com> wrote:
> Currently INNER JOINs with unsafe join conditions are not pushed down, so such test is not in the suit. As you say,
intheory, INNER JOINs can be pushed down even they have push-down-unsafe join conditions, because such conditions can
beevaluated no local side against rows retrieved without those conditions.
I suspect it's worth trying to do the pushdown if there is at least
one safe joinclause. If there are none, fetching a Cartesian product
figures to be a loser.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company