lower_quantile

Overview

PIGSTY 3rd Party Extension: lower_quantile : Lower quantile aggregate function

Information

• Extension ID: 4620
• Extension Name: lower_quantile
• Package Name: lower_quantile
• Category: FUNC
• License: BSD 2
• Website: https://github.com/tvondra/lower_quantile
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 1.0.3
• Postgres Support: 17,16,15,14,13
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Unknown
• Trusted: Unknown
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: lower_quantile_$v*
• RPM Ver : 1.0.3
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-lower-quantile
• DEB Ver : 1.0.3
• DEB Deps: N/A

Packages

Installation

Install lower_quantile via the pig CLI tool:

pig ext install lower_quantile

Install lower_quantile via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["lower_quantile"]}' # -l <cls>

Install lower_quantile RPM from YUM repo directly:

dnf install lower_quantile_17*;
dnf install lower_quantile_16*;
dnf install lower_quantile_15*;
dnf install lower_quantile_14*;
dnf install lower_quantile_13*;

Install lower_quantile DEB from APT repo directly:

apt install postgresql-17-lower-quantile;
apt install postgresql-16-lower-quantile;
apt install postgresql-15-lower-quantile;
apt install postgresql-14-lower-quantile;
apt install postgresql-13-lower-quantile;

Enable lower_quantile extension on PostgreSQL cluster：

CREATE EXTENSION lower_quantile;