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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers