On Wed, Sep 2, 2009 at 8:05 AM, Kevin Kempter <kev...@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?
