Re: Function scan FDW pushdown

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Function scan FDW pushdown
Date: 2025-08-05 21:32:41
Message-ID: 202508052132.3g3ytrc74bge@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

On 2024-Nov-05, g(dot)kashkin(at)postgrespro(dot)ru wrote:

> This is a long-overdue follow-up to the original patch.
> Note that this patch contains only the changes required for
> function scan pushdown, examples and code related to asymmetric
> join are dropped.

I've marked this as returned with feedback, as several months have
passed without a further version; the current one has a number of
gotchas, including some problematic coding detected by a compiler
warning, as well as unfinished design:

> The issue with setting newrte->functions to NIL still persists.
> [...]
> I am aware that the rte->functions will now be copied even on
> instances that don't utilize a FDW, but I don't see a way to solve it.
> Any suggestions are welcome.

Feel free to reopen this CF entry[1] once you're able to figure this out.

[1] https://commitfest.postgresql.org/patch/5470/

--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2025-08-05 21:35:08 Re: index prefetching
Previous Message Masahiko Sawada 2025-08-05 21:21:57 Re: Convert varatt.h macros to static inline functions