title: Search in huge table
body: <p>I got table with over 1 millions rows.
  This table represents user information, e.g userName, email, gender, marrial status etc.</p>
  
  <p>I'm going to write search over all rows in this table, when some conditions are applied.</p>
  
  <p>In simples case, when search is perfomed only on userName, it takes over 4-7 seconds to find result.</p>
  
  <pre><code>select from u where u.name ilike " ... "
  </code></pre>
  
  <p>Yes, i got indexes over some fileds. I checked that they are applied using explain analyse command.</p>
  
  <p>How search can be boost ?</p>
  
  <p>I heart something about Lucene, can it help ?</p>
  
  <p>I'm wondering how does Facebook search working, they got billions users and their search works much faster.</p>