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