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