quantile

quantile

Quantile aggregation function

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
4610
quantile
quantile
1.1.8
FUNC
BSD 2-Clause
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--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

TypeRepoVersionPG Major AvailabilityPackage PatternDependencies
EL
PIGSTY
1.1.8
18
17
16
15
14
13
quantile_$v*-
Debian
PIGSTY
1.1.8
18
17
16
15
14
13
postgresql-$v-quantile-
Linux / PGPG18PG17PG16PG15PG14PG13
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
MISS
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
d12.aarch64
MISS
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
d13.x86_64
MISS
MISS
MISS
MISS
MISS
MISS
d13.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
u22.x86_64
MISS
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
u22.aarch64
MISS
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
u24.x86_64
MISS
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
u24.aarch64
MISS
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PIGSTY 1.1.8
PackageVersionOSORGSIZEFile URL
quantile_181.1.8el8.x86_64pigsty18.5 KiBquantile_18-1.1.8-1PIGSTY.el8.x86_64.rpm
quantile_181.1.8el8.aarch64pigsty17.8 KiBquantile_18-1.1.8-1PIGSTY.el8.aarch64.rpm
quantile_181.1.8el9.x86_64pigsty18.1 KiBquantile_18-1.1.8-1PIGSTY.el9.x86_64.rpm
quantile_181.1.8el9.aarch64pigsty17.5 KiBquantile_18-1.1.8-1PIGSTY.el9.aarch64.rpm
quantile_181.1.8el10.x86_64pigsty18.1 KiBquantile_18-1.1.8-1PIGSTY.el10.x86_64.rpm
quantile_181.1.8el10.aarch64pigsty17.8 KiBquantile_18-1.1.8-1PIGSTY.el10.aarch64.rpm
PackageVersionOSORGSIZEFile URL
quantile_171.1.8el8.x86_64pigsty18.5 KiBquantile_17-1.1.8-1PIGSTY.el8.x86_64.rpm
quantile_171.1.8el8.aarch64pigsty17.8 KiBquantile_17-1.1.8-1PIGSTY.el8.aarch64.rpm
quantile_171.1.8el9.x86_64pigsty18.2 KiBquantile_17-1.1.8-1PIGSTY.el9.x86_64.rpm
quantile_171.1.8el9.aarch64pigsty17.5 KiBquantile_17-1.1.8-1PIGSTY.el9.aarch64.rpm
quantile_171.1.8el10.x86_64pigsty18.1 KiBquantile_17-1.1.8-1PIGSTY.el10.x86_64.rpm
quantile_171.1.8el10.aarch64pigsty17.8 KiBquantile_17-1.1.8-1PIGSTY.el10.aarch64.rpm
postgresql-17-quantile1.1.8d12.x86_64pigsty22.6 KiBpostgresql-17-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb
postgresql-17-quantile1.1.8d12.aarch64pigsty22.1 KiBpostgresql-17-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb
postgresql-17-quantile1.1.8u22.x86_64pigsty23.9 KiBpostgresql-17-quantile_1.1.8-1PIGSTY~jammy_amd64.deb
postgresql-17-quantile1.1.8u22.aarch64pigsty23.0 KiBpostgresql-17-quantile_1.1.8-1PIGSTY~jammy_arm64.deb
postgresql-17-quantile1.1.8u24.x86_64pigsty22.1 KiBpostgresql-17-quantile_1.1.8-1PIGSTY~noble_amd64.deb
postgresql-17-quantile1.1.8u24.aarch64pigsty21.7 KiBpostgresql-17-quantile_1.1.8-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
quantile_161.1.8el8.x86_64pigsty18.5 KiBquantile_16-1.1.8-1PIGSTY.el8.x86_64.rpm
quantile_161.1.8el8.aarch64pigsty17.8 KiBquantile_16-1.1.8-1PIGSTY.el8.aarch64.rpm
quantile_161.1.8el9.x86_64pigsty18.2 KiBquantile_16-1.1.8-1PIGSTY.el9.x86_64.rpm
quantile_161.1.8el9.aarch64pigsty17.5 KiBquantile_16-1.1.8-1PIGSTY.el9.aarch64.rpm
quantile_161.1.8el10.x86_64pigsty18.1 KiBquantile_16-1.1.8-1PIGSTY.el10.x86_64.rpm
quantile_161.1.8el10.aarch64pigsty17.8 KiBquantile_16-1.1.8-1PIGSTY.el10.aarch64.rpm
postgresql-16-quantile1.1.8d12.x86_64pigsty22.5 KiBpostgresql-16-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb
postgresql-16-quantile1.1.8d12.aarch64pigsty22.1 KiBpostgresql-16-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb
postgresql-16-quantile1.1.8u22.x86_64pigsty23.9 KiBpostgresql-16-quantile_1.1.8-1PIGSTY~jammy_amd64.deb
postgresql-16-quantile1.1.8u22.aarch64pigsty22.9 KiBpostgresql-16-quantile_1.1.8-1PIGSTY~jammy_arm64.deb
postgresql-16-quantile1.1.8u24.x86_64pigsty22.0 KiBpostgresql-16-quantile_1.1.8-1PIGSTY~noble_amd64.deb
postgresql-16-quantile1.1.8u24.aarch64pigsty21.6 KiBpostgresql-16-quantile_1.1.8-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
quantile_151.1.8el8.x86_64pigsty18.5 KiBquantile_15-1.1.8-1PIGSTY.el8.x86_64.rpm
quantile_151.1.8el8.aarch64pigsty17.8 KiBquantile_15-1.1.8-1PIGSTY.el8.aarch64.rpm
quantile_151.1.8el9.x86_64pigsty18.2 KiBquantile_15-1.1.8-1PIGSTY.el9.x86_64.rpm
quantile_151.1.8el9.aarch64pigsty17.5 KiBquantile_15-1.1.8-1PIGSTY.el9.aarch64.rpm
quantile_151.1.8el10.x86_64pigsty18.1 KiBquantile_15-1.1.8-1PIGSTY.el10.x86_64.rpm
quantile_151.1.8el10.aarch64pigsty17.8 KiBquantile_15-1.1.8-1PIGSTY.el10.aarch64.rpm
postgresql-15-quantile1.1.8d12.x86_64pigsty22.3 KiBpostgresql-15-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb
postgresql-15-quantile1.1.8d12.aarch64pigsty21.8 KiBpostgresql-15-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb
postgresql-15-quantile1.1.8u22.x86_64pigsty23.6 KiBpostgresql-15-quantile_1.1.8-1PIGSTY~jammy_amd64.deb
postgresql-15-quantile1.1.8u22.aarch64pigsty22.7 KiBpostgresql-15-quantile_1.1.8-1PIGSTY~jammy_arm64.deb
postgresql-15-quantile1.1.8u24.x86_64pigsty22.0 KiBpostgresql-15-quantile_1.1.8-1PIGSTY~noble_amd64.deb
postgresql-15-quantile1.1.8u24.aarch64pigsty21.6 KiBpostgresql-15-quantile_1.1.8-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
quantile_141.1.8el8.x86_64pigsty18.5 KiBquantile_14-1.1.8-1PIGSTY.el8.x86_64.rpm
quantile_141.1.8el8.aarch64pigsty17.8 KiBquantile_14-1.1.8-1PIGSTY.el8.aarch64.rpm
quantile_141.1.8el9.x86_64pigsty18.1 KiBquantile_14-1.1.8-1PIGSTY.el9.x86_64.rpm
quantile_141.1.8el9.aarch64pigsty17.5 KiBquantile_14-1.1.8-1PIGSTY.el9.aarch64.rpm
quantile_141.1.8el10.x86_64pigsty18.1 KiBquantile_14-1.1.8-1PIGSTY.el10.x86_64.rpm
quantile_141.1.8el10.aarch64pigsty17.8 KiBquantile_14-1.1.8-1PIGSTY.el10.aarch64.rpm
postgresql-14-quantile1.1.8d12.x86_64pigsty22.2 KiBpostgresql-14-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb
postgresql-14-quantile1.1.8d12.aarch64pigsty21.8 KiBpostgresql-14-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb
postgresql-14-quantile1.1.8u22.x86_64pigsty23.6 KiBpostgresql-14-quantile_1.1.8-1PIGSTY~jammy_amd64.deb
postgresql-14-quantile1.1.8u22.aarch64pigsty22.7 KiBpostgresql-14-quantile_1.1.8-1PIGSTY~jammy_arm64.deb
postgresql-14-quantile1.1.8u24.x86_64pigsty22.1 KiBpostgresql-14-quantile_1.1.8-1PIGSTY~noble_amd64.deb
postgresql-14-quantile1.1.8u24.aarch64pigsty21.6 KiBpostgresql-14-quantile_1.1.8-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
quantile_131.1.8el8.x86_64pigsty18.2 KiBquantile_13-1.1.8-1PIGSTY.el8.x86_64.rpm
quantile_131.1.8el8.aarch64pigsty17.8 KiBquantile_13-1.1.8-1PIGSTY.el8.aarch64.rpm
quantile_131.1.8el9.x86_64pigsty18.2 KiBquantile_13-1.1.8-1PIGSTY.el9.x86_64.rpm
quantile_131.1.8el9.aarch64pigsty17.5 KiBquantile_13-1.1.8-1PIGSTY.el9.aarch64.rpm
quantile_131.1.8el10.x86_64pigsty18.1 KiBquantile_13-1.1.8-1PIGSTY.el10.x86_64.rpm
quantile_131.1.8el10.aarch64pigsty17.8 KiBquantile_13-1.1.8-1PIGSTY.el10.aarch64.rpm
postgresql-13-quantile1.1.8d12.x86_64pigsty22.2 KiBpostgresql-13-quantile_1.1.8-1PIGSTY~bookworm_amd64.deb
postgresql-13-quantile1.1.8d12.aarch64pigsty21.7 KiBpostgresql-13-quantile_1.1.8-1PIGSTY~bookworm_arm64.deb
postgresql-13-quantile1.1.8u22.x86_64pigsty23.3 KiBpostgresql-13-quantile_1.1.8-1PIGSTY~jammy_amd64.deb
postgresql-13-quantile1.1.8u22.aarch64pigsty22.8 KiBpostgresql-13-quantile_1.1.8-1PIGSTY~jammy_arm64.deb
postgresql-13-quantile1.1.8u24.x86_64pigsty22.1 KiBpostgresql-13-quantile_1.1.8-1PIGSTY~noble_amd64.deb
postgresql-13-quantile1.1.8u24.aarch64pigsty21.5 KiBpostgresql-13-quantile_1.1.8-1PIGSTY~noble_arm64.deb

Source

pig build get quantile; # get quantile source code
pig build dep quantile; # install build dependencies
pig build pkg quantile; # build extension rpm or deb
pig build ext quantile; # build extension rpms

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install quantile; # install by extension name, for the current active PG version
pig ext install quantile; # install via package alias, for the active PG version
pig ext install quantile -v 18;   # install for PG 18
pig ext install quantile -v 17;   # install for PG 17
pig ext install quantile -v 16;   # install for PG 16
pig ext install quantile -v 15;   # install for PG 15
pig ext install quantile -v 14;   # install for PG 14
pig ext install quantile -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION quantile;
Last updated on