From: | Luc Vlaming <luc(at)swarm64(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Lazy JIT IR code generation to increase JIT speed with partitions |
Date: | 2020-12-28 08:44:26 |
Message-ID: | 244ee08c-5e26-45d1-8d10-d7b4d16b08ae@swarm64.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I would like to propose a small patch to the JIT machinery which makes
the IR code generation lazy. The reason for postponing the generation of
the IR code is that with partitions we get an explosion in the number of
JIT functions generated as many child tables are involved, each with
their own JITted functions, especially when e.g. partition-aware
joins/aggregates are enabled. However, only a fraction of those
functions is actually executed because the Parallel Append node
distributes the workers among the nodes. With the attached patch we get
a lazy generation which makes that this is no longer a problem.
For benchmarks I have in TPC-H and TPC-DS like queries with partitioning
by hash seen query runtimes increase by 20+ seconds even on the simpler
queries. Also I created a small benchmark to reproduce the case easily
(see attached sql file):
without patch, using 7 launched workers:
- without jit: ~220ms
- with jit: ~1880ms
without patch, using 50 launched workers:
- without jit: ~280ms
- with jit: ~3400ms
with patch, using 7 launched workers:
- without jit: ~220ms
- with jit: ~590ms
with patch, using 50 launched workers:
- without jit: ~280ms
- with jit: ~530ms
Thoughts?
With Regards,
Luc Vlaming
Swarm64
Attachment | Content-Type | Size |
---|---|---|
jit_partitions.sql | application/sql | 1.8 KB |
v1-0001-generate-JIT-IR-code-lazily.patch | text/x-patch | 4.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Masahiko Sawada | 2020-12-28 08:48:26 | Re: Parallel Full Hash Join |
Previous Message | Masahiko Sawada | 2020-12-28 08:43:26 | Re: Add table AM 'tid_visible' |