Keyword search returns exact matches but misses intent. pgvector brings vector similarity search into PostgreSQL, letting you find documents by meaning instead of string overlap. Here is the schema, indexing, and query patterns you need in production.