PostgreSQL
General-purpose relational database, and a vector store through an extension.
Overview
PostgreSQL is a relational database whose extension mechanism lets vector search live in the same system as the data it filters on. It solves the problem that retrieval usually means running a second datastore beside the one holding the application's real data, with consistency and filtering spread across both. It exists in an AI stack because pgvector makes "one database" a real option rather than a simplification.
Technology Graph
How PostgreSQL connects to the rest of the stack.
Applied to
- AI Search application Applications PostgreSQL used for AI Search High ✓ source
- RAG technique Techniques PostgreSQL used for RAG High ✓ source
Classification
- pgvector library Vector Databases pgvector part of PostgreSQL High ✓ source