Development

Vector index tuning and rebuilds

• Choosing Between HNSW and IVFFlat After Your Data Grows
• pgvector at Scale: Vacuum, Reindexing and Index Rebuilds
• Tuning HNSW Parameters Against a Recall Target You Can Measure
• A Dual-Write Table So a Reindex Can Be Resumed
• A Second Vector Index Beside the First: Build, Validate, Cut Over
• Blue-Green Rebuilds for Vector Indexes: A Step-by-Step Cutover
• Choosing a pgvector Index Build for a Table You Cannot Lock
• Detecting Index Bloat with pg_stat and Vector Index Stats
• Measuring Recall Across Two Indexes on the Same Query Set
• pgvector Index Rebuilds Without Taking Search Offline
• Reading HNSW Memory and Build Time from Your Own Measurements
• Sizing a Shadow Index: Disk, Memory and Build Hours
• Sizing HNSW Parameters for Your Recall Target
• Vacuum, Reindex and Bloat on a Vector Index Under Write Load
• Warming a Vector Index for Low-Latency Search