Schedule - pgDay Paris 2025
Distributed vector database with aidb and PGD
Date: 2025-03-20
Time: 11:40–12:00
Room: Karnak
It is common knowledge that a single database server can only scale vertically, and as the Eiffel tower - no matter how impressive it is - vertical scalability is limited. Therefore, if we want to use our beloved PostgreSQL with pgvector as a vector database, we need to anticipate this limitation because the amount of data that will be stored is really massive. In fact, searches can become so slow that applications and indexes are designed to work with approximate searches in order to return good enough results in a reasonable amount of time. Based on Bi-Directional replication, Postgres Distributed (PGD) gives us the ability to build an architecture that can scale the retrieval of results horizontally. In addition, EDB has enhanced the capabilities of pgvector by creating aidb, an extension that simplifies the embedding of data, and the retrieval of results. This talk will cover the challenges, possibilities, advantages, and disadvantages of combining pgvector and aidb with PGD.