Recommended way to index a date field in postgres?
<p>I have a few tables with about 17M rows that all have a date column I would like to be able to utilize frequently for searches. I am considering either just throwing an index on the column and see how things go or sorting the items by date as a one time operation and then inserting everything into a new table so that the primary key ascends as the date ascends.</p>

<p>Since these are both pretty time consuming I thought it might be worth it to ask here first for input.</p>

<p>The end goal is for me to load sql queries into pandas for some analysis if that is relevant here.</p>