title: PostgreSQL accent + case insensitive search
body: <p>I'm looking for a way to support with good performances case insensitive + accent insensitive search. Till now we had no issue on this using MSSql server, on Oracle we had to use <code>OracleText</code>, and now we need it on PostgreSQL.</p>
  <p>I've found <a href="https://stackoverflow.com/questions/11005036/does-postgresql-support-accent-insensitive-collations/11007216#11007216">this post</a> about it, but we need to combine it with case insensitive. We also need to use indexes, otherwise performances could be impacted.
  Any real experience about the best approach for large databases?</p>