Skip site navigation (1) Skip section navigation (2)

Re: partition queries hitting all partitions even though check key is specified

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Kevin Kempter <kevink(at)consistentstate(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: partition queries hitting all partitions even though check key is specified
Date: 2010-07-13 04:00:48
Message-ID: 1278993648.22491.7.camel@jd-desktop.unknown.charter.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, 2010-07-12 at 22:01 -0500, Josh Berkus wrote:
> On 9/2/09 10:05 AM, Kevin Kempter wrote:
> > On Wednesday 02 September 2009 09:02:27 Scott Marlowe wrote:
> >> On Wed, Sep 2, 2009 at 8:52 AM, Kevin Kempter<kevink(at)consistentstate(dot)com> 
> > wrote:
> >>> Hi all;
> >>>
> >>> I cant figure out why we're scanning all of our partitions.
> 
> I don't think extract() is immutable, which would pretty much invalidate
> your check constraints as far as CE is concerned.

Correct.

Joshua D. Drake


-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering


In response to

pgsql-performance by date

Next:From: kangayarkanniDate: 2010-07-13 05:52:36
Subject: Who are you voting for?
Previous:From: Josh BerkusDate: 2010-07-13 03:01:08
Subject: Re: partition queries hitting all partitions even though check key is specified

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group