pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Vincenzo Romano <vincenzo.romano@notorand.it>
Cc: pgsql-hackers@postgresql.org
Subject: Re: On Scalability
Date: Thu, 07 Oct 2010 10:51:09 +0300
Message-ID: <4CAD7BED.4050009@enterprisedb.com> (raw)
In-Reply-To: <1286437290.2304.192.camel@ebony>
References: <AANLkTi=6=WRpND-MXv92D-+iC9AnYDwLsbbXMXj4uNky@mail.gmail.com>
	<1280423526.8613.36.camel@jd-desktop.unknown.charter.com>
	<AANLkTikV96eAFxEuqk4k6jadtDomLhnJrwqtEh3mNKs6@mail.gmail.com>
	<1280425184.8613.41.camel@jd-desktop.unknown.charter.com>
	<AANLkTim7HQQz=qGfW=xDhx-8HNppYxXF48NjnU2-XiNt@mail.gmail.com>
	<1280427410.8613.44.camel@jd-desktop.unknown.charter.com>
	<AANLkTimSGghp4TseAV-zgNYakkyH3J_jW2k8peL7EOTv@mail.gmail.com>
	<4CAD769D.9090301@enterprisedb.com>
	<1286437290.2304.192.camel@ebony>

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

view thread (45+ messages)  latest in thread

Message-ID: <4CAD7BED.4050009@enterprisedb.com>
Permalink:  ../4CAD7BED.4050009@enterprisedb.com/
Also on:    postgresql.org/message-id/4CAD7BED.4050009@enterprisedb.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: heikki.linnakangas@enterprisedb.com, simon@2ndQuadrant.com, vincenzo.romano@notorand.it, pgsql-hackers@postgresql.org
  Subject: Re: On Scalability
  In-Reply-To: <4CAD7BED.4050009@enterprisedb.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox