title: Indexes on text columns in postgres
body: <p>I need an index on some text columns to increase spped of queries. I not really sure whether I can use FTS or not. I have in my column something like that:
  34565A43B2423FRR34AQ and I am searching in that way:</p>
  
  <pre><code>WHERE column ~* '5A43B'
  </code></pre>
  
  <p>and I'm expecting that this value will be found. But the table is big (about million rows) and the time is not efficient. What kind of index I can use?</p>