pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Simon Riggs <simon@2ndQuadrant.com>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: Vincenzo Romano <vincenzo.romano@notorand.it>
Cc: pgsql-hackers@postgresql.org
Subject: Re: On Scalability
Date: Thu, 07 Oct 2010 08:41:30 +0100
Message-ID: <1286437290.2304.192.camel@ebony> (raw)
In-Reply-To: <4CAD769D.9090301@enterprisedb.com>
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>

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




view thread (45+ messages)  latest in thread

Message-ID: <1286437290.2304.192.camel@ebony>
Permalink:  ../1286437290.2304.192.camel@ebony/
Also on:    postgresql.org/message-id/1286437290.2304.192.camel@ebony

 · 

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: simon@2ndQuadrant.com, heikki.linnakangas@enterprisedb.com, vincenzo.romano@notorand.it, pgsql-hackers@postgresql.org
  Subject: Re: On Scalability
  In-Reply-To: <1286437290.2304.192.camel@ebony>

* 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