| From: | ywgrit <yw987194828(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | andres(at)anarazel(dot)de |
| Subject: | Some questions about JIT optimization |
| Date: | 2026-01-26 03:11:22 |
| Message-ID: | CAPt2h2aWf7QPg81+Wq78Z-88ybHvSKefoSXMidiFpgMbJZJvMg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Presentation:
https://anarazel.de/talks/2018-06-01-pgcon-state-of-jit/state-of-jit.pdf.
It mentions “Future things to JIT: Aggregate & Hashjoin hash computation.”
I'm not entirely clear where this optimization specifically manifests. I
tested tpch-100G. Performance improvements for q5/11 were minimal because
expression execution constitutes a very small proportion in these two
queries, leaving little room for JIT optimization. Both queries share
common hot functions: `ExecParallelScanHashBucket` and
`ExecParallelHashJoin`. However, I don't see how these hot functions could
be optimized via JIT. I'd appreciate hearing everyone's thoughts.
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ocean_li_996 | 2026-01-26 03:18:27 | Re:Fix logical decoding not track transaction during SNAPBUILD_BUILDING_SNAPSHOT |
| Previous Message | Zhijie Hou (Fujitsu) | 2026-01-26 03:03:36 | RE: Newly created replication slot may be invalidated by checkpoint |