Bloom filters: the niche trick behind a 16× faster API

(incident.io)

2 points | by crcastle 8 hours ago ago

1 comments

  • anitil 7 hours ago

    I was wondering how they'd convert (arbitrary?) jsonb into hashable values, but pulling out the json path and hashing that makes a lot of sense. This is definitely going into my list of tricks for one day if I ever need it. And I somehow hadn't heard about the bitstring type in postgres before [0]!

    [0] https://www.postgresql.org/docs/current/datatype-bit.html