Parallelism
Nikolay and Michael discuss parallelism — both parallel query execution and other parallel operations.
Here are links to a few things we mentioned:
Here are links to a few things we mentioned:
- Parallel query (docs)
- Parallelism in PostgreSQL 11 (talk by Thomas Munro)
- Parallelism in PostgreSQL 15 (talk by Thomas Munro)
- Towards Millions TPS (blog post by Alexander Korotkov)
- Memory resource consumption (docs)
- Our episode about index maintenance
- Our episode about partitioning
- Patch to make postgres_fdw parallel-safe (by Swarm64)
- PostgreSQL Parallelism Do’s and Don’ts (talk by Sebastian Dressler)
- Increasing max_parallel_workers_per_gather (blog post by Michael)
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
If you would like to share this episode, here's a good link (and thank you!)
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork