On Wed, Aug 28, 2024 at 3:23 PM Jeff Davis <pg...@j-davis.com> wrote: > On Tue, 2024-08-27 at 15:11 -0400, Robert Haas wrote: > > - control over scan methods > > - control over index selection > > - control over join methods > > - control over join order > > I suggest we split join order into "commutative" and "associative". > > The former is both useful and seems relatively easy -- A JOIN B or B > JOIN A (though there's some nuance about when you try to make that > decision). > > The latter requires controlling an explosion of possibilities, and > would be an entirely different kind of hook.
My proposal in http://postgr.es/m/CA+TgmoZQyVxnRU--4g2bJonJ8RyJqNi2CHpy-=nwwbtnpaj...@mail.gmail.com seems like it can cover both cases. -- Robert Haas EDB: http://www.enterprisedb.com
