Databases Postgres full-text search is enough Before you add Elasticsearch to a blog with four hundred posts, try a generated tsvector, a GIN index and websearch_to_tsquery. It handles phrase queries, ranking and stemming out of the box. 9 Oct 2026 · 2 min read ·147 views