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/current/parallel-query.html
* Parallelism in PostgreSQL 11 (talk by Thomas Munro) https://www.youtube.com/watch?v=jWIOZzezbb8
* Parallelism in PostgreSQL 15 (talk by Thomas Munro) https://www.youtube.com/watch?v=3v-cthowG10
* Towards Millions TPS (blog post by Alexander Korotkov) https://akorotkov.github.io/blog/2016/05/09/scalability-towards-millions-tps/
* Memory resource consumption (docs) https://www.postgresql.org/docs/current/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY
* Our episode about index maintenance https://postgres.fm/episodes/index-maintenance
* Our episode about partitioning https://postgres.fm/episodes/partitioning
* Patch to make postgres_fdw parallel-safe (by Swarm64) https://github.com/swarm64/parallel-postgres-fdw-patch
* PostgreSQL Parallelism Do’s and Don’ts (talk by Sebastian Dressler) https://www.youtube.com/watch?app=desktop&v=i_91jNrRYWk
* Increasing max_parallel_workers_per_gather (blog post by Michael) https://www.pgmustard.com/blog/max-parallel-workers-per-gather

~~~

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 https://twitter.com/samokhvalov and @michristofides https://twitter.com/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.