pgml

Run AL/ML workloads with SQL interface

Overview

Package	Version	Category	License	Language
`pgml`	`2.10.0`	RAG	MIT	Rust

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
1940	`pgml`	No	Yes	Yes	Yes	Yes	No	`pgml`

Related	`vectorize` `pg4ml` `pgcontext` `pgmnemo` `vector` `pg_summarize` `pg_ai_query`

pgrx=0.12.9

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PIGSTY	`2.10.0`	1817161514	`pgml`	-
RPM	PIGSTY	`2.10.0`	1817161514	`pgml_$v`	-
DEB	PIGSTY	`2.10.0`	1817161514	`postgresql-$v-pgml`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	N/A	PIGSTY 2.10.0 el8.x86_64.pg17 : pgml_17 pgml_17-2.10.0-1PIGSTY.el8.x86_64.rpm PIGSTY · 2.10.0 · 5.7MiB	PIGSTY 2.10.0 el8.x86_64.pg16 : pgml_16 pgml_16-2.10.0-1PIGSTY.el8.x86_64.rpm PIGSTY · 2.10.0 · 5.7MiB	PIGSTY 2.10.0 el8.x86_64.pg15 : pgml_15 pgml_15-2.10.0-1PIGSTY.el8.x86_64.rpm PIGSTY · 2.10.0 · 5.7MiB	PIGSTY 2.10.0 el8.x86_64.pg14 : pgml_14 pgml_14-2.10.0-1PIGSTY.el8.x86_64.rpm PIGSTY · 2.10.0 · 5.7MiB
el8.aarch64	N/A	PIGSTY 2.10.0 el8.aarch64.pg17 : pgml_17 pgml_17-2.10.0-1PIGSTY.el8.aarch64.rpm PIGSTY · 2.10.0 · 4.8MiB	PIGSTY 2.10.0 el8.aarch64.pg16 : pgml_16 pgml_16-2.10.0-1PIGSTY.el8.aarch64.rpm PIGSTY · 2.10.0 · 4.8MiB	PIGSTY 2.10.0 el8.aarch64.pg15 : pgml_15 pgml_15-2.10.0-1PIGSTY.el8.aarch64.rpm PIGSTY · 2.10.0 · 4.8MiB	PIGSTY 2.10.0 el8.aarch64.pg14 : pgml_14 pgml_14-2.10.0-1PIGSTY.el8.aarch64.rpm PIGSTY · 2.10.0 · 4.8MiB
el9.x86_64	N/A	PIGSTY 2.10.0 el9.x86_64.pg17 : pgml_17 pgml_17-2.10.0-1PIGSTY.el9.x86_64.rpm PIGSTY · 2.10.0 · 5.3MiB	PIGSTY 2.10.0 el9.x86_64.pg16 : pgml_16 pgml_16-2.10.0-1PIGSTY.el9.x86_64.rpm PIGSTY · 2.10.0 · 5.3MiB	PIGSTY 2.10.0 el9.x86_64.pg15 : pgml_15 pgml_15-2.10.0-1PIGSTY.el9.x86_64.rpm PIGSTY · 2.10.0 · 5.3MiB	PIGSTY 2.10.0 el9.x86_64.pg14 : pgml_14 pgml_14-2.10.0-1PIGSTY.el9.x86_64.rpm PIGSTY · 2.10.0 · 5.3MiB
el9.aarch64	N/A	PIGSTY 2.10.0 el9.aarch64.pg17 : pgml_17 pgml_17-2.10.0-1PIGSTY.el9.aarch64.rpm PIGSTY · 2.10.0 · 5.1MiB	PIGSTY 2.10.0 el9.aarch64.pg16 : pgml_16 pgml_16-2.10.0-1PIGSTY.el9.aarch64.rpm PIGSTY · 2.10.0 · 5.1MiB	PIGSTY 2.10.0 el9.aarch64.pg15 : pgml_15 pgml_15-2.10.0-1PIGSTY.el9.aarch64.rpm PIGSTY · 2.10.0 · 5.1MiB	PIGSTY 2.10.0 el9.aarch64.pg14 : pgml_14 pgml_14-2.10.0-1PIGSTY.el9.aarch64.rpm PIGSTY · 2.10.0 · 5.1MiB
el10.x86_64	N/A	PIGSTY 2.10.0 el10.x86_64.pg17 : pgml_17 pgml_17-2.10.0-1PIGSTY.el10.x86_64.rpm PIGSTY · 2.10.0 · 4.9MiB	PIGSTY 2.10.0 el10.x86_64.pg16 : pgml_16 pgml_16-2.10.0-1PIGSTY.el10.x86_64.rpm PIGSTY · 2.10.0 · 4.9MiB	PIGSTY 2.10.0 el10.x86_64.pg15 : pgml_15 pgml_15-2.10.0-1PIGSTY.el10.x86_64.rpm PIGSTY · 2.10.0 · 4.9MiB	PIGSTY 2.10.0 el10.x86_64.pg14 : pgml_14 pgml_14-2.10.0-1PIGSTY.el10.x86_64.rpm PIGSTY · 2.10.0 · 4.9MiB
el10.aarch64	N/A	PIGSTY 2.10.0 el10.aarch64.pg17 : pgml_17 pgml_17-2.10.0-1PIGSTY.el10.aarch64.rpm PIGSTY · 2.10.0 · 4.6MiB	PIGSTY 2.10.0 el10.aarch64.pg16 : pgml_16 pgml_16-2.10.0-1PIGSTY.el10.aarch64.rpm PIGSTY · 2.10.0 · 4.6MiB	PIGSTY 2.10.0 el10.aarch64.pg15 : pgml_15 pgml_15-2.10.0-1PIGSTY.el10.aarch64.rpm PIGSTY · 2.10.0 · 4.6MiB	PIGSTY 2.10.0 el10.aarch64.pg14 : pgml_14 pgml_14-2.10.0-1PIGSTY.el10.aarch64.rpm PIGSTY · 2.10.0 · 4.6MiB
d12.x86_64	N/A	PIGSTY 2.10.0 d12.x86_64.pg17 : postgresql-17-pgml postgresql-17-pgml_2.10.0-1PIGSTY~bookworm_amd64.deb PIGSTY · 2.10.0 · 4.7MiB	PIGSTY 2.10.0 d12.x86_64.pg16 : postgresql-16-pgml postgresql-16-pgml_2.10.0-1PIGSTY~bookworm_amd64.deb PIGSTY · 2.10.0 · 4.7MiB	PIGSTY 2.10.0 d12.x86_64.pg15 : postgresql-15-pgml postgresql-15-pgml_2.10.0-1PIGSTY~bookworm_amd64.deb PIGSTY · 2.10.0 · 4.7MiB	PIGSTY 2.10.0 d12.x86_64.pg14 : postgresql-14-pgml postgresql-14-pgml_2.10.0-1PIGSTY~bookworm_amd64.deb PIGSTY · 2.10.0 · 4.7MiB
d12.aarch64	N/A	PIGSTY 2.10.0 d12.aarch64.pg17 : postgresql-17-pgml postgresql-17-pgml_2.10.0-1PIGSTY~bookworm_arm64.deb PIGSTY · 2.10.0 · 4.0MiB	PIGSTY 2.10.0 d12.aarch64.pg16 : postgresql-16-pgml postgresql-16-pgml_2.10.0-1PIGSTY~bookworm_arm64.deb PIGSTY · 2.10.0 · 4.0MiB	PIGSTY 2.10.0 d12.aarch64.pg15 : postgresql-15-pgml postgresql-15-pgml_2.10.0-1PIGSTY~bookworm_arm64.deb PIGSTY · 2.10.0 · 4.0MiB	PIGSTY 2.10.0 d12.aarch64.pg14 : postgresql-14-pgml postgresql-14-pgml_2.10.0-1PIGSTY~bookworm_arm64.deb PIGSTY · 2.10.0 · 4.0MiB
d13.x86_64	N/A	PIGSTY 2.10.0 d13.x86_64.pg17 : postgresql-17-pgml postgresql-17-pgml_2.10.0-1PIGSTY~trixie_amd64.deb PIGSTY · 2.10.0 · 4.2MiB	PIGSTY 2.10.0 d13.x86_64.pg16 : postgresql-16-pgml postgresql-16-pgml_2.10.0-1PIGSTY~trixie_amd64.deb PIGSTY · 2.10.0 · 4.2MiB	PIGSTY 2.10.0 d13.x86_64.pg15 : postgresql-15-pgml postgresql-15-pgml_2.10.0-1PIGSTY~trixie_amd64.deb PIGSTY · 2.10.0 · 4.2MiB	PIGSTY 2.10.0 d13.x86_64.pg14 : postgresql-14-pgml postgresql-14-pgml_2.10.0-1PIGSTY~trixie_amd64.deb PIGSTY · 2.10.0 · 4.2MiB
d13.aarch64	N/A	PIGSTY 2.10.0 d13.aarch64.pg17 : postgresql-17-pgml postgresql-17-pgml_2.10.0-1PIGSTY~trixie_arm64.deb PIGSTY · 2.10.0 · 3.6MiB	PIGSTY 2.10.0 d13.aarch64.pg16 : postgresql-16-pgml postgresql-16-pgml_2.10.0-1PIGSTY~trixie_arm64.deb PIGSTY · 2.10.0 · 3.6MiB	PIGSTY 2.10.0 d13.aarch64.pg15 : postgresql-15-pgml postgresql-15-pgml_2.10.0-1PIGSTY~trixie_arm64.deb PIGSTY · 2.10.0 · 3.6MiB	PIGSTY 2.10.0 d13.aarch64.pg14 : postgresql-14-pgml postgresql-14-pgml_2.10.0-1PIGSTY~trixie_arm64.deb PIGSTY · 2.10.0 · 3.6MiB
u22.x86_64	N/A	PIGSTY 2.10.0 u22.x86_64.pg17 : postgresql-17-pgml postgresql-17-pgml_2.10.0-1PIGSTY~jammy_amd64.deb PIGSTY · 2.10.0 · 5.1MiB	PIGSTY 2.10.0 u22.x86_64.pg16 : postgresql-16-pgml postgresql-16-pgml_2.10.0-1PIGSTY~jammy_amd64.deb PIGSTY · 2.10.0 · 5.1MiB	PIGSTY 2.10.0 u22.x86_64.pg15 : postgresql-15-pgml postgresql-15-pgml_2.10.0-1PIGSTY~jammy_amd64.deb PIGSTY · 2.10.0 · 5.1MiB	PIGSTY 2.10.0 u22.x86_64.pg14 : postgresql-14-pgml postgresql-14-pgml_2.10.0-1PIGSTY~jammy_amd64.deb PIGSTY · 2.10.0 · 5.1MiB
u22.aarch64	N/A	PIGSTY 2.10.0 u22.aarch64.pg17 : postgresql-17-pgml postgresql-17-pgml_2.10.0-1PIGSTY~jammy_arm64.deb PIGSTY · 2.10.0 · 4.8MiB	PIGSTY 2.10.0 u22.aarch64.pg16 : postgresql-16-pgml postgresql-16-pgml_2.10.0-1PIGSTY~jammy_arm64.deb PIGSTY · 2.10.0 · 4.8MiB	PIGSTY 2.10.0 u22.aarch64.pg15 : postgresql-15-pgml postgresql-15-pgml_2.10.0-1PIGSTY~jammy_arm64.deb PIGSTY · 2.10.0 · 4.8MiB	PIGSTY 2.10.0 u22.aarch64.pg14 : postgresql-14-pgml postgresql-14-pgml_2.10.0-1PIGSTY~jammy_arm64.deb PIGSTY · 2.10.0 · 4.8MiB
u24.x86_64	N/A	PIGSTY 2.10.0 u24.x86_64.pg17 : postgresql-17-pgml postgresql-17-pgml_2.10.0-1PIGSTY~noble_amd64.deb PIGSTY · 2.10.0 · 5.4MiB	PIGSTY 2.10.0 u24.x86_64.pg16 : postgresql-16-pgml postgresql-16-pgml_2.10.0-1PIGSTY~noble_amd64.deb PIGSTY · 2.10.0 · 5.4MiB	PIGSTY 2.10.0 u24.x86_64.pg15 : postgresql-15-pgml postgresql-15-pgml_2.10.0-1PIGSTY~noble_amd64.deb PIGSTY · 2.10.0 · 5.4MiB	PIGSTY 2.10.0 u24.x86_64.pg14 : postgresql-14-pgml postgresql-14-pgml_2.10.0-1PIGSTY~noble_amd64.deb PIGSTY · 2.10.0 · 5.4MiB
u24.aarch64	N/A	PIGSTY 2.10.0 u24.aarch64.pg17 : postgresql-17-pgml postgresql-17-pgml_2.10.0-1PIGSTY~noble_arm64.deb PIGSTY · 2.10.0 · 4.9MiB	PIGSTY 2.10.0 u24.aarch64.pg16 : postgresql-16-pgml postgresql-16-pgml_2.10.0-1PIGSTY~noble_arm64.deb PIGSTY · 2.10.0 · 4.9MiB	PIGSTY 2.10.0 u24.aarch64.pg15 : postgresql-15-pgml postgresql-15-pgml_2.10.0-1PIGSTY~noble_arm64.deb PIGSTY · 2.10.0 · 4.9MiB	PIGSTY 2.10.0 u24.aarch64.pg14 : postgresql-14-pgml postgresql-14-pgml_2.10.0-1PIGSTY~noble_arm64.deb PIGSTY · 2.10.0 · 4.9MiB
u26.x86_64	N/A	PIGSTY 2.10.0 u26.x86_64.pg17 : postgresql-17-pgml postgresql-17-pgml_2.10.0-1PIGSTY~resolute_amd64.deb PIGSTY · 2.10.0 · 4.7MiB	PIGSTY 2.10.0 u26.x86_64.pg16 : postgresql-16-pgml postgresql-16-pgml_2.10.0-1PIGSTY~resolute_amd64.deb PIGSTY · 2.10.0 · 4.7MiB	PIGSTY 2.10.0 u26.x86_64.pg15 : postgresql-15-pgml postgresql-15-pgml_2.10.0-1PIGSTY~resolute_amd64.deb PIGSTY · 2.10.0 · 4.7MiB	PIGSTY 2.10.0 u26.x86_64.pg14 : postgresql-14-pgml postgresql-14-pgml_2.10.0-1PIGSTY~resolute_amd64.deb PIGSTY · 2.10.0 · 4.7MiB
u26.aarch64	N/A	PIGSTY 2.10.0 u26.aarch64.pg17 : postgresql-17-pgml postgresql-17-pgml_2.10.0-1PIGSTY~resolute_arm64.deb PIGSTY · 2.10.0 · 4.4MiB	PIGSTY 2.10.0 u26.aarch64.pg16 : postgresql-16-pgml postgresql-16-pgml_2.10.0-1PIGSTY~resolute_arm64.deb PIGSTY · 2.10.0 · 4.4MiB	PIGSTY 2.10.0 u26.aarch64.pg15 : postgresql-15-pgml postgresql-15-pgml_2.10.0-1PIGSTY~resolute_arm64.deb PIGSTY · 2.10.0 · 4.4MiB	PIGSTY 2.10.0 u26.aarch64.pg14 : postgresql-14-pgml postgresql-14-pgml_2.10.0-1PIGSTY~resolute_arm64.deb PIGSTY · 2.10.0 · 4.4MiB

Build

You can build the RPM / DEB packages for pgml using pig build:

pig build pkg pgml         # build RPM / DEB packages

Install

You can install pgml 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:

Install

pig install pgml;          # Install for current active PG version

pig

pig ext install -y pgml -v 17  # PG 17
pig ext install -y pgml -v 16  # PG 16
pig ext install -y pgml -v 15  # PG 15
pig ext install -y pgml -v 14  # PG 14

dnf

dnf install -y pgml_17       # PG 17
dnf install -y pgml_16       # PG 16
dnf install -y pgml_15       # PG 15
dnf install -y pgml_14       # PG 14

apt

apt install -y postgresql-17-pgml   # PG 17
apt install -y postgresql-16-pgml   # PG 16
apt install -y postgresql-15-pgml   # PG 15
apt install -y postgresql-14-pgml   # PG 14

Preload:

shared_preload_libraries = 'pgml';

Create Extension:

CREATE EXTENSION pgml;

Usage

This extension is lack of maintenance

After installing the pgml extension and python dependencies on all cluster nodes, you can enable pgml on the PostgreSQL cluster.

Edit the cluster configuration with patronictl, add pgml to shared_preload_libraries, and specify your venv directory in pgml.venv:

shared_preload_libraries: pgml, timescaledb, pg_stat_statements, auto_explain
pgml.venv: '/data/pgml'

After that, restart database cluster, and create extension with SQL command:

CREATE EXTENSION vector;        -- nice to have pgvector installed too!
CREATE EXTENSION pgml;          -- create PostgresML in current database
SELECT pgml.version();          -- print PostgresML version string

If it works, you should see something like:

# create extension pgml;
INFO:  Python version: 3.11.2 (main, Oct  5 2023, 16:06:03) [GCC 8.5.0 20210514 (Red Hat 8.5.0-18)]
INFO:  Scikit-learn 1.3.0, XGBoost 2.0.0, LightGBM 4.1.0, NumPy 1.26.1
CREATE EXTENSION

# SELECT pgml.version(); -- print PostgresML version string
 version
---------
 2.7.8

You are all set! Check PostgresML for more details: https://postgresml.org/docs/guides/use-cases/

pgml

Overview

Version

Build

Install

Usage

Was this page helpful?