Re: BUG #17871: JIT during postgresql_fdw remote_estimates EXPLAIN have very negatively effect on planning time

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Andres Freund <andres@anarazel.de>, maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2023-03-28T03:20:30Z
Lists: pgsql-bugs
David Rowley <dgrowleyml@gmail.com> writes:
> I guess that means just add a check for EXEC_FLAG_EXPLAIN_ONLY in
> jit_compile_expr, or only set the es_jit_flags bits in
> standard_ExecutorStart() when not in EXEC_FLAG_EXPLAIN_ONLY. I'm not
> really sure which of those is better, but the attached does the former
> and seems to fix the issue.

Hmm, offhand I'd vote for the latter, because it adds cycles only
once per query not once per expression.  But Andres may have a
better idea about how to do this.

			regards, tom lane