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.
Category
Databases
Postgres first, always — indexes, query plans, full-text search.
1 post