title: Postgres Select ILIKE %text% is Slow On Large String Rows
body: <p>I have a table which have only 7 columns and one of that column stores long text data for every row. Average character length for that text column data is approximately 1500 characters. And this table got 500.000 rows.</p>
  <p>When I use a select query and not take that text column with it, there is no problem, query takes 10 secs as expected.</p>
  <p>But if I add this long text column to my query like <code>Select * from table_1</code> it takes 3 or 4 minutes to complete this query and fill datatable with dataadapter.</p>
  <p>And why I need to lookup all that long text column records? Because I need to use text filter on it like:</p>
  <pre><code>SELECT * 
  FROM table_1 
  WHERE longtextcolumn ILIKE ANY (ARRAY['%texttosearch1%', '%texttosearch2%'])
  </code></pre>
  <p>What should I do to speed up that progress? Table partitioning could solve this speed issue? Or should I look for indexing?</p>