On Wed, Jul 19, 2017 at 9:54 AM, Rafia Sabih <rafia.sa...@enterprisedb.com> wrote: > > Partition information: > Type of partitioning - single column range partition > Tables partitioned - Lineitem and orders > > Lineitem - > Partition key = l_orderkey > No of partitions = 18 > > Orders - > Partition key = o_orderkey > No of partitions = 11 >
The patch set upto 0015 would refuse to join two partitioned relations using a partition-wise join if they have different number of partitions. Next patches implement a more advanced partition matching algorithm only for list partitions. Those next patches would refuse to apply partition-wise join for range partitioned tables. So, I am confused as to how come partition-wise join is being chosen even when the number of partitions differ. -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
