On Wed, Jul 26, 2017 at 12:02 PM, Ashutosh Bapat <ashutosh.ba...@enterprisedb.com> wrote: > > Ok. If those queries have equi-join between partitioned tables and are > not picking up partition-wise join, that case needs to be > investigated. Q21 for example has join between three lineitem > instances. Those joins can be executed by partition-wise join. But it > may so happen that optimal join order doesn't join partitioned tables > with each other, thus interleaving partitioned tables with > unpartitioned or differently partitioned tables in join order. > Partition-wise join is not possible then. A different partitioning > scheme may be required there. > Good point, will look into this direction as well.
-- Regards, Rafia Sabih EnterpriseDB: http://www.enterprisedb.com/ -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers