query_partition_wise.sql
text/plain
Filename: query_partition_wise.sql
Type: text/plain
Part: 2
SET enable_partition_wise_join TO true;
EXPLAIN (COSTS false)
SELECT b.j, avg(b.v + c.v)
FROM b
JOIN
c ON b.j = c.k
GROUP BY b.j;