All things you mentioned can be done in PGSQL with similar performance, actually. I have to build a search product in PGSQL, and I’ve done exactly that (and co

All things you mentioned can be done in PGSQL with similar performance, actually. I have to build a search product in PGSQL, and I’ve done exactly that (and compared it with ES, Solr and Lucene). For datasets below 50GB the performance is basically the same, you get about the same features, and it works well enough. But you are right, as soon as you want to build more complicated search products, or as soon as you get larger amounts of data, you want a dedicated solution.