Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 631D9133616B for ; Thu, 7 Oct 2010 04:41:45 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 33795-03 for ; Thu, 7 Oct 2010 07:41:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail148110.authsmtp.com (outmail148110.authsmtp.com [62.13.148.110]) by mail.postgresql.org (Postfix) with ESMTP id 7A4CE1337C05 for ; Thu, 7 Oct 2010 04:41:37 -0300 (ADT) Received: from mail-c194.authsmtp.com (mail-c194.authsmtp.com [62.13.128.121]) by punt7.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o977fX8Q020907; Thu, 7 Oct 2010 08:41:33 +0100 (BST) Received: from [10.10.10.158] (static.kpn.net [194.45.240.105] (may be forged)) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id o977fVHo073717; Thu, 7 Oct 2010 08:41:31 +0100 (BST) Subject: Re: On Scalability From: Simon Riggs To: Heikki Linnakangas Cc: Vincenzo Romano , pgsql-hackers@postgresql.org In-Reply-To: <4CAD769D.9090301@enterprisedb.com> References: <1280423526.8613.36.camel@jd-desktop.unknown.charter.com> <1280425184.8613.41.camel@jd-desktop.unknown.charter.com> <1280427410.8613.44.camel@jd-desktop.unknown.charter.com> <4CAD769D.9090301@enterprisedb.com> Content-Type: text/plain; charset="UTF-8" Date: Thu, 07 Oct 2010 08:41:30 +0100 Message-ID: <1286437290.2304.192.camel@ebony> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 Content-Transfer-Encoding: 7bit X-Server-Quench: 4da6cadd-d1e6-11df-80b9-0022640b883e X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFaAJbYlpF HGQLWlREUFV7XWJ/ aAsfbAxZfE5LQQdu UFZIQldNEQ1vHhxP WRcZVU8UD1pGf313 ZEEsXXlfXgp+IRd7 ER8AQXBSZDJmdWEe BBZFfwMGeR5Kfh1H bFR/BnsFYjBJBC9q VzwTFhsSEA9kHWxy REk2JlsWSEwKGj8g Vnj6 X-Authentic-SMTP: 61633235383639.1015:706 X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.131 tagged_above=-5 required=5 tests=BAYES_40=-0.001, MAY_BE_FORGED=2.132, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: ** X-Archive-Number: 201010/421 X-Sequence-Number: 171461 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? -- Simon Riggs www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Training and Services