Postgres Pro
Downloads
Home   >   mailing lists

Re: Planner statistics, correlations - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: Planner statistics, correlations
Date
Msg-id 45A765DE.9020003@enterprisedb.com
Whole thread Raw
In response to Re: Planner statistics, correlations  (Tobias Brox <tobias@nordicbet.com>)
Responses Re: Planner statistics, correlations
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Tobias Brox
Date:
Subject: Re: Planner statistics, correlations
Next
From: Tobias Brox
Date:
Subject: Re: Planner statistics, correlations