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 ...
* 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.