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

Availability

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; 

Create lower_quantile extension on PostgreSQL cluster:

CREATE EXTENSION lower_quantile;