Parallel Queries in PostgreSQL
Modern CPUs feature a large number of cores. For years, applications have been sending queries to databases in parallel. If it's a reporting query on many rows in a table, it executes faster when utilizing multiple CPUs, and this has been possible in PostgreSQL since version 9.6. It took three years to implement the parallel query feature — the code had to be rewritten at various execution stages […]
