Tobias Brox wrote:
Maybe it would help to partitionate the table every year?

I thought about partitioning the table by state, putting rows with state=4 into one partition, and all others to another partition.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to