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