title: Huge PostgreSQL table - Select, update very slow
body: <p>I am using PostgreSQL 9.5. I have a table which is almost 20GB's. It has a primary key on the ID column which is an auto-increment column, however I am running my queries on another column which is a timestamp... I am trying to select/update/delete on the basis of a timestamp column but the queries are very slow. For example: A select on this table `where timestamp_column::date (current_date - INTERVAL '10 DAY')::date) is taking more than 15 mins or so..
  Can you please help on what kind of Index should I add to this table (if needed) to make it perform faster?</p>
  
  <p>Thanks</p>