PostgreSQL GUC enable_parallel_append spreads workers across branches
Christophe Pettus explains the enable_parallel_append GUC, which allows PostgreSQL to distribute workers across multiple partitions or UNION branches simultaneously rather than sequentially. This shift from sequential to parallel execution across append nodes aims to improve throughput for complex queries involving large unions or partitioned tables.
Parallel Append executes branches concurrently, not one after another