pgsql: Add Bloom filter implementation. - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: Add Bloom filter implementation.
Date
Msg-id E1f2Ruu-00015M-1A@gemulon.postgresql.org
Whole thread Raw
Responses Re: pgsql: Add Bloom filter implementation.  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-committers
Add Bloom filter implementation.

A Bloom filter is a space-efficient, probabilistic data structure that
can be used to test set membership.  Callers will sometimes incur false
positives, but never false negatives.  The rate of false positives is a
function of the total number of elements and the amount of memory
available for the Bloom filter.

Two classic applications of Bloom filters are cache filtering, and data
synchronization testing.  Any user of Bloom filters must accept the
possibility of false positives as a cost worth paying for the benefit in
space efficiency.

This commit adds a test harness extension module, test_bloomfilter.  It
can be used to get a sense of how the Bloom filter implementation
performs under varying conditions.

This is infrastructure for the upcoming "heapallindexed" amcheck patch,
which verifies the consistency of a heap relation against one of its
indexes.

Author: Peter Geoghegan
Reviewed-By: Andrey Borodin, Michael Paquier, Thomas Munro, Andres Freund
Discussion: https://postgr.es/m/CAH2-Wzm5VmG7cu1N-H=nnS57wZThoSDQU+F5dewx3o84M+jY=g@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/51bc271790eb234a1ba4d14d3e6530f70de92ab5

Modified Files
--------------
src/backend/lib/Makefile                           |   4 +-
src/backend/lib/README                             |   2 +
src/backend/lib/bloomfilter.c                      | 305 +++++++++++++++++++++
src/include/lib/bloomfilter.h                      |  27 ++
src/test/modules/Makefile                          |   1 +
src/test/modules/test_bloomfilter/.gitignore       |   4 +
src/test/modules/test_bloomfilter/Makefile         |  21 ++
src/test/modules/test_bloomfilter/README           |  68 +++++
.../test_bloomfilter/expected/test_bloomfilter.out |  22 ++
.../test_bloomfilter/sql/test_bloomfilter.sql      |  19 ++
.../test_bloomfilter/test_bloomfilter--1.0.sql     |  11 +
.../modules/test_bloomfilter/test_bloomfilter.c    | 138 ++++++++++
.../test_bloomfilter/test_bloomfilter.control      |   4 +
src/tools/pgindent/typedefs.list                   |   1 +
14 files changed, 625 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Andrew Dunstan
Date:
Subject: pgsql: Small cleanups in fast default code.
Next
From: Andres Freund
Date:
Subject: pgsql: Add amcheck verification of heap relations belonging to btreein