{"schemaVersion":1,"id":"postgresql-pgvector","revision":"2026-09-14.1","name":"PostgreSQL + pgvector","monogram":"P+","category":"Composition","openness":"Open source","license":"PostgreSQL and pgvector licenses","color":"#64cdb5","summary":"Vector retrieval alongside relational application data.","website":"https://github.com/pgvector/pgvector","repository":"https://github.com/pgvector/pgvector","environment":"Self-managed","contributor":"Testedknowhow database research","affiliation":"Commissioned by a Nimbalyst maintainer. Documentation synthesis; no independent review or product execution.","contentLicense":"Unlicensed prototype; redistribution decision pending","reviewStatus":"unreviewed","lastChecked":"2026-09-14","expiresAt":"2026-10-14","applicability":{"versions":["Unpinned upstream documentation accessed 2026-09-14; pin engine, extension and service versions before use."],"environment":"PostgreSQL plus an installed and enabled pgvector extension; operator manages both.","excludes":["Runtime verification","Workload benchmarks and cost comparisons","Unlisted extensions, service tiers and deployment configurations"]},"database":{"models":["Relational","Vector"],"deployment":"Self-managed","kind":"Composition","components":["postgresql"],"boundary":"PostgreSQL plus an installed and enabled pgvector extension; operator manages both.","evidenceIds":["postgresql-pgvector-s0","postgresql-pgvector-s1"]},"claims":[{"id":"postgresql-pgvector-db-sql","capability":"db-sql","statement":"Uses Postgres SQL and joins.","method":"documented","outcome":"claimed","scope":"Documented for this target; no runtime tests recorded.","evidenceIds":["postgresql-pgvector-s0"],"contradictions":[],"support":"yes"},{"id":"postgresql-pgvector-db-vector","capability":"db-vector","statement":"Supports exact vector-distance search.","method":"documented","outcome":"claimed","scope":"Documented for this target; no runtime tests recorded.","evidenceIds":["postgresql-pgvector-s0"],"contradictions":[],"support":"yes"},{"id":"postgresql-pgvector-db-ann","capability":"db-ann","statement":"Provides HNSW and IVFFlat approximate indexes.","method":"documented","outcome":"claimed","scope":"Documented for this target; no runtime tests recorded.","evidenceIds":["postgresql-pgvector-s0"],"contradictions":[],"support":"yes"},{"id":"postgresql-pgvector-db-filter","capability":"db-filter","statement":"Combines vector queries with SQL WHERE filtering.","method":"documented","outcome":"claimed","scope":"Approximate-index filtering can reduce returned results; tune scan settings and verify recall.","evidenceIds":["postgresql-pgvector-s0"],"contradictions":[],"support":"yes"},{"id":"postgresql-pgvector-db-transactions","capability":"db-transactions","statement":"Retains Postgres transactional semantics.","method":"documented","outcome":"claimed","scope":"Documented for this target; no runtime tests recorded.","evidenceIds":["postgresql-pgvector-s0"],"contradictions":[],"support":"yes"}],"evidence":[{"id":"postgresql-pgvector-s0","url":"https://github.com/pgvector/pgvector","title":"pgvector README","locator":"Introduction; installation; indexing; filtering","capturedAt":"2026-09-14","kind":"repository","revision":null,"redistribution":"Link and original paraphrase only; upstream rights retained."},{"id":"postgresql-pgvector-s1","url":"https://www.postgresql.org/about/","title":"PostgreSQL overview","locator":"Data types; transactions; recovery; security","capturedAt":"2026-09-14","kind":"vendor-documentation","revision":null,"redistribution":"Link and original paraphrase only; upstream rights retained."}],"gaps":["Which pinned versions, topology and service tier fit the intended workload?","What are measured correctness, latency, recovery and total operating cost under that workload?"],"invalidationTriggers":["Upstream version, license, API, service plan or storage topology changes."],"verificationPlan":["Pin the target configuration and define workload fixtures, access and budget.","With authorization, test concurrent writes and recovery against explicit correctness expectations.","For vector workloads, measure filtered recall against an exact-search baseline and record index settings."],"attestations":[]}