db/init/02_indexes.sql

CREATE INDEX IF NOT EXISTS idx_documents_embedding_cosine
ON documents USING ivfflat (embedding vector_cosine_ops)
WITH (lists = 100);

ANALYZE documents;