Thread

Re: should we have a fast-path planning for OLTP starjoins?

Bruce Momjian <bruce@momjian.us> — 2025-12-21T02:08:47Z

On Sat, Dec 20, 2025 at 05:49:24PM -0500, Bruce Momjian wrote:
> What Robert is saying in the above paragraph is even more complex ---
> that we might want to use an index on the fact table for a merge join of
> a stage 2 or 3 join, and then do the other joins.  How would we detect
> this?  Could we run each join on its own and see which ones choose merge
> join, and move them to stage 1?

Thinking some more, how likely would we do a merge join before applying
a restrictive join?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.