Extensions / Functions and aggregates
type for top-n JSONB
pgext.cloud · Source code · License text · Control file
| Package | topn |
|---|---|
| Version | 2.7.1 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PGDG |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Stars | 249 |
| Latest commit | 2026-07-24 |
| Latest release | 2026-08-20 |
| Catalogue updated | 2026-08-30 |
| count_distinct | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate |
| hll | type for storing hyperloglog data |
| omnisketch | data structure for on-line agg of data into approximate sketch |
| datasketches | Approximate analytics sketches and aggregates for PostgreSQL |
| ddsketch | Provides ddsketch aggregate function |
| tdigest | Provides tdigest aggregate function. |
| quantile | Quantile aggregation function |
| lower_quantile | Lower quantile aggregate function |
| weighted_statistics | High-performance weighted statistics functions for sparse data |