public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tom Lane <[email protected]>
To: Robert Haas <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: allowing extensions to control planner behavior
Date: Tue, 27 Aug 2024 16:15:35 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+TgmoZzVkdRORr-GPDu-viMO8sUUiNzN8nKQbdHO_U3Z+EDLw@mail.gmail.com>
References: <CA+TgmoZY+baV-T-5ifDn6P=L=aV-VkVBrPmi0TQkcEq-5Finww@mail.gmail.com>
<[email protected]>
<CA+TgmoZ9PNTKBOeP2rAXoi15nTg+NpYUiSGRgpMhz0nY1wpUtg@mail.gmail.com>
<CA+TgmobN=JiV8uw69aNjSazQm_bpWNGsSCoR18JzpS9b4uhusA@mail.gmail.com>
<[email protected]>
<CA+TgmoY8sw-xD8EPC-8APd+0KCEdSdREb8bS3wqfpzRqcOmzYg@mail.gmail.com>
<[email protected]>
<CA+TgmoZzVkdRORr-GPDu-viMO8sUUiNzN8nKQbdHO_U3Z+EDLw@mail.gmail.com>
Robert Haas <[email protected]> writes:
> I believe the minimum viable product here
> is probably something like:
> - control over scan methods
> - control over index selection
> - control over join methods
> - control over join order
Seems reasonable. It might be possible to say that our answer
to "control over join order" is to provide a hook that can modify
the "joinlist" before it's passed to make_one_rel. If you want
to force a particular join order you can rearrange that
list-of-lists-of-range-table-indexes to do so. The thing this
would not give you is control over which rel is picked as outer
in any given join step. Not sure how critical that bit is.
regards, tom lane
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: allowing extensions to control planner behavior
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox