Parallel Aggregate - Getting the most out of your CPUs - 2ndQuadrant | PostgreSQLHi, David First big thank’s for implementing parallel aggr for PG. I try to test Q1 query from TPC-H (50GB scale factor, 300M rows of LINEITEM table) on PG 9.6beta1 and get next results : 302171.230 ms for max_parallel_degree = 0 175506.106 ms for max_parallel_degree = 4 144931.588 ms for max_parallel_degree = 8 Changes made to postgresql.conf : shared_buffers = 8000MB work_mem = 2000MB max_parall
