We used to use Postgres for almost everything, including full-text search. Later when we needed a bit more control over search, we started using Elasticsearch.

We used to use Postgres for almost everything, including full-text search. Later when we needed a bit more control over search, we started using Elasticsearch. The way we do it now is to perform joins and get a nice serialized object with all the possible search/filter/sort fields, and put it in ES. All the data still remains in postgres, though.