vectorscale
Advanced indexing for vector data with DiskANN
Repository
timescale/pgvectorscale
https://github.com/timescale/pgvectorscale
Source
pgvectorscale-0.9.0.tar.gz
pgvectorscale-0.9.0.tar.gz
Overview
| Package | Version | Category | License | Language |
|---|---|---|---|---|
pgvectorscale | 0.9.0 | RAG | PostgreSQL | Rust |
| ID | Extension | Bin | Lib | Load | Create | Trust | Reloc | Schema |
|---|---|---|---|---|---|---|---|---|
| 1820 | vectorscale | No | Yes | No | Yes | No | No | - |
| Related | vector vchord vectorize pg_summarize pg_tiktoken pg4ml pgml vchord_bm25 pg_similarity |
|---|
Version
| Type | Repo | Version | PG Ver | Package | Deps |
|---|---|---|---|---|---|
| EXT | PIGSTY | 0.9.0 | 1817161514 | pgvectorscale | vector |
| RPM | PIGSTY | 0.9.0 | 1817161514 | pgvectorscale_$v | pgvector_$v |
| DEB | PIGSTY | 0.9.0 | 1817161514 | postgresql-$v-pgvectorscale | postgresql-$v-pgvector |
Build
You can build the RPM / DEB packages for pgvectorscale using pig build:
pig build pkg pgvectorscale # build RPM / DEB packages
Install
You can install pgvectorscale 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:
pig install pgvectorscale; # Install for current active PG version
pig ext install -y pgvectorscale -v 18 # PG 18
pig ext install -y pgvectorscale -v 17 # PG 17
pig ext install -y pgvectorscale -v 16 # PG 16
pig ext install -y pgvectorscale -v 15 # PG 15
pig ext install -y pgvectorscale -v 14 # PG 14
dnf install -y pgvectorscale_18 # PG 18
dnf install -y pgvectorscale_17 # PG 17
dnf install -y pgvectorscale_16 # PG 16
dnf install -y pgvectorscale_15 # PG 15
dnf install -y pgvectorscale_14 # PG 14
apt install -y postgresql-18-pgvectorscale # PG 18
apt install -y postgresql-17-pgvectorscale # PG 17
apt install -y postgresql-16-pgvectorscale # PG 16
apt install -y postgresql-15-pgvectorscale # PG 15
apt install -y postgresql-14-pgvectorscale # PG 14
Create Extension:
CREATE EXTENSION vectorscale CASCADE; -- requires: vector
Usage
CREATE EXTENSION vectorscale CASCADE;
CREATE TABLE IF NOT EXISTS document_embedding (
id BIGINT PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
metadata JSONB,
contents TEXT,
embedding VECTOR(1536)
);
CREATE INDEX document_embedding_idx ON document_embedding
USING diskann (embedding);
SELECT *
FROM document_embedding
ORDER BY embedding <=> $1
LIMIT 10
Feedback
Was this page helpful?
Thanks for the feedback! Please let us know how we can improve.
Sorry to hear that. Please let us know how we can improve.