quantile
Quantile aggregation function
Repository
tvondra/quantile
https://github.com/tvondra/quantile
Source
quantile-1.1.8.tar.gz
quantile-1.1.8.tar.gz
Overview
| Package | Version | Category | License | Language |
|---|---|---|---|---|
quantile | 1.1.8 | FUNC | BSD 2-Clause | C |
| ID | Extension | Bin | Lib | Load | Create | Trust | Reloc | Schema |
|---|---|---|---|---|---|---|---|---|
| 4610 | quantile | No | Yes | No | Yes | No | No | - |
| Related | lower_quantile topn ddsketch omnisketch count_distinct first_last_agg aggs_for_arrays |
|---|
Version
| Type | Repo | Version | PG Ver | Package | Deps |
|---|---|---|---|---|---|
| EXT | PIGSTY | 1.1.8 | 1817161514 | quantile | - |
| RPM | PIGSTY | 1.1.8 | 1817161514 | quantile_$v | - |
| DEB | PIGSTY | 1.1.8 | 1817161514 | postgresql-$v-quantile | - |
Build
You can build the RPM / DEB packages for quantile using pig build:
pig build pkg quantile # build RPM / DEB packages
Install
You can install quantile directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:
pig repo add pgsql -u # Add repo and update cache
Install the extension using pig or apt/yum/dnf:
pig install quantile; # Install for current active PG version
pig ext install -y quantile -v 18 # PG 18
pig ext install -y quantile -v 17 # PG 17
pig ext install -y quantile -v 16 # PG 16
pig ext install -y quantile -v 15 # PG 15
pig ext install -y quantile -v 14 # PG 14
dnf install -y quantile_18 # PG 18
dnf install -y quantile_17 # PG 17
dnf install -y quantile_16 # PG 16
dnf install -y quantile_15 # PG 15
dnf install -y quantile_14 # PG 14
apt install -y postgresql-18-quantile # PG 18
apt install -y postgresql-17-quantile # PG 17
apt install -y postgresql-16-quantile # PG 16
apt install -y postgresql-15-quantile # PG 15
apt install -y postgresql-14-quantile # PG 14
Create Extension:
CREATE EXTENSION quantile;
Usage
Provides aggregate functions to compute quantiles. Overloaded for int, bigint, double precision, and numeric.
CREATE EXTENSION quantile;
Functions
| Function | Description |
|---|---|
quantile(value, quantile float) | Compute a single quantile (0 to 1) |
quantile(value, quantiles float[]) | Compute multiple quantiles at once, returns array |
Examples
-- Compute the median (0.5 quantile)
SELECT quantile(i, 0.5) FROM generate_series(1, 1000) s(i);
-- 500
-- Compute the 95th percentile
SELECT quantile(i, 0.95) FROM generate_series(1, 1000) s(i);
-- Compute all quartiles at once (more efficient than separate calls)
SELECT quantile(i, ARRAY[0.25, 0.5, 0.75])
FROM generate_series(1, 1000) s(i);
-- {250, 500, 750}
Note: Since PostgreSQL 9.4, built-in percentile_cont and percentile_disc functions are available. Consider using those first and only use this extension if it provides measurably better performance for your workload.
Feedback
Was this page helpful?
Thanks for the feedback! Please let us know how we can improve.
Sorry to hear that. Please let us know how we can improve.