May 6, 2025May 6, 2025Design Patterns, Ruby Optimizing pg_search with precomputed tsvector columns in Postgres TLDR: If your pg_search queries are slow due to joins and dynamic tsvector generation, precompute a weighted search_vector column and index it. […]