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+TgmoZ3wdn3NJbNLBQgiwUgiCrYiPXZCFvsDpeCO=r2e+ozBQ@mail.gmail.com
Whole thread Raw
In response to Re: allowing extensions to control planner behavior  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
On Fri, Aug 30, 2024 at 1:42 PM Jeff Davis <pgsql@j-davis.com> wrote:
> As far as performance goes, I'm only looking at branch in add_path()
> that calls compare_pathkeys(). Do you have some example queries which
> would be a worst case for that path?

I think we must be talking past each other somehow. It seems to me
that your scheme would require replacing that branch with something
more complicated or generalized. If it doesn't, then I don't
understand the proposal. If it does, then that seems like it could be
a problem.

> In general if you can post some details about how you are measuring,
> that would be helpful.

I'm not really measuring anything at this point, just recalling the
many previous times when add_path() has been discussed as a pain
point.

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



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD
Next
From: Robert Haas
Date:
Subject: Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch