Schedule - PGConf.DE 2024
Bringing Vectors to Postgres
Date: 2024-04-12
Time: 11:20–12:05
Room: Ballsaal 2
Level: Intermediate
Postgres does not yet have native vector capabilities (as of Postgres 16) and pgvector is designed to fill this gap. You can store your vector data alongside the rest of your data in Postgres and do vector similarity search while still utilizing all the great features Postgres provides.
The pgvector extension integrates seamlessly with Postgres – allowing users to leverage its capabilities within their existing database infrastructure. This simplifies the deployment and management of AI applications, as there's no need for separate data stores or complex data transfer processes.
In this talk, we will learn how to generate and store vector embeddings in Postgres. We will discuss indexing (IVFFlat, HNSW) the embedding data and illustrate how to run a similarity query on our embeddings.