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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
