On Wed, Sep 2, 2009 at 8:05 AM, Kevin Kempter <kevink@xxxxxxxxxxxxxxxxxxx> wrote:
> > zone)::integer; QUERY PLAN
> > 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
Does the plan change if you use a hard-coded timestamp in your query?