select open change scope Open full search

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

Extensions / Functions and aggregates

quantile

Quantile aggregation function

pgext.cloud · Source code · License text · Control file · PGXN

Overview

Packagequantile
Version1.1.8
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
Stars39
Latest commit2025-08-04
Latest release2024-12-22
Catalogue updated2026-08-30

Related extensions

See also

ddsketchProvides ddsketch aggregate function
tdigestProvides tdigest aggregate function.
weighted_statisticsHigh-performance weighted statistics functions for sparse data
lower_quantileLower quantile aggregate function
topntype for top-n JSONB
count_distinctAn alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
omnisketchdata structure for on-line agg of data into approximate sketch
datasketchesApproximate analytics sketches and aggregates for PostgreSQL
hlltype for storing hyperloglog data