Thoughts on the state of Postgres indexing in 2026

Some notes on vector databases 102 based on recent work.

Checklist

1. Define success metrics
2. Keep the first version simple
3. Add observability early
4. Document decisions

If you’ve shipped something similar, what would you do differently?