title: Hasura Timeout, Queries with Inconsistent speed Issues
body: <p>I have a table with 2 millions of data in it, lets say I search for user email Id(using _ilike), it takes more than 15 to 20 seconds (or sometime I get Timeout error) to respond with out indexing. With indexing I get within a second(still there are times where it takes 15 to 20s, let say 2 out of 10 times I have this delay).</p>
  <p>Now the question following are the question I have,</p>
  <ol>
  <li>There is timeout most of the time when we search for mail id which is not present in the table, why is that? Whether this is expected behavior?</li>
  <li>How much space/configuration of the DB does Hasura is expected to have for approximate 2 millions data?</li>
  <li>Whether btree indexing is better for _ilike searchs or gin indexing is the better solution?</li>
  <li>Any more suggestions to improve the performance of the query other than indexing?</li>
  <li>Even the basic query to get the count of the rows is pretty slow, is there a way to improve?</li>
  </ol>
  <blockquote>
  <pre><code>`userTable_aggregate {
              aggregate {
                count    
              }    
            }`
  </code></pre>
  </blockquote>
  <p>Note: Every one hour data is getting added to the userTable(lets 100 approximate).
  Thank you for taking time to answer my questions</p>