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

From bricklen
Subject Re: partition queries hitting all partitions even though check key is specified
Date
Msg-id 33b743250909020816w44c4cb0r5ec9f5b9d168cc27@mail.gmail.com
Whole thread Raw
In response to Re: partition queries hitting all partitions even though check key is specified  (Kevin Kempter <kevink@consistentstate.com>)
List pgsql-performance
On Wed, Sep 2, 2009 at 8:05 AM, Kevin Kempter <kevink@consistentstate.com> wrote:

> > the explain plan shows most any query scans/hits all partitions even if
> > we specify the partition key:
> >
> > explain select * from pwreport.url_hits where "time" >
> > date_part('epoch'::text, '2009-08-12'::timestamp without time
> > zone)::integer; QUERY PLAN


Does the plan change if you use a hard-coded timestamp in your query?

pgsql-performance by date:

Previous
From: Kevin Kempter
Date:
Subject: Re: partition queries hitting all partitions even though check key is specified
Next
From: Greg Jaman
Date:
Subject: Re: partition queries hitting all partitions even though check key is specified