title: What is the best way to sync Postgres and ElasticSearch?
body: <p>I have the choice to Sync ES with latest changes on my Postgres DB</p>
  
  <p>1- Postgres Listen / Notify :</p>
  
  <p>I should create a <code>trigger</code> -> use <code>pg_notify</code> -> and create listener in a separated service.</p>
  
  <p>2- Async queries to ES : </p>
  
  <p>I can update ElasticSearch asynchronously after a change on DB. ie:</p>
  
  <p><code>model.save().then(() =&gt; {model.saveES() }).catch()</code></p>
  
  <p>Which one will scale best ? </p>
  
  <p>PS: We tried <code>zombodb</code> in production but it doesn’t goes well, it slows down the production.</p>