Comparing Native Postgres, ElasticSearch, and pg_search for Full-Text Search

Implementing text search in Postgres is trivial. You can do it as simply as this: But like most simple things in SQL, it’s only simple when your data is simple—when you hit anything approaching scale, the simple things become hard. Full-text search is precisely one of these cases. While a basic ILIKE query works fine […]