public inbox for [email protected]  

help / color / mirror / Atom feed

From: Andres Freund <[email protected]>
To: Greg Sabino Mullane <[email protected]>
Cc: Adrien Nayrat <[email protected]>
Cc: Christoph Berg <[email protected]>
Cc: Euler Taveira <[email protected]>
Cc: Pierre Ducroquet <[email protected]>
Cc: Jelte Fennema <[email protected]>
Cc: Álvaro Herrera <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Cc: Andreas Karlsson <[email protected]>
Cc: Anthonin Bonnefoy <[email protected]>
Cc: pgsql-hackers <[email protected]>
Cc: Michael Banck <[email protected]>
Subject: Re: Change default of jit to off
Date: Tue, 3 Feb 2026 12:13:46 -0500
Message-ID: <zavalseit5sbjf5gx352ioobtlqtycrs5yczynwzckacdwqh23@mjuvibp2z44t> (raw)
In-Reply-To: <CAKAnmmKZ_Yg2CEt9Wa-QZWZ7UePfWB9qnk=qDiXZcqNS5MdrGQ@mail.gmail.com>
References: <[email protected]>
	<[email protected]>
	<CAKAnmmKZ_Yg2CEt9Wa-QZWZ7UePfWB9qnk=qDiXZcqNS5MdrGQ@mail.gmail.com>

Hi,

+1 for disabling it by default. Particularly with partitioning having become
much more common since jit compilation was added, combined with LLVM getting a
lot slower over time, that's unfortunately the right call until some
substantial improvements are made.


On 2026-02-03 12:03:51 -0500, Greg Sabino Mullane wrote:
> Given that so many places are already disabling it, +1 to disabling by
> default - unless someone can come up with a costing tweak so it doesn't
> fire when it shouldn't - but right now that seems something only humans can
> truly determine.

I think it needs more than a costing tweak. The most important thing would be
to get caching (there's progress, albeit very slow one, towards that), so the
downside of JIT compilation doesn't hit you over and over.

Relatedly, we often end up with the almost-same expression being jit compiled
many times in partitioned workloads, which is one of the main sources of high
jit compilation times.

We also need to just increase the benefit of JIT compilation further, the code
we generate leaves a *lot* on the table, particularly for more complicated
expressions, where the gain also can be the biggest.

Greetings,

Andres Freund

view thread (16+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Change default of jit to off
  In-Reply-To: <zavalseit5sbjf5gx352ioobtlqtycrs5yczynwzckacdwqh23@mjuvibp2z44t>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox