Last reviewed:
What is a vector database? Definition and business implications
A vector database is a database specialised in the storage and retrieval of vectors (embeddings). It allows, for a given query, finding the most semantically close content in a corpus, without exact lexical match. It is the typical search engine of a RAG system.
A vector database stores embeddings, that is, numerical representations (typically 768 to 3,072 dimensions) of the meaning of the indexed documents. When a query arrives, it is converted into an embedding, and the database searches for the closest vectors using a similarity measure (cosine, dot product). To scale, these databases use approximate algorithms (ANN, approximate nearest neighbors) such as HNSW or IVF, which sacrifice marginal precision for response times in milliseconds on billions of vectors. The market in 2026 includes three categories. Pure specialised actors: Pinecone, Weaviate, Qdrant, Milvus. Relational database extensions: pgvector for PostgreSQL, the native VECTOR type of Azure SQL (generally available since June 2025). Multi-model databases: MongoDB, Elasticsearch, Redis, which have integrated vector search. The choice depends on team maturity, volume, and the need to combine vector search with classic structured search.
Concrete example
Illustrative case. A 150-employee law firm indexes 80,000 historical legal acts to allow its partners to query its own internal case law. Three technical options compared. A managed service such as Pinecone, which has offered a Frankfurt region since May 2026 (Standard plan from 50 dollars per month). An open-source managed service such as Weaviate Cloud (Flex plan from 45 dollars per month), whose hosting region must be checked. pgvector on the internal PostgreSQL: no extra service to pay for if the DBMS already exists, full control, but operations are left to the team. The firm chose pgvector for sovereignty and cost control, despite a longer setup.
FAQ
What is a vector database?
It is a database specialised in storing and retrieving vectors, called embeddings. For a given query, it finds the content closest in meaning within a corpus, without requiring an exact word match. It is the typical search engine of a RAG system.
How does the search work?
Each document is represented by an embedding, a string of numbers (typically 768 to 3,072 dimensions) that encodes its meaning. The query is also turned into an embedding, and the database looks for the closest vectors using a similarity measure. To scale to billions of vectors, it uses approximate algorithms such as HNSW or IVF, which respond in milliseconds.
Do we need a specialised actor like Pinecone?
Not always. Below a few million vectors, an extension such as pgvector on PostgreSQL or a multi-model database (MongoDB Atlas, Elasticsearch) is often enough, at a much lower cost. A specialised actor is justified only beyond that, depending on volume and team maturity.
How does the choice of database touch on sovereignty?
Because when you handle confidential internal documents, the jurisdiction of hosting matters as much as technical performance. For a law firm indexing 80,000 acts, the options ranged from a managed service such as Pinecone (Frankfurt region since May 2026) or Weaviate Cloud to internal pgvector; the firm chose pgvector for sovereignty and cost control.
What should we watch on cost?
The billing structure. SaaS offerings generally combine a monthly minimum (Pinecone Standard: 50 dollars per month) with pay-as-you-go billing for storage, reads and writes, so cost depends as much on query volume as on stored volume. A benchmark at your target volume avoids unpleasant surprises on the bill.
See also
Further reading
Efficient and robust approximate nearest neighbor search using HNSW, Malkov & Yashunin, 2016
Sources
- Efficient and robust approximate nearest neighbor search using HNSW graphs, Malkov & Yashunin, arXiv:1603.09320, 2016. https://arxiv.org/abs/1603.09320
- What is a Vector Database & How Does it Work?, Pinecone, 2023. https://www.pinecone.io/learn/vector-database/
- Pinecone pricing, 2026. https://www.pinecone.io/pricing/
- Pinecone expands in Europe with a new Frankfurt cloud region, 5 May 2026. https://www.pinecone.io/newsroom/Pinecone-Expands-in-Europe-with-New-Frankfurt-Cloud-Region/md/
- Weaviate Cloud pricing, 2026. https://weaviate.io/pricing
- Native vector type in Azure SQL, general availability, June 2025. https://devblogs.microsoft.com/azure-sql/announcing-general-availability-of-native-vector-type-functions-in-azure-sql/