Re: [PERFORM] Issue with partition elimination

2011-04-25 Thread Josh Berkus
On 4/21/11 6:26 PM, Paul Pierce wrote: > What was noticed, that the only case when Postgres is actually going to > execute > the query against the right partitions is query #1. > > Is that by design? Second query join, will also result in 3 days(3 > partitions) Partition elimination currentl

[PERFORM] Issue with partition elimination

2011-04-23 Thread Paul Pierce
This is a good one :) Here is a "brief" description of our issue(Postgres 9.0): Tables: main fact table: Table "public.parent_fact" Column|Type | --+-+--- etime| date | not n