Partition pruning doen't work in this caseas described athttp://www.postgresql-archive.org/Partition-pruning-for-Star-Schema-td5995163.html#a5995168
Partition wise join works for ONLY ONE dim table (that is better thannothing).
--Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html