Extensions / Functions and aggregates
Count-min sketch data type and aggregates for approximate frequency and top-N queries
pgext.cloud · Source code · Documentation · Control file
| Package | cms_topn |
|---|---|
| Version | 1.0.0 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Stars | 7 |
| Latest commit | 2015-12-10 |
| Catalogue updated | 2026-08-30 |
| alohadb_approx | Approximate query processing: HLL, Count-Min Sketch, Top-K |
| shbf | C extension providing Bloom filter, shifting Bloom filter, and count-min sketch PostgreSQL data types and functions. |
| probabilistic_counter | A C data type and aggregates for approximate distinct counting using the Flajolet-Martin probabilistic counting algorithm. |
| hll | type for storing hyperloglog data |
| pbloompg | portable bloom filter, create, serialize, query across Go, Rust, Postgres |
| pg_prob | Probabilistic data types for PostgreSQL - Monte Carlo simulation in SQL |
| pghll | Provides HyperLogLog decode, cardinality, merge, and aggregate functions compatible with Java stream-lib counters. |