Extensions
quantile

quantile

quantile : Quantile aggregation function

Overview

ID Extension Package Version Category License Language
4610
quantile
quantile
 1.1.8
FUNC
BSD 2-Clause
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
See Also
lower_quantile
topn
ddsketch
omnisketch
count_distinct
first_last_agg
aggs_for_arrays

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PIGSTY
 1.1.8
18
17
16
15
14
13
 quantile -
RPM
PIGSTY
 1.1.8
18
17
16
15
14
13
 quantile_$v* -
DEB
PIGSTY
 1.1.8
18
17
16
15
14
13
 postgresql-$v-quantile -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
el8.aarch64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
el9.x86_64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
el9.aarch64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
el10.x86_64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
el10.aarch64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
d12.x86_64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
d12.aarch64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
d13.x86_64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
d13.aarch64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
u22.x86_64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
u22.aarch64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
u24.x86_64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
u24.aarch64
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
Package Version OS ORG SIZE File URL
quantile_18 1.1.8 el8.x86_64 pigsty 18.5 KiB quantile_18-1.1.8-1PIGSTY.el8.x86_64.rpm
quantile_18 1.1.8 el8.aarch64 pigsty 17.8 KiB quantile_18-1.1.8-1PIGSTY.el8.aarch64.rpm
quantile_18 1.1.8 el9.x86_64 pigsty 18.1 KiB quantile_18-1.1.8-1PIGSTY.el9.x86_64.rpm
quantile_18 1.1.8 el9.aarch64 pigsty 17.5 KiB quantile_18-1.1.8-1PIGSTY.el9.aarch64.rpm
quantile_18 1.1.8 el10.x86_64 pigsty 18.1 KiB quantile_18-1.1.8-1PIGSTY.el10.x86_64.rpm
quantile_18 1.1.8 el10.aarch64 pigsty 17.8 KiB quantile_18-1.1.8-1PIGSTY.el10.aarch64.rpm
postgresql-18-quantile 1.1.8 d12.x86_64 pigsty 21.5 KiB postgresql-18-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb
postgresql-18-quantile 1.1.8 d12.aarch64 pigsty 21.2 KiB postgresql-18-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb
postgresql-18-quantile 1.1.8 d13.x86_64 pigsty 21.5 KiB postgresql-18-quantile_1.1.8-1PIGSTY~trixie_amd64.deb
postgresql-18-quantile 1.1.8 d13.aarch64 pigsty 21.3 KiB postgresql-18-quantile_1.1.8-1PIGSTY~trixie_arm64.deb
postgresql-18-quantile 1.1.8 u22.x86_64 pigsty 22.7 KiB postgresql-18-quantile_1.1.8-1PIGSTY~jammy_amd64.deb
postgresql-18-quantile 1.1.8 u22.aarch64 pigsty 21.8 KiB postgresql-18-quantile_1.1.8-1PIGSTY~jammy_arm64.deb
postgresql-18-quantile 1.1.8 u24.x86_64 pigsty 22.6 KiB postgresql-18-quantile_1.1.8-1PIGSTY~noble_amd64.deb
postgresql-18-quantile 1.1.8 u24.aarch64 pigsty 22.2 KiB postgresql-18-quantile_1.1.8-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
quantile_17 1.1.8 el8.x86_64 pigsty 18.5 KiB quantile_17-1.1.8-1PIGSTY.el8.x86_64.rpm
quantile_17 1.1.8 el8.aarch64 pigsty 17.8 KiB quantile_17-1.1.8-1PIGSTY.el8.aarch64.rpm
quantile_17 1.1.8 el9.x86_64 pigsty 18.2 KiB quantile_17-1.1.8-1PIGSTY.el9.x86_64.rpm
quantile_17 1.1.8 el9.aarch64 pigsty 17.5 KiB quantile_17-1.1.8-1PIGSTY.el9.aarch64.rpm
quantile_17 1.1.8 el10.x86_64 pigsty 18.1 KiB quantile_17-1.1.8-1PIGSTY.el10.x86_64.rpm
quantile_17 1.1.8 el10.aarch64 pigsty 17.8 KiB quantile_17-1.1.8-1PIGSTY.el10.aarch64.rpm
postgresql-17-quantile 1.1.8 d12.x86_64 pigsty 21.2 KiB postgresql-17-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb
postgresql-17-quantile 1.1.8 d12.aarch64 pigsty 20.9 KiB postgresql-17-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb
postgresql-17-quantile 1.1.8 d13.x86_64 pigsty 21.2 KiB postgresql-17-quantile_1.1.8-1PIGSTY~trixie_amd64.deb
postgresql-17-quantile 1.1.8 d13.aarch64 pigsty 21.0 KiB postgresql-17-quantile_1.1.8-1PIGSTY~trixie_arm64.deb
postgresql-17-quantile 1.1.8 u22.x86_64 pigsty 23.9 KiB postgresql-17-quantile_1.1.8-1PIGSTY~jammy_amd64.deb
postgresql-17-quantile 1.1.8 u22.aarch64 pigsty 23.0 KiB postgresql-17-quantile_1.1.8-1PIGSTY~jammy_arm64.deb
postgresql-17-quantile 1.1.8 u24.x86_64 pigsty 22.3 KiB postgresql-17-quantile_1.1.8-1PIGSTY~noble_amd64.deb
postgresql-17-quantile 1.1.8 u24.aarch64 pigsty 22.0 KiB postgresql-17-quantile_1.1.8-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
quantile_16 1.1.8 el8.x86_64 pigsty 18.5 KiB quantile_16-1.1.8-1PIGSTY.el8.x86_64.rpm
quantile_16 1.1.8 el8.aarch64 pigsty 17.8 KiB quantile_16-1.1.8-1PIGSTY.el8.aarch64.rpm
quantile_16 1.1.8 el9.x86_64 pigsty 18.2 KiB quantile_16-1.1.8-1PIGSTY.el9.x86_64.rpm
quantile_16 1.1.8 el9.aarch64 pigsty 17.5 KiB quantile_16-1.1.8-1PIGSTY.el9.aarch64.rpm
quantile_16 1.1.8 el10.x86_64 pigsty 18.1 KiB quantile_16-1.1.8-1PIGSTY.el10.x86_64.rpm
quantile_16 1.1.8 el10.aarch64 pigsty 17.8 KiB quantile_16-1.1.8-1PIGSTY.el10.aarch64.rpm
postgresql-16-quantile 1.1.8 d12.x86_64 pigsty 21.2 KiB postgresql-16-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb
postgresql-16-quantile 1.1.8 d12.aarch64 pigsty 20.9 KiB postgresql-16-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb
postgresql-16-quantile 1.1.8 d13.x86_64 pigsty 21.2 KiB postgresql-16-quantile_1.1.8-1PIGSTY~trixie_amd64.deb
postgresql-16-quantile 1.1.8 d13.aarch64 pigsty 21.0 KiB postgresql-16-quantile_1.1.8-1PIGSTY~trixie_arm64.deb
postgresql-16-quantile 1.1.8 u22.x86_64 pigsty 23.8 KiB postgresql-16-quantile_1.1.8-1PIGSTY~jammy_amd64.deb
postgresql-16-quantile 1.1.8 u22.aarch64 pigsty 23.0 KiB postgresql-16-quantile_1.1.8-1PIGSTY~jammy_arm64.deb
postgresql-16-quantile 1.1.8 u24.x86_64 pigsty 22.2 KiB postgresql-16-quantile_1.1.8-1PIGSTY~noble_amd64.deb
postgresql-16-quantile 1.1.8 u24.aarch64 pigsty 21.9 KiB postgresql-16-quantile_1.1.8-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
quantile_15 1.1.8 el8.x86_64 pigsty 18.5 KiB quantile_15-1.1.8-1PIGSTY.el8.x86_64.rpm
quantile_15 1.1.8 el8.aarch64 pigsty 17.8 KiB quantile_15-1.1.8-1PIGSTY.el8.aarch64.rpm
quantile_15 1.1.8 el9.x86_64 pigsty 18.2 KiB quantile_15-1.1.8-1PIGSTY.el9.x86_64.rpm
quantile_15 1.1.8 el9.aarch64 pigsty 17.5 KiB quantile_15-1.1.8-1PIGSTY.el9.aarch64.rpm
quantile_15 1.1.8 el10.x86_64 pigsty 18.1 KiB quantile_15-1.1.8-1PIGSTY.el10.x86_64.rpm
quantile_15 1.1.8 el10.aarch64 pigsty 17.8 KiB quantile_15-1.1.8-1PIGSTY.el10.aarch64.rpm
postgresql-15-quantile 1.1.8 d12.x86_64 pigsty 21.2 KiB postgresql-15-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb
postgresql-15-quantile 1.1.8 d12.aarch64 pigsty 20.9 KiB postgresql-15-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb
postgresql-15-quantile 1.1.8 d13.x86_64 pigsty 21.2 KiB postgresql-15-quantile_1.1.8-1PIGSTY~trixie_amd64.deb
postgresql-15-quantile 1.1.8 d13.aarch64 pigsty 21.0 KiB postgresql-15-quantile_1.1.8-1PIGSTY~trixie_arm64.deb
postgresql-15-quantile 1.1.8 u22.x86_64 pigsty 23.6 KiB postgresql-15-quantile_1.1.8-1PIGSTY~jammy_amd64.deb
postgresql-15-quantile 1.1.8 u22.aarch64 pigsty 22.7 KiB postgresql-15-quantile_1.1.8-1PIGSTY~jammy_arm64.deb
postgresql-15-quantile 1.1.8 u24.x86_64 pigsty 22.2 KiB postgresql-15-quantile_1.1.8-1PIGSTY~noble_amd64.deb
postgresql-15-quantile 1.1.8 u24.aarch64 pigsty 21.9 KiB postgresql-15-quantile_1.1.8-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
quantile_14 1.1.8 el8.x86_64 pigsty 18.5 KiB quantile_14-1.1.8-1PIGSTY.el8.x86_64.rpm
quantile_14 1.1.8 el8.aarch64 pigsty 17.8 KiB quantile_14-1.1.8-1PIGSTY.el8.aarch64.rpm
quantile_14 1.1.8 el9.x86_64 pigsty 18.1 KiB quantile_14-1.1.8-1PIGSTY.el9.x86_64.rpm
quantile_14 1.1.8 el9.aarch64 pigsty 17.5 KiB quantile_14-1.1.8-1PIGSTY.el9.aarch64.rpm
quantile_14 1.1.8 el10.x86_64 pigsty 18.1 KiB quantile_14-1.1.8-1PIGSTY.el10.x86_64.rpm
quantile_14 1.1.8 el10.aarch64 pigsty 17.8 KiB quantile_14-1.1.8-1PIGSTY.el10.aarch64.rpm
postgresql-14-quantile 1.1.8 d12.x86_64 pigsty 21.3 KiB postgresql-14-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb
postgresql-14-quantile 1.1.8 d12.aarch64 pigsty 21.0 KiB postgresql-14-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb
postgresql-14-quantile 1.1.8 d13.x86_64 pigsty 21.3 KiB postgresql-14-quantile_1.1.8-1PIGSTY~trixie_amd64.deb
postgresql-14-quantile 1.1.8 d13.aarch64 pigsty 21.1 KiB postgresql-14-quantile_1.1.8-1PIGSTY~trixie_arm64.deb
postgresql-14-quantile 1.1.8 u22.x86_64 pigsty 23.6 KiB postgresql-14-quantile_1.1.8-1PIGSTY~jammy_amd64.deb
postgresql-14-quantile 1.1.8 u22.aarch64 pigsty 22.7 KiB postgresql-14-quantile_1.1.8-1PIGSTY~jammy_arm64.deb
postgresql-14-quantile 1.1.8 u24.x86_64 pigsty 22.3 KiB postgresql-14-quantile_1.1.8-1PIGSTY~noble_amd64.deb
postgresql-14-quantile 1.1.8 u24.aarch64 pigsty 22.0 KiB postgresql-14-quantile_1.1.8-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
quantile_13 1.1.8 el8.x86_64 pigsty 18.2 KiB quantile_13-1.1.8-1PIGSTY.el8.x86_64.rpm
quantile_13 1.1.8 el8.aarch64 pigsty 17.8 KiB quantile_13-1.1.8-1PIGSTY.el8.aarch64.rpm
quantile_13 1.1.8 el9.x86_64 pigsty 18.2 KiB quantile_13-1.1.8-1PIGSTY.el9.x86_64.rpm
quantile_13 1.1.8 el9.aarch64 pigsty 17.5 KiB quantile_13-1.1.8-1PIGSTY.el9.aarch64.rpm
quantile_13 1.1.8 el10.x86_64 pigsty 18.1 KiB quantile_13-1.1.8-1PIGSTY.el10.x86_64.rpm
quantile_13 1.1.8 el10.aarch64 pigsty 17.8 KiB quantile_13-1.1.8-1PIGSTY.el10.aarch64.rpm
postgresql-13-quantile 1.1.8 d12.x86_64 pigsty 21.2 KiB postgresql-13-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb
postgresql-13-quantile 1.1.8 d12.aarch64 pigsty 20.5 KiB postgresql-13-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb
postgresql-13-quantile 1.1.8 d13.x86_64 pigsty 21.3 KiB postgresql-13-quantile_1.1.8-1PIGSTY~trixie_amd64.deb
postgresql-13-quantile 1.1.8 d13.aarch64 pigsty 20.6 KiB postgresql-13-quantile_1.1.8-1PIGSTY~trixie_arm64.deb
postgresql-13-quantile 1.1.8 u22.x86_64 pigsty 23.3 KiB postgresql-13-quantile_1.1.8-1PIGSTY~jammy_amd64.deb
postgresql-13-quantile 1.1.8 u22.aarch64 pigsty 22.8 KiB postgresql-13-quantile_1.1.8-1PIGSTY~jammy_arm64.deb
postgresql-13-quantile 1.1.8 u24.x86_64 pigsty 22.3 KiB postgresql-13-quantile_1.1.8-1PIGSTY~noble_amd64.deb
postgresql-13-quantile 1.1.8 u24.aarch64 pigsty 21.5 KiB postgresql-13-quantile_1.1.8-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/tvondra/quantile
 Source Tarball
quantile-1.1.8.tar.gz
 
pig build pkg quantile;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

pig install quantile;		# install via package name, for the active PG version

pig install quantile -v 18;   # install for PG 18
pig install quantile -v 17;   # install for PG 17
pig install quantile -v 16;   # install for PG 16
pig install quantile -v 15;   # install for PG 15
pig install quantile -v 14;   # install for PG 14
pig install quantile -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION quantile;
Last updated on
topnlower_quantile