Re: Removing unneeded self joins - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Removing unneeded self joins
Date
Msg-id aHbTQPyMrERHNghh@paquier.xyz
Whole thread Raw
In response to Re: Removing unneeded self joins  (Alexander Korotkov <aekorotkov@gmail.com>)
Responses Re: Removing unneeded self joins
List pgsql-hackers
On Wed, Jul 16, 2025 at 12:38:58AM +0300, Alexander Korotkov wrote:
> I recently got notification this is in Open Items.
> https://wiki.postgresql.org/wiki/PostgreSQL_18_Open_Items
> What is your opinion on this: do we need additional hook, fair to
> leave this "as is" or another option?

I'm OK with the statu-quo on my side when it comes to plan hinting.
With the GUC workaround, it's still possible to get through so it is
not like we don't have any options.  The point about other extensions
still stands, I think, but perhaps we are OK even on these fronts as
the join search hook is far from being the most popular one AFAIK.

So dropping the item and do nothing is a fine answer.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages
Next
From: Alexander Korotkov
Date:
Subject: Re: Removing unneeded self joins