hashjoins vs. Bloom filters

Edit
ID 6818
Title hashjoins vs. Bloom filters
CI (CFBot) Needs rebase! Needs rebase since yesterday. Failing since 2 weeks.
Additional links previous successfully applied patch (outdated):
Stats (from CFBot) Unknown
Tags Performance
Created 2026-05-30 01:02:06
Last modified 2026-08-01 00:00:10 (1 week ago)
Latest email 2026-08-09 16:01:55 (yesterday)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
Target version
Authors Tomas Vondra (fuzzycz)
Reviewers Rui Zhao (zhaorui) Become reviewer
Committer
Links
Emails
hashjoins vs. Bloom filters (yet again)
First at 2026-05-30 00:55:43 by Tomas Vondra <tomas at vondra.me>
Latest at 2026-08-09 16:01:55 by Rui Zhao <zhaorui126 at gmail.com>
Latest attachment (0001-Keep-filter-expecting-paths-out-of-pathlist.patch) at 2026-08-09 16:01:55 from Rui Zhao <zhaorui126 at gmail.com>
    Attachment (0001-Keep-filter-expecting-paths-out-of-pathlist.patch) at 2026-08-09 16:01:55 from Rui Zhao <zhaorui126 at gmail.com> (Patch: No)
    Attachment (tpch-filters-warm.pdf) at 2026-08-06 15:10:27 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (v9-0004-Make-sure-Gather-nodes-don-t-have-filters.patch) at 2026-07-30 19:00:28 from Matheus Alcantara <matheusssilv97 at gmail.com> (Patch: No)
    Attachment (v8-0001-PoC-hashjoin-bloom-filter-pushdown.patch) at 2026-07-28 14:27:50 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: No)
    Attachment (v8-0020-Test-a-snowflake-join-with-multi-column-FK-join-c.patch) at 2026-07-28 13:32:17 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (q9.sql) at 2026-07-23 12:02:08 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (hashjoin-bloom-test.sql) at 2026-07-21 16:24:22 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (star-schema-bloom-repro.sql) at 2026-07-20 18:17:57 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: No)
    Attachment (v6-0009-Allow-filters-built-for-queries-with-LATERAL-join.patch) at 2026-07-20 13:53:05 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (hashjoin-bloom-repro.sql) at 2026-07-13 22:09:19 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (v5-0001-PoC-hashjoin-bloom-filter-pushdown.patch) at 2026-07-13 19:26:00 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: No)
    Attachment (v4-0001-PoC-hashjoin-bloom-filter-pushdown.patch) at 2026-07-02 20:31:18 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: No)
    Attachment (v3-0001-PoC-hashjoin-bloom-filter-pushdown.patch) at 2026-07-01 13:25:25 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (v2-0002-Using-Bloom-filters-for-parallel-hash-joins.patch) at 2026-06-02 15:22:36 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (0001-Allow-a-CustomScan-to-receive-a-pushed-down-hashjoin.patch.text) at 2026-05-31 15:03:47 from Andrew Dunstan <andrew at dunslane.net> (Patch: Yes)
    Attachment (hashjoin-bloom-filter.pdf) at 2026-05-30 00:55:43 from Tomas Vondra <tomas at vondra.me> (Patch: No)
History
When Who What
2026-08-10 03:09:01 Rui Zhao (zhaorui) Added zhaorui as reviewer
2026-08-09 16:32:33 CFbot Patch needs rebase
2026-08-01 00:00:10 CFbot Moved from CF PG20-1 to CF PG20-2
2026-07-23 12:32:42 CFbot Patch does not need rebase anymore
2026-07-21 16:41:27 CFbot Patch needs rebase
2026-05-30 01:02:07 Tomas Vondra (fuzzycz) Attached mail thread 5cd8c20c-14b5-4b0d-bedc-69bf714e87eb@vondra.me
2026-05-30 01:02:06 Tomas Vondra (fuzzycz) Created patch record
Edit