Parallelism

Postgres FM

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)
• 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