vchord_bm25

Overview

PIGSTY 3rd Party Extension: vchord_bm25 : A postgresql extension for bm25 ranking algorithm

Information

• Extension ID: 2150
• Extension Name: vchord_bm25
• Package Name: vchord_bm25
• Category: FTS
• License: AGPLv3
• Website: https://github.com/tensorchord/VectorChord-bm25
• Language: Rust
• Extra Tags: pgrx
• Comment:

Metadata

• Latest Version: 0.2.1
• Postgres Support: 17,16,15,14
• Need Load: Explicit Loading Required
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can be installed into other schemas
• Trusted: Untrusted, Require Superuser to Create
• Schemas: bm25_catalog
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: vchord_bm25_$v
• RPM Ver : 0.2.1
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-vchord-bm25
• DEB Ver : 0.2.1
• DEB Deps: N/A

Availability

Installation

Install vchord_bm25 via the pig CLI tool:

pig ext install vchord_bm25

Install vchord_bm25 via Pigsty playbook:

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

Install vchord_bm25 RPM from YUM repo directly:

dnf install vchord_bm25_17;
dnf install vchord_bm25_16;
dnf install vchord_bm25_15;
dnf install vchord_bm25_14;

Install vchord_bm25 DEB from APT repo directly:

apt install postgresql-17-vchord-bm25;
apt install postgresql-16-vchord-bm25;
apt install postgresql-15-vchord-bm25;
apt install postgresql-14-vchord-bm25;

Extension vchord_bm25 has to be loaded via shared_preload_libraries

shared_preload_libraries = 'vchord_bm25'; # add to pg cluster config

Create vchord_bm25 extension on PostgreSQL cluster:

CREATE EXTENSION vchord_bm25;