pgvector Optimization

Skill Resources

• Activation and cross-agent notes: references/activation.md
• Use ultrathink or the deepest available reasoning mode before changing architecture, security, migration, or performance-critical paths.
• Template: templates/index-tuning-record.md

pgvector with default settings gives you correct results but not optimal performance. The gap between default and tuned can be 10–100x in query speed and 4–8x in memory usage. This skill covers what to tune and when.

HNSW vs. IVFFlat: Choosing the Right Index