On Wed, Jul 26, 2017 at 12:02 PM, Ashutosh Bapat <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
