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