query_partition_wise.sql

text/plain

Filename: query_partition_wise.sql
Type: text/plain
Part: 2
Message: Re: Partition-wise aggregation/grouping
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;