Re: About the constant-TRUE clause in reconsider_outer_join_clauses - Mailing list pgsql-hackers

From Tom Lane
Subject Re: About the constant-TRUE clause in reconsider_outer_join_clauses
Date
Msg-id 2583984.1679758907@sss.pgh.pa.us
Whole thread Raw
In response to About the constant-TRUE clause in reconsider_outer_join_clauses  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: About the constant-TRUE clause in reconsider_outer_join_clauses
List pgsql-hackers
Richard Guo <guofenglinux@gmail.com> writes:
> Should we instead mark the constant-TRUE clause with required_relids
> plus the OJ relid?

I do not think it matters.

> Even if the join does become clauseless, it will end up being an
> unqualified nestloop.  I think the join ordering algorithm will force
> this join to be formed when necessary.

We would find *some* valid plan, but not necessarily a *good* plan.
The point of the dummy clause is to ensure that the join is considered
as soon as possible.  That might not be the ideal join order of course,
but we'll consider it among other join orders and arrive at a cost-based
decision.  With no dummy clause, the join order heuristics would always
delay this join as long as possible; so even if another ordering is
better, we'd not find it.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: hio.c does visibilitymap_pin()/IO while holding buffer lock
Next
From: Joseph Koshakow
Date:
Subject: Re: Infinite Interval