Which PostgreSQL extension adds vector similarity search?
Why A is the answer
pgvector
Microsoft says pgvector adds open-source vector similarity search to PostgreSQL.
In detail
- pgvector adds vector similarity search.
- It stores vectors beside your relational data.
Use case
An illustrative scenario, not a real incident.
A team adds vector search to its PostgreSQL database by enabling pgvector, with no new database.
See it in different ways
flowchart LR A["Text"] --> B["Embedding model"] B --> C["Vector stored with the item"] D["Query embedding"] --> E["Similarity search"] C --> E E --> F["Closest items"]
stateDiagram-v2 [*] --> SequentialScan: no vector index SequentialScan --> AddIndex: slow on large tables AddIndex --> ApproximateSearch: HNSW ApproximateSearch --> ReviewResources: memory is short ReviewResources --> ApproximateSearch
flowchart LR S0["Enable pgvector"] --> S1["Add vector column"] --> S2["Query by similarity"]
Key point: pgvector adds vector search to PostgreSQL.
Why the other options are wrong
- B. PostGIS
- PostGIS is for geographic data.
- C. pg_cron
- pg_cron schedules jobs.
- D. pg_stat_statements
- That extension tracks query statistics.