Extensions / Functions and aggregates
Provides HyperLogLog decode, cardinality, merge, and aggregate functions compatible with Java stream-lib counters.
pgext.cloud · Source code · License text · Control file
| Package | pghll |
|---|---|
| Version | 1.0 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Unmaintained |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 2 |
| Latest commit | 2013-07-16 |
| Catalogue updated | 2026-08-30 |
| hll | type for storing hyperloglog data |
| hyperloglog_counter | Aggregation functions and data type for distinct estimation based on HyperLogLog. |
| argm | argmax, argmin, and anyold aggregate functions |
| pg_prob | Probabilistic data types for PostgreSQL - Monte Carlo simulation in SQL |
| median | Median aggregate function for input sets |
| frkn_avg | C aggregate extension providing my_avg for bigint and floating-point inputs. |
| tdigest | Provides tdigest aggregate function. |
| count_distinct | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate |
| first_last | Aggregate functions to return first or last "n" elements in a group |
| trimmed_aggregates | C aggregate functions that discard configurable low/high outliers before computing averages, variances, and standard deviations. |