Dave Weaver wrote:
Supposing obs_pkey is on (station, valid_time):- clustering the "obs" table on "station"
Sorry, I don't understand what you mean by this - can you explain?
cluster obs_pkey on obs
will re-order the rows in obs based on the index obs_pkey. (This is clustering on 'station' and 'valid_time', to do just station you could use an index on just 'station').
The down side is that the row ordering is slowly lost as rows are updated, so periodic running of the cluster command is needed - this is a pain as it will take a while for 13 million row table.
regards
Mark
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
