title: Is there a way to index in postgres for fast substring searches
body: <p>I have a database and want to be able to look up in a table a search that's something like:
  select * from table where column like "abc%def%ghi"
  or
  select * from table where column like "%def%ghi"
  Is there a way to index the column so that this isn't too slow?</p>
  
  <p>Edit:
  Can I also clarify that the database is read only and won't be updated often.</p>