Content-Type: multipart/mixed;
 boundary=85ecd9020c50bbd978d4db3ea1bb8acf175ff4ac27671ecb1be77a0a8088
Date: Fri, 30 Jan 2026 12:28:04 +0100
Message-Id: <DG1VZJEX1AQH.2EH4OKGRUDB71@jeltef.nl>
From: "Jelte Fennema-Nio" <postgres@jeltef.nl>
Cc: =?utf-8?q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>, "PostgreSQL
 Hackers" <pgsql-hackers@lists.postgresql.org>, "Andreas Karlsson"
 <andreas@proxel.se>, "Anthonin Bonnefoy" <anthonin.bonnefoy@datadoghq.com>,
 "PostgreSQL Hackers" <pgsql-hackers@postgresql.org>, "Michael Banck"
 <mbanck@gmx.net>, "Christoph Berg" <myon@debian.org>
Subject: Change default of jit to off
To: "Pierre Ducroquet" <p.psql@pinaraf.info>
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/DG1VZJEX1AQH.2EH4OKGRUDB71%40jeltef.nl>
Precedence: bulk

--85ecd9020c50bbd978d4db3ea1bb8acf175ff4ac27671ecb1be77a0a8088
Content-Type: multipart/alternative;
 boundary=40e422306fc62c664dba7b4a3f4d1e01738dbfdc4f12de0f4ea1b8f7fb65

--40e422306fc62c664dba7b4a3f4d1e01738dbfdc4f12de0f4ea1b8f7fb65
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Content-Type: text/plain; charset=UTF-8; format=Flowed

(forked off from "Add missing JIT inline pass for llvm>=3D17")

On Mon, 19 Jan 2026 at 11:53, Pierre Ducroquet <p.psql@pinaraf.info> wrote:
>
> On Friday, January 16, 2026 10:29:59=E2=80=AFAM Central European Standard=
 Time Michael
> Banck wrote:
> > Hi,
> >
> > On Thu, Jan 15, 2026 at 12:26:23PM +0100, =C3=81lvaro Herrera wrote:
> > > On 2026-Jan-15, Andreas Karlsson wrote:
> > > > Great find! Sadly shows how little people actually use JIT.
> > >
> > > I disagree.  Given that JIT is enabled by default, I think lots of
> > > people use it.
> >
> > Well, not sure about that - all of the three major hyperscalers disable
> > JIT in their managed Postgres offerings (or at least used to when I las=
t
> > checked), and those are a major chunk of usage these days. Also, both
> > the RPM and (since recently) the Debian/Ubuntu community packages have
> > factored out the LLVM/jit part into their own packages and AFAIK they d=
o
> > not get installed by default.
> >
> > So while the GUC is on by default, a lot of users might not use JIT
> > these days and not know either way.
> >
> > > What they don't do, is realize that things are slower
> > > than they could be -- much less try to figure out why.
> >
> > Right.
>
> People have also seen blog articles saying =C2=ABJIT is bad, switch it of=
f=C2=BB that are
> right if you are in the wrong use cases for JIT. Which, to be fair, is no=
t
> easy to figure out.

+1 on disabling jit by default. At the FOSDEM Postgres developer meeting
consensus was hugely in favor of changing the default. So attached is a
trivial patch that does this.

--40e422306fc62c664dba7b4a3f4d1e01738dbfdc4f12de0f4ea1b8f7fb65--

--85ecd9020c50bbd978d4db3ea1bb8acf175ff4ac27671ecb1be77a0a8088
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename=v1-0001-Change-default-of-jit-to-off.patch
Content-Type: text/x-patch; charset=utf-8;
 name=v1-0001-Change-default-of-jit-to-off.patch

RnJvbSA0ZTEwZjU1MmU4ODA4NzY1MGJlYzk3ZWUxNDFiOGRkNzBlNzRkNDA1IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBKZWx0ZSBGZW5uZW1hLU5pbyA8cG9zdGdyZXNAamVsdGVmLm5s
PgpEYXRlOiBGcmksIDMwIEphbiAyMDI2IDExOjU4OjUwICswMTAwClN1YmplY3Q6IFtQQVRDSCB2
MV0gQ2hhbmdlIGRlZmF1bHQgb2Ygaml0IHRvIG9mZgoKV2hpbGUgaml0IGNhbiBzcGVlZCB1cCBz
bG93IGFuYWx5dGljYWwgcXVlcmllcywgaXQgY2FuIGFsc28gY2F1c2UgaHVnZQpzbG93ZG93bnMg
b24gb3RoZXJ3aXNlIHZlcnkgZmFzdCBxdWVyaWVzLiBUaGlzIGNhbiBiZSBlc3BlY2lhbGx5IHBh
aW5mdWwKd2hlbiBkdWUgdG8gc29tZSB1bnJlbGF0ZWQgY2hhbmdlcyAoZS5nLiBhIGZldyBhZGRp
dGlvbmFsIElOU0VSVHMgaW50byBhCnRhbGJlKSB0aGUgcGxhbiBpcyBjaGFuZ2VkIHRvIHVzZSBq
aXQgYW5kIHRoZW4gcmVzdWx0cyBpbiBhIGh1Z2UKcGVyZm9ybWFuY2UgY2xpZmYuIFRoYXQncyB3
aHkgdGhlIGRlZmF1bHQgaXMgYWxyZWFkeSBvZmYgb24gYWxsCmh5cGVyc2NhbGVycy4gVGhpcyBj
aGFuZ2VzIG91ciBkZWZhdWx0IHRvIGFsaWduIHdpdGggdGhhdCB0aGF0LgotLS0KIGRvYy9zcmMv
c2dtbC9jb25maWcuc2dtbCAgICAgICAgICAgICAgICAgICAgICB8IDMgKystCiBzcmMvYmFja2Vu
ZC9qaXQvaml0LmMgICAgICAgICAgICAgICAgICAgICAgICAgfCAyICstCiBzcmMvYmFja2VuZC91
dGlscy9taXNjL2d1Y19wYXJhbWV0ZXJzLmRhdCAgICAgfCAyICstCiBzcmMvYmFja2VuZC91dGls
cy9taXNjL3Bvc3RncmVzcWwuY29uZi5zYW1wbGUgfCAyICstCiA0IGZpbGVzIGNoYW5nZWQsIDUg
aW5zZXJ0aW9ucygrKSwgNCBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwv
Y29uZmlnLnNnbWwgYi9kb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwKaW5kZXggNTU2MGI5NWVlNjAu
LmU3OGFkMmQzZTI1IDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwKKysrIGIv
ZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sCkBAIC02NTEwLDcgKzY1MTAsOCBAQCBTRUxFQ1QgKiBG
Uk9NIHBhcmVudCBXSEVSRSBrZXkgPSAyNDAwOwogICAgICAgICBEZXRlcm1pbmVzIHdoZXRoZXIg
PGFjcm9ueW0+SklUPC9hY3JvbnltPiBjb21waWxhdGlvbiBtYXkgYmUgdXNlZCBieQogICAgICAg
ICA8cHJvZHVjdG5hbWU+UG9zdGdyZVNRTDwvcHJvZHVjdG5hbWU+LCBpZiBhdmFpbGFibGUgKHNl
ZSA8eHJlZgogICAgICAgICBsaW5rZW5kPSJqaXQiLz4pLgotICAgICAgICBUaGUgZGVmYXVsdCBp
cyA8bGl0ZXJhbD5vbjwvbGl0ZXJhbD4uCisgICAgICAgIFRoZSBkZWZhdWx0IGlzIDxsaXRlcmFs
Pm9mZjwvbGl0ZXJhbD4gKGJlZm9yZQorICAgICAgICA8cHJvZHVjdG5hbWU+UG9zdGdyZVNRTDwv
cHJvZHVjdG5hbWU+IDE5IHRoZSBkZWZhdWx0IHdhcyA8bGl0ZXJhbD5vbjwvbGl0ZXJhbD4pLgog
ICAgICAgIDwvcGFyYT4KICAgICAgIDwvbGlzdGl0ZW0+CiAgICAgIDwvdmFybGlzdGVudHJ5Pgpk
aWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvaml0L2ppdC5jIGIvc3JjL2JhY2tlbmQvaml0L2ppdC5j
CmluZGV4IGU5MmJlMzY5MzJiLi4xYzYyNjEwOTZkMCAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQv
aml0L2ppdC5jCisrKyBiL3NyYy9iYWNrZW5kL2ppdC9qaXQuYwpAQCAtMjksNyArMjksNyBAQAog
I2luY2x1ZGUgInV0aWxzL2ZtZ3Jwcm90b3MuaCIKIAogLyogR1VDcyAqLwotYm9vbAkJaml0X2Vu
YWJsZWQgPSB0cnVlOworYm9vbAkJaml0X2VuYWJsZWQgPSBmYWxzZTsKIGNoYXIJICAgKmppdF9w
cm92aWRlciA9IE5VTEw7CiBib29sCQlqaXRfZGVidWdnaW5nX3N1cHBvcnQgPSBmYWxzZTsKIGJv
b2wJCWppdF9kdW1wX2JpdGNvZGUgPSBmYWxzZTsKZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3V0
aWxzL21pc2MvZ3VjX3BhcmFtZXRlcnMuZGF0IGIvc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9ndWNf
cGFyYW1ldGVycy5kYXQKaW5kZXggZjAyNjBlNmU0MTIuLmExNjRkOTJkNDM5IDEwMDY0NAotLS0g
YS9zcmMvYmFja2VuZC91dGlscy9taXNjL2d1Y19wYXJhbWV0ZXJzLmRhdAorKysgYi9zcmMvYmFj
a2VuZC91dGlscy9taXNjL2d1Y19wYXJhbWV0ZXJzLmRhdApAQCAtMTM1Niw3ICsxMzU2LDcgQEAK
ICAgc2hvcnRfZGVzYyA9PiAnQWxsb3cgSklUIGNvbXBpbGF0aW9uLicsCiAgIGZsYWdzID0+ICdH
VUNfRVhQTEFJTicsCiAgIHZhcmlhYmxlID0+ICdqaXRfZW5hYmxlZCcsCi0gIGJvb3RfdmFsID0+
ICd0cnVlJywKKyAgYm9vdF92YWwgPT4gJ2ZhbHNlJywKIH0sCiAKIHsgbmFtZSA9PiAnaml0X2Fi
b3ZlX2Nvc3QnLCB0eXBlID0+ICdyZWFsJywgY29udGV4dCA9PiAnUEdDX1VTRVJTRVQnLCBncm91
cCA9PiAnUVVFUllfVFVOSU5HX0NPU1QnLApkaWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvdXRpbHMv
bWlzYy9wb3N0Z3Jlc3FsLmNvbmYuc2FtcGxlIGIvc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9wb3N0
Z3Jlc3FsLmNvbmYuc2FtcGxlCmluZGV4IGM0ZjkyZmNkYWM4Li5hMjc3Y2Y1NjBlYSAxMDA2NDQK
LS0tIGEvc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9wb3N0Z3Jlc3FsLmNvbmYuc2FtcGxlCisrKyBi
L3NyYy9iYWNrZW5kL3V0aWxzL21pc2MvcG9zdGdyZXNxbC5jb25mLnNhbXBsZQpAQCAtNDY5LDcg
KzQ2OSw3IEBACiAjY29uc3RyYWludF9leGNsdXNpb24gPSBwYXJ0aXRpb24gICAgICAgIyBvbiwg
b2ZmLCBvciBwYXJ0aXRpb24KICNjdXJzb3JfdHVwbGVfZnJhY3Rpb24gPSAwLjEgICAgICAgICAg
ICAjIHJhbmdlIDAuMC0xLjAKICNmcm9tX2NvbGxhcHNlX2xpbWl0ID0gOAotI2ppdCA9IG9uICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICMgYWxsb3cgSklUIGNvbXBpbGF0aW9uCisjaml0
ID0gb2ZmICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIyBhbGxvdyBKSVQgY29tcGlsYXRp
b24KICNqb2luX2NvbGxhcHNlX2xpbWl0ID0gOCAgICAgICAgICAgICAgICAjIDEgZGlzYWJsZXMg
Y29sbGFwc2luZyBvZiBleHBsaWNpdAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICMgSk9JTiBjbGF1c2VzCiAjcGxhbl9jYWNoZV9tb2RlID0gYXV0byAgICAgICAgICAg
ICAgICAgIyBhdXRvLCBmb3JjZV9nZW5lcmljX3BsYW4gb3IKCmJhc2UtY29tbWl0OiAxZWIwOWVk
NjNhOGQ4MDYzZGM2YmI3NWM4ZjMxZWM1NjRiZjM1MjUwCi0tIAoyLjUyLjAKCg==
--85ecd9020c50bbd978d4db3ea1bb8acf175ff4ac27671ecb1be77a0a8088--