New · France 2027 presidential election: what the candidates propose on AI, quoted and sourced. Explore the tracker →

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 (external resource)

Sources

  1. Efficient and robust approximate nearest neighbor search using HNSW graphs, Malkov & Yashunin, arXiv:1603.09320, 2016. https://arxiv.org/abs/1603.09320 (accessed 2026-05-24)
  2. What is a Vector Database & How Does it Work?, Pinecone, 2023. https://www.pinecone.io/learn/vector-database/ (accessed 2026-05-24)
  3. Pinecone pricing, 2026. https://www.pinecone.io/pricing/ (accessed 2026-10-14)
  4. 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/ (accessed 2026-10-14)
  5. Weaviate Cloud pricing, 2026. https://weaviate.io/pricing (accessed 2026-10-14)
  6. 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/ (accessed 2026-10-14)

Editorial methodCorrections log

← Back to glossary

Address copied