Parallel queries in PostgreSQL
Modern CPUs have a lot of cores. For years, applications have been sending queries to databases in parallel. If it is a reporting query against multiple rows in a table, it is faster when it uses multiple CPUs, and PostgreSQL has been able to do this since version 9.6. It took 3 years to implement the parallel query feature - I had to rewrite the code at different stages of […]