vectorscale

pig build get vectorscale; # get vectorscale source code
pig build dep vectorscale; # install build dependencies
pig build pkg vectorscale; # build extension rpm or deb
pig build ext vectorscale; # build extension rpms

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

pig ext install vectorscale; # install by extension name, for the current active PG version
pig ext install pgvectorscale; # install via package alias, for the active PG version
pig ext install vectorscale -v 18;   # install for PG 18
pig ext install vectorscale -v 17;   # install for PG 17
pig ext install vectorscale -v 16;   # install for PG 16
pig ext install vectorscale -v 15;   # install for PG 15
pig ext install vectorscale -v 14;   # install for PG 14
pig ext install vectorscale -v 13;   # install for PG 13

CREATE EXTENSION vectorscale;

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