select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Functions and aggregates

shbf

C extension providing Bloom filter, shifting Bloom filter, and count-min sketch PostgreSQL data types and functions.

pgext.cloud · Source code · Documentation · Control file

Overview

Packageshifting_bloom_filter
Version1.0.0
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars6
Latest commit2018-10-28
Catalogue updated2026-08-30

Related extensions

See also

cms_topnCount-min sketch data type and aggregates for approximate frequency and top-N queries
probabilistic_counterA C data type and aggregates for approximate distinct counting using the Flajolet-Martin probabilistic counting algorithm.
alohadb_approxApproximate query processing: HLL, Count-Min Sketch, Top-K
pbloompgportable bloom filter, create, serialize, query across Go, Rust, Postgres
hlltype for storing hyperloglog data
pg_probProbabilistic data types for PostgreSQL - Monte Carlo simulation in SQL
pghllProvides HyperLogLog decode, cardinality, merge, and aggregate functions compatible with Java stream-lib counters.