title: PostgreSQL Full Text Search with substrings
body: <p>I'm trying to create the fastest way to search millions (80+ mio) of records in a PostgreSQL (version 9.4), over multiple columns.</p>
  
  <p>I would like to try and use standard PostgreSQL, and not Solr etc.</p>
  
  <p>I'm currently testing Full Text Search followed <a href="https://blog.lateral.io/2015/05/full-text-search-in-milliseconds-with-postgresql/" rel="nofollow noreferrer">https://blog.lateral.io/2015/05/full-text-search-in-milliseconds-with-postgresql/</a>.</p>
  
  <p>It works, but I would like some more flexible way to search.</p>
  
  <p>Currently, if I have a column containing ex. "Volvo" and one containing "Blue" I am able to find the record with the search string "volvo blue", but I would like to also find the record using "volvo blu" as if I used LIKE and "%blu%'.</p>
  
  <p>Is that possible with full text search?</p>