Re: allowing extensions to control planner behavior - Mailing list pgsql-hackers

From Robert Haas
Subject Re: allowing extensions to control planner behavior
Date
Msg-id CA+TgmobH2CyoVuNOmzZarspGYbLEtjLax3FgP1ubrAo2tqhvxg@mail.gmail.com
Whole thread Raw
In response to Re: allowing extensions to control planner behavior  (Andrei Lepikhov <lepihov@gmail.com>)
List pgsql-hackers
On Wed, Oct 23, 2024 at 11:51 AM Andrei Lepikhov <lepihov@gmail.com> wrote:
> Parse tree may be implemented with multiple execution plans. Even
> clauses can be transformed during optimisation (Remember OR -> ANY).
> Also, the cardinality of a middle-tree join depends on the inner and
> outer subtrees. Because of that, having a hash on RelOptInfo's relids
> and restrictions + hashes of child RelOptInfos and carrying it through
> all other stages up to the end of execution is the most stable approach
> I know.

I'm not saying there's a better way to do it today. I'm saying I think
there SHOULD be a better way to do it.

--
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Make default subscription streaming option as Parallel
Next
From: Bill Smith
Date:
Subject: Re: msvc directory missing in PostgreSQL 17.0