How partition-wise joins and aggregates improve Postgres query performance

[@qiweishen5524]

Very interesting! Curious does the unpartitioned table has an index on the partition by column? If not, is the join by index better than partition-wise join