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
Subject: Re: BUG #17871: JIT during postgresql_fdw remote_estimates EXPLAIN
 have very negatively effect on planning time
In-reply-to: 
 <CAApHDvqqJ+Q3p984U4Qu3DJ3PEZUAu=8-reH3-Ztv+sVoYkAhA@mail.gmail.com>
References: <17871-16521a70c16cb83c@postgresql.org>
 <20230327212830.dpp2u47je5ozf5q7@awork3.anarazel.de>
 <3348298.1679953099@sss.pgh.pa.us>
 <CAApHDvqqJ+Q3p984U4Qu3DJ3PEZUAu=8-reH3-Ztv+sVoYkAhA@mail.gmail.com>
Comments: In-reply-to David Rowley <dgrowleyml@gmail.com>
	message dated "Tue, 28 Mar 2023 16:05:00 +1300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3386396.1679973630.1@sss.pgh.pa.us>
Date: Mon, 27 Mar 2023 23:20:30 -0400
Message-ID: <3386397.1679973630@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3386397.1679973630%40sss.pgh.pa.us>
Precedence: bulk

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