A practical two day technical course for participants who are new to pgvector and want to add vector search capabilities directly to PostgreSQL. The agenda progresses from extension setup, vector data types, embeddings, and SQL similarity queries through HNSW and IVFFlat indexing, filtering, query optimization, Python integration, semantic search, and RAG applications. The course focuses on combining familiar relational database capabilities with efficient vector retrieval.
You will learn how pgvector extends PostgreSQL with vector storage, similarity operators, and approximate nearest-neighbor indexing. You will work with embeddings, SQL vector queries, HNSW and IVFFlat indexes, filtering, execution plans, and performance tuning. You will also learn how to integrate pgvector with Python applications and use PostgreSQL as the retrieval layer for semantic search and RAG systems.
*We customize the course outline and content to your specific needs and relevant use cases.
Module 1: pgvector architecture and setup
Module 2: Embeddings and SQL vector queries
Module 3: HNSW and IVFFlat indexing
Module 4: Filtering and query optimization
Module 5: Python integration with pgvector
Module 6: Building semantic search applications
Module 7: pgvector in RAG architectures
Module 8: Performance and production considerations
Hands-on learning with expert instructors at your location for organizations.
Master new skills guided by experienced instructors from anywhere.
Can't find a suitable date? Get in touch and we'll arrange one that works for you.