Re: BUG #17871: JIT during postgresql_fdw remote_estimates EXPLAIN have very negatively effect on planning time - Mailing list pgsql-bugs

Andres Freund <andres@anarazel.de> writes:
> On 2023-03-27 08:04:59 +0000, PG Bug reporting form wrote:
>> postgresql_fdw remote estimated  explain calls could trigger JIT compilation
>> on the remote side (why explain without analyze trying use JIT at all???),
>> and with partitioned tables it will lead to very slow planning.

> It should not trigger all of JIT, just generating the bitcode, but not
> optimizing / emitting it.

I was wondering if we could skip doing even that much when
EXEC_FLAG_EXPLAIN_ONLY is set.  Without a test case, though,
I'm not very sure where the jitter is getting reached.

            regards, tom lane