Skip to content

Wikantik

Where information goes to live.

Tagged

hnsw

Architecture diagram of zero-downtime PostgreSQL and pgvector HNSW dual-index migration pipeline

Zero-Downtime Schema and pgvector Index Migrations on Live PostgreSQL

· Technology · 8 min read

How to evolve PostgreSQL tables and pgvector HNSW indexes in production without tripping lock queues, starving connection pools, or spilling graph builds to disk.