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

From: bricklen <bricklen(at)gmail(dot)com>
To: Kevin Kempter <kevink(at)consistentstate(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: partition queries hitting all partitions even though check key is specified
Date: 2009-09-02 15:16:28
Message-ID: 33b743250909020816w44c4cb0r5ec9f5b9d168cc27@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Sep 2, 2009 at 8:05 AM, Kevin Kempter <kevink(at)consistentstate(dot)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?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Jaman 2009-09-02 15:17:27 Re: partition queries hitting all partitions even though check key is specified
Previous Message Kevin Kempter 2009-09-02 15:05:56 Re: partition queries hitting all partitions even though check key is specified