title: Autocomplete getting data from a huge table
body: <p>I need to do an autocomplete functionality and need to do something like this:</p>
  
  <pre><code>select field from huge_table where field like '%some string%';
  </code></pre>
  
  <p>The table is 2 million rows, and I need quick and several responses from it.
  We are using Postgres. And that kind of query will take forever.</p>
  
  <p>Is there an efficient way for doing this with postgres? Or maybe should I be using some other thing than postgres?</p>
  
  <p>Thanks!</p>