pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: partition queries hitting all partitions even though check key is specified
2+ messages / 2 participants
[nested] [flat]
* Re: partition queries hitting all partitions even though check key is specified
@ 2010-07-13 03:01 Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 2+ messages in thread
From: Josh Berkus @ 2010-07-13 03:01 UTC (permalink / raw)
To: Kevin Kempter <kevink@consistentstate.com>; +Cc: pgsql-performance
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.
I suggest feeding the actual numeric values to the check constraints.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: partition queries hitting all partitions even though check key is specified
@ 2010-07-13 04:00 Joshua D. Drake <jd@commandprompt.com>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 2+ messages in thread
From: Joshua D. Drake @ 2010-07-13 04:00 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: Kevin Kempter <kevink@consistentstate.com>; 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-07-13 04:00 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-07-13 03:01 Re: partition queries hitting all partitions even though check key is specified Josh Berkus <josh@agliodbs.com>
2010-07-13 04:00 ` Joshua D. Drake <jd@commandprompt.com>
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