Anyone tried any of the alternative full-text search extensions mentioned?
Zombodb sounds good, except I would like that it didn’t work synchronously and fail transactions if there is a network error talking to ElasticSearch.
I think most people will use Postgres’ built in FTS up until a point or go straight to an application level integration with ElasticSearch.
SQLite's FTS5 is really killer, and best still, in-built, compared to PostgreSQL's need for all these other plugins. Consider that before moving to PostgreSQL.