VectorDB Patterns

Expert patterns for HNSW index tuning, pgvector setup, Pinecone/Qdrant upsert, metadata filtering, multi-tenancy, and embedding drift management.

Pattern 1: pgvector Setup with HNSW Index

PostgreSQL vector search with proper index configuration.

-- Install extension (requires PostgreSQL 15+ with pgvector)
CREATE EXTENSION IF NOT EXISTS vector;