Parallelism | Postgres.FM 047 | #PostgreSQL #Postgres podcast

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.