PostgreSQL pgvector Hybrid Search for Web Apps
AI-generated summary PostgreSQL hybrid search using the open-source pgvector extension combines lexical search and vector retrieval against the same table. The text vector recomputes on every write to prevent drift from the content.