Hi, Rafia had done some testing on TPCH queries using Partition-wise join patch along with Parallel Append patch.
There, we had observed that for query 4, even though the partition wise joins are under a Parallel Append, the join are all non-partial. Specifically, the partition-wise join has non-partial nested loop joins when actually it was expected to have partial nested loop joins. (The difference can be seen by the observation that the outer relation of that join is scanned by non-parallel Bitmap Heap scan when it should have used Parallel Bitmap Heap Scan). Here is the detailed analysis , including where I think is the issue : https://www.postgresql.org/message-id/CAJ3gD9cZms1ND3p%3DNN%3DhDYDFt_SeKq1htMBhbj85bOmvJwY5fg%40mail.gmail.com All the TPCH results are posted in the same above mail thread. Thanks -Amit -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
