vectorscale

Advanced indexing for vector data with DiskANN

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` `vector` `vchord` `pgcontext` `vectorize` `pg_rrf` `pg_search` `vchord_bm25` `pg_bestmatch` `pgml` `pg4ml`

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`

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.9.0 el8.x86_64.pg18 : pgvectorscale_18 pgvectorscale_18-0.9.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el8.x86_64.pg17 : pgvectorscale_17 pgvectorscale_17-0.9.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el8.x86_64.pg16 : pgvectorscale_16 pgvectorscale_16-0.9.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el8.x86_64.pg15 : pgvectorscale_15 pgvectorscale_15-0.9.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el8.x86_64.pg14 : pgvectorscale_14 pgvectorscale_14-0.9.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB
el8.aarch64	PIGSTY 0.9.0 el8.aarch64.pg18 : pgvectorscale_18 pgvectorscale_18-0.9.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.9.0 · 977.8KiB	PIGSTY 0.9.0 el8.aarch64.pg17 : pgvectorscale_17 pgvectorscale_17-0.9.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.9.0 · 974.7KiB	PIGSTY 0.9.0 el8.aarch64.pg16 : pgvectorscale_16 pgvectorscale_16-0.9.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.9.0 · 973.2KiB	PIGSTY 0.9.0 el8.aarch64.pg15 : pgvectorscale_15 pgvectorscale_15-0.9.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.9.0 · 963.6KiB	PIGSTY 0.9.0 el8.aarch64.pg14 : pgvectorscale_14 pgvectorscale_14-0.9.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.9.0 · 960.4KiB
el9.x86_64	PIGSTY 0.9.0 el9.x86_64.pg18 : pgvectorscale_18 pgvectorscale_18-0.9.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el9.x86_64.pg17 : pgvectorscale_17 pgvectorscale_17-0.9.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el9.x86_64.pg16 : pgvectorscale_16 pgvectorscale_16-0.9.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el9.x86_64.pg15 : pgvectorscale_15 pgvectorscale_15-0.9.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el9.x86_64.pg14 : pgvectorscale_14 pgvectorscale_14-0.9.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB
el9.aarch64	PIGSTY 0.9.0 el9.aarch64.pg18 : pgvectorscale_18 pgvectorscale_18-0.9.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.9.0 · 1.0MiB	PIGSTY 0.9.0 el9.aarch64.pg17 : pgvectorscale_17 pgvectorscale_17-0.9.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.9.0 · 1.0MiB	PIGSTY 0.9.0 el9.aarch64.pg16 : pgvectorscale_16 pgvectorscale_16-0.9.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.9.0 · 1.0MiB	PIGSTY 0.9.0 el9.aarch64.pg15 : pgvectorscale_15 pgvectorscale_15-0.9.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.9.0 · 1.0MiB	PIGSTY 0.9.0 el9.aarch64.pg14 : pgvectorscale_14 pgvectorscale_14-0.9.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.9.0 · 1020.6KiB
el10.x86_64	PIGSTY 0.9.0 el10.x86_64.pg18 : pgvectorscale_18 pgvectorscale_18-0.9.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el10.x86_64.pg17 : pgvectorscale_17 pgvectorscale_17-0.9.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el10.x86_64.pg16 : pgvectorscale_16 pgvectorscale_16-0.9.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el10.x86_64.pg15 : pgvectorscale_15 pgvectorscale_15-0.9.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB	PIGSTY 0.9.0 el10.x86_64.pg14 : pgvectorscale_14 pgvectorscale_14-0.9.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.9.0 · 1.1MiB
el10.aarch64	PIGSTY 0.9.0 el10.aarch64.pg18 : pgvectorscale_18 pgvectorscale_18-0.9.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.9.0 · 1018.5KiB	PIGSTY 0.9.0 el10.aarch64.pg17 : pgvectorscale_17 pgvectorscale_17-0.9.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.9.0 · 1016.4KiB	PIGSTY 0.9.0 el10.aarch64.pg16 : pgvectorscale_16 pgvectorscale_16-0.9.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.9.0 · 1016.7KiB	PIGSTY 0.9.0 el10.aarch64.pg15 : pgvectorscale_15 pgvectorscale_15-0.9.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.9.0 · 1012.6KiB	PIGSTY 0.9.0 el10.aarch64.pg14 : pgvectorscale_14 pgvectorscale_14-0.9.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.9.0 · 1009.2KiB
d12.x86_64	PIGSTY 0.9.0 d12.x86_64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.9.0 · 888.7KiB	PIGSTY 0.9.0 d12.x86_64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.9.0 · 887.0KiB	PIGSTY 0.9.0 d12.x86_64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.9.0 · 886.8KiB	PIGSTY 0.9.0 d12.x86_64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.9.0 · 879.9KiB	PIGSTY 0.9.0 d12.x86_64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.9.0 · 876.1KiB
d12.aarch64	PIGSTY 0.9.0 d12.aarch64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.9.0 · 731.8KiB	PIGSTY 0.9.0 d12.aarch64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.9.0 · 731.4KiB	PIGSTY 0.9.0 d12.aarch64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.9.0 · 731.6KiB	PIGSTY 0.9.0 d12.aarch64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.9.0 · 726.2KiB	PIGSTY 0.9.0 d12.aarch64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.9.0 · 723.6KiB
d13.x86_64	PIGSTY 0.9.0 d13.x86_64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.9.0 · 889.0KiB	PIGSTY 0.9.0 d13.x86_64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.9.0 · 886.8KiB	PIGSTY 0.9.0 d13.x86_64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.9.0 · 886.5KiB	PIGSTY 0.9.0 d13.x86_64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.9.0 · 879.2KiB	PIGSTY 0.9.0 d13.x86_64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.9.0 · 876.8KiB
d13.aarch64	PIGSTY 0.9.0 d13.aarch64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.9.0 · 733.5KiB	PIGSTY 0.9.0 d13.aarch64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.9.0 · 731.7KiB	PIGSTY 0.9.0 d13.aarch64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.9.0 · 731.9KiB	PIGSTY 0.9.0 d13.aarch64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.9.0 · 727.0KiB	PIGSTY 0.9.0 d13.aarch64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.9.0 · 723.4KiB
u22.x86_64	PIGSTY 0.9.0 u22.x86_64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.9.0 · 987.5KiB	PIGSTY 0.9.0 u22.x86_64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.9.0 · 984.9KiB	PIGSTY 0.9.0 u22.x86_64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.9.0 · 985.1KiB	PIGSTY 0.9.0 u22.x86_64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.9.0 · 975.4KiB	PIGSTY 0.9.0 u22.x86_64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.9.0 · 970.8KiB
u22.aarch64	PIGSTY 0.9.0 u22.aarch64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.9.0 · 867.4KiB	PIGSTY 0.9.0 u22.aarch64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.9.0 · 865.5KiB	PIGSTY 0.9.0 u22.aarch64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.9.0 · 864.9KiB	PIGSTY 0.9.0 u22.aarch64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.9.0 · 857.7KiB	PIGSTY 0.9.0 u22.aarch64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.9.0 · 854.3KiB
u24.x86_64	PIGSTY 0.9.0 u24.x86_64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.9.0 · 976.6KiB	PIGSTY 0.9.0 u24.x86_64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.9.0 · 973.2KiB	PIGSTY 0.9.0 u24.x86_64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.9.0 · 975.1KiB	PIGSTY 0.9.0 u24.x86_64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.9.0 · 966.1KiB	PIGSTY 0.9.0 u24.x86_64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.9.0 · 960.7KiB
u24.aarch64	PIGSTY 0.9.0 u24.aarch64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.9.0 · 856.8KiB	PIGSTY 0.9.0 u24.aarch64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.9.0 · 854.4KiB	PIGSTY 0.9.0 u24.aarch64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.9.0 · 854.6KiB	PIGSTY 0.9.0 u24.aarch64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.9.0 · 849.4KiB	PIGSTY 0.9.0 u24.aarch64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.9.0 · 845.1KiB
u26.x86_64	PIGSTY 0.9.0 u26.x86_64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.9.0 · 973.2KiB	PIGSTY 0.9.0 u26.x86_64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.9.0 · 969.8KiB	PIGSTY 0.9.0 u26.x86_64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.9.0 · 968.7KiB	PIGSTY 0.9.0 u26.x86_64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.9.0 · 962.9KiB	PIGSTY 0.9.0 u26.x86_64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.9.0 · 958.6KiB
u26.aarch64	PIGSTY 0.9.0 u26.aarch64.pg18 : postgresql-18-pgvectorscale postgresql-18-pgvectorscale_0.9.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.9.0 · 855.8KiB	PIGSTY 0.9.0 u26.aarch64.pg17 : postgresql-17-pgvectorscale postgresql-17-pgvectorscale_0.9.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.9.0 · 853.1KiB	PIGSTY 0.9.0 u26.aarch64.pg16 : postgresql-16-pgvectorscale postgresql-16-pgvectorscale_0.9.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.9.0 · 853.5KiB	PIGSTY 0.9.0 u26.aarch64.pg15 : postgresql-15-pgvectorscale postgresql-15-pgvectorscale_0.9.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.9.0 · 846.2KiB	PIGSTY 0.9.0 u26.aarch64.pg14 : postgresql-14-pgvectorscale postgresql-14-pgvectorscale_0.9.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.9.0 · 842.6KiB

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:

Install

pig install pgvectorscale;          # Install for current active PG version

pig

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

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

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

vectorscale extends pgvector with the StreamingDiskANN index access method for approximate nearest-neighbor search. The example below creates a vector table, builds a diskann index, and runs a distance-ordered query.

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

vectorscale

Overview

Version

Build

Install

Usage

Was this page helpful?