php - Which is the best way to fetch records from table with > 10 million rows of data? -

i working postgres , php.

i have tens of millions of records in table , want hourly,monthly , yearly data table.

if select hour should result hourly records within selected range.

should implement views, temporary tables or else whatever useful better performance?

have created indexes on date columns?

if aggregating data report, create batch job populates aggregated fact table each night.