vectorize

Overview

PIGSTY 3rd Party Extension: pg_vectorize : The simplest way to do vector search on Postgres

Information

• Extension ID: 1830
• Extension Name: vectorize
• Package Name: pg_vectorize
• Category: RAG
• License: PostgreSQL
• Website: https://github.com/ChuckHend/pg_vectorize
• Language: Rust
• Extra Tags: pgrx
• Comment:

Metadata

• Latest Version: 0.22.2
• Postgres Support: 17,16,15,14
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can be installed into other schemas
• Trusted: Untrusted, Require Superuser to Create
• Schemas: vectorize
• Requires: pg_cron, pgmq, vector

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pg_vectorize_$v
• RPM Ver : 0.22.2
• RPM Deps: pgmq_$v, pg_cron_$v, pgvector_$v
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-pg-vectorize
• DEB Ver : 0.22.2
• DEB Deps: postgresql-$v-pgmq, postgresql-$v-pg-cron, postgresql-$v-pgvector

Availability

Installation

Install vectorize via the pig CLI tool:

pig ext install pg_vectorize; 	# Extension Name
pig ext install vectorize; 	# normalized package name

Install pg_vectorize via Pigsty playbook:

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

Install pg_vectorize RPM from YUM repo directly:

dnf install pg_vectorize_17;
dnf install pg_vectorize_16;
dnf install pg_vectorize_15;
dnf install pg_vectorize_14;

Install pg_vectorize DEB from APT repo directly:

apt install postgresql-17-pg-vectorize;
apt install postgresql-16-pg-vectorize;
apt install postgresql-15-pg-vectorize;
apt install postgresql-14-pg-vectorize;

Create vectorize extension on PostgreSQL cluster:

CREATE EXTENSION vectorize CASCADE;