public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jelte Fennema-Nio <[email protected]>
To: Pierre Ducroquet <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: Tomas Vondra <[email protected]>
Cc: Andres Freund <[email protected]>
Cc: Greg Sabino Mullane <[email protected]>
Cc: Adrien Nayrat <[email protected]>
Cc: Christoph Berg <[email protected]>
Cc: Euler Taveira <[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, 24 Mar 2026 15:32:36 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAGECzQSc_AbvhKU=BOc6tAAqU5Bsu9EFOirDR4_O=fio1_XYSA@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<CAKAnmmKZ_Yg2CEt9Wa-QZWZ7UePfWB9qnk=qDiXZcqNS5MdrGQ@mail.gmail.com>
<zavalseit5sbjf5gx352ioobtlqtycrs5yczynwzckacdwqh23@mjuvibp2z44t>
<CAGECzQQdO5OGnxe7bpN1usp+ku+tLBW=SwgLbrULVcFAjH5_yA@mail.gmail.com>
<[email protected]>
<[email protected]>
<gPNlX1QTDtJW2Cyi3fA2OGFvoIybkehUYKCHCe2r3Ujm_0y9V1T13CPI2MA6RyPhLi8zNwNczq1DNrbh1l47eVn6tOwz-qzG2yXw_XtptTQ=@pinaraf.info>
<CAGECzQSc_AbvhKU=BOc6tAAqU5Bsu9EFOirDR4_O=fio1_XYSA@mail.gmail.com>
On Mon Mar 23, 2026 at 9:50 AM CET, Jelte Fennema-Nio wrote:
> I think Andres' reply also applied to that suggestion. Partitioning
> really messes up jit for expressions too. I was able to pretty easily
> create some bad cases even with jit_tuple_deforming set to off. A
> query involving many partitions, but with relatively few rows per
> partition, jit became ~54x slower when using -O2 (743ms vs 40318ms).
> And even with -O0, jit is still ~3x slower (221ms vs 711ms). Full
> script and results attached.
Resending the above with a compressed attachment, because it was too
large for the mailing list.
Attachments:
[application/sql] jit_benchmark.sql (3.9K, 2-jit_benchmark.sql)
download
[application/gzip] results.out.gz (34.8K, 3-results.out.gz)
download
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], [email protected], [email protected]
Subject: Re: Change default of jit to off
In-Reply-To: <[email protected]>
* 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