Re: partition queries hitting all partitions even thoughcheck key is specified - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: partition queries hitting all partitions even thoughcheck key is specified
Date
Msg-id 1278993648.22491.7.camel@jd-desktop.iso-8859-1.charter.com
Whole thread Raw
In response to Re: partition queries hitting all partitions even though check key is specified  (Josh Berkus <josh@agliodbs.com>)
List 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@consistentstate.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


pgsql-performance by date:

Previous
From: damien hostin
Date:
Subject: Re: Slow query with planner row strange estimation
Next
From: Elias Ghanem
Date:
Subject: Queries with conditions using bitand operator