Re: [HACKERS] Boom filters for hash joins (was: A design for amcheckheapam verification) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] Boom filters for hash joins (was: A design for amcheckheapam verification)
Date
Msg-id CA+TgmoZGVH8CWz2PT8ndVmn8-6no3Pa=W7ujny-j=2v=rV49LQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Boom filters for hash joins (was: A design for amcheckheapam verification)  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
On Tue, Sep 19, 2017 at 4:25 PM, Tomas Vondra
<tomas.vondra@2ndquadrant.com> wrote:
> I haven't thought about it from that point of view. Can you elaborate
> why that would be the case? Sorry if this was explained earlier in this
> thread (I don't see it in the history, though).
>
> I can't quite remember why I haven't pursued the patch in 2015, but it
> was probably clear it wouldn't get in in the last CF, and I never got
> back to it.

IIRC, it was a clear loser performance-wise in the case where the
Bloom filter didn't end up helping, and we didn't have a way to avoid
doing it when it didn't help.  That may or may not be why you didn't
pursue it, but I'm fairly sure it was my motivation for being
unexcited about the whole idea.  I think if we can solve that problem
somehow, we have a winner.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [HACKERS] CREATE COLLATION does not sanitize ICU's BCP 47language tags. Should it?
Next
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] Commits don't block for synchronous replication