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 currently can only handle constants and
expressions which are equivalent to constants. It will not filter on
Joins successfully.
This will improve somewhat in 9.1, possibly enough to fix your case.
Please test this on 9.1a5 and see how well it works, and give us feedback.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com