Learn how to scale and optimize pgvector queries using indexing, tuning search parameters, monitoring database performance, and running queries using these indexes.
Overview
Syllabus
- Unit 1: Understanding and Managing Indexes in pgvector
- Finding Vector Indexes in Products
- Unit 2: Inspecting Table and Indexes in pgvector
- Checking Table Size in PostgreSQL
- Exploring Index Details in PostgreSQL
- Index Usage Insights for Products Table
- Unit 3: Tuning and Running Queries with Approximate Indexes in pgvector
- Tuning IVFFlat Index Probes
- Tuning HNSW Index for Vector Search
- Comparing IVFFlat and HNSW Queries