PostgreSQL(Full Text Search) vs ElasticSearch : <p>Hi I am doing some research before I implement search feature into my service. 
I'm currently using PostgreSQL as my main storage. I could definitely use PostgreSQL's built-in Full-Text-Search but the problem is that I have data scattered around several tables. </p>

<p>My service is an e-commerce website. So if a customer searches "good apple laptop", I need to join <code>Brand</code> table, <code>post</code> table and <code>review</code> table(1 post is a combination of several reviews + short summary) to fully search all posts. If I were to use elasticsearch, I could insert complete posts by preprocessing.</p>

<p>From my research, some people said PostgreSQL's FTS and elasticsearch have similar performance and some people said elasticsearch is faster. Which would be better solution for my case?</p>

<p>Thanks in advance</p>
