| From: | "Jelte Fennema-Nio" <postgres(at)jeltef(dot)nl> |
|---|---|
| To: | "Pierre Ducroquet" <p(dot)psql(at)pinaraf(dot)info> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Tomas Vondra" <tomas(at)vondra(dot)me>, "Andres Freund" <andres(at)anarazel(dot)de>, "Greg Sabino Mullane" <htamfids(at)gmail(dot)com>, "Adrien Nayrat" <adrien(dot)nayrat(at)anayrat(dot)info>, "Christoph Berg" <myon(at)debian(dot)org>, "Euler Taveira" <euler(at)eulerto(dot)com>, Álvaro Herrera <alvherre(at)kurilemu(dot)de>, "PostgreSQL Hackers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "Andreas Karlsson" <andreas(at)proxel(dot)se>, "Anthonin Bonnefoy" <anthonin(dot)bonnefoy(at)datadoghq(dot)com>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>, "Michael Banck" <mbanck(at)gmx(dot)net> |
| Subject: | Re: Change default of jit to off |
| Date: | 2026-03-24 14:32:36 |
| Message-ID: | DHB33P41EIY3.MMPHLKV4OAHP@jeltef.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
| Attachment | Content-Type | Size |
|---|---|---|
| jit_benchmark.sql | application/sql | 3.9 KB |
| results.out.gz | application/gzip | 34.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nathan Bossart | 2026-03-24 14:34:23 | Re: BUG: test_bloomfilter error message reports wrong variable and wrong format specifier |
| Previous Message | Jelte Fennema-Nio | 2026-03-24 14:29:47 | Re: Add GoAway protocol message for graceful but fast server shutdown/switchover |