Parallelism | Postgres.FM 047 |

Nikolay and Michael discuss parallelism — both parallel query execution and other parallel operations.

Here are links to a few things we mentioned:


Parallel query (docs) https://www.postgresql.org/docs/curre...
Parallelism in PostgreSQL 11 (talk by Thomas Munro)    • Parallelism in PostgreSQL 11  
Parallelism in PostgreSQL 15 (talk by Thomas Munro)    • Parallelism in PostgreSQL 15 | Citus Con 2023  
Towards Millions TPS (blog post by Alexander Korotkov) https://akorotkov.github.io/blog/2016...
Memory resource consumption (docs) https://www.postgresql.org/docs/curre...
Our episode about index maintenance https://postgres.fm/episodes/index-ma...
Our episode about partitioning https://postgres.fm/episodes/partitio...
Patch to make postgres_fdw parallel-safe (by Swarm64) https://github.com/swarm64/parallel-p...
PostgreSQL Parallelism Do’s and Don’ts (talk by Sebastian Dressler)    • PostgreSQL Parallelism Do’s and Don’ts  
Increasing max_parallel_workers_per_gather (blog post by Michael) https://www.pgmustard.com/blog/max-pa...




~~~


What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov   / samokhvalov   and @michristofides   / michristofides  


~~~


Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard


~~~


This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.