Re: On Scalability

On 07.10.2010 10:41, Simon Riggs wrote:
> On Thu, 2010-10-07 at 10:28 +0300, Heikki Linnakangas wrote:
>
>> constraint exclusion of CHECK constraints on the partitions is
>> exponential
>
> Constraint exclusion is linear with respect to number of partitions.
> Why do you say exponential?

For some reason I thought the planner needs to check the constraints of 
the partitions against each other, but you're right, clearly that's not 
the case. Linear it is.

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