{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Parallelism","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/d65ac22d\"></iframe>","width":"100%","height":180,"duration":2664,"description":"Nikolay and Michael discuss parallelism — both parallel query execution and other parallel operations.\n \nHere are links to a few things we mentioned: \nParallel query (docs)\nParallelism in PostgreSQL 11 (talk by Thomas Munro)\nParallelism in PostgreSQL 15 (talk by Thomas Munro)\nTowards Millions TPS (blog post by Alexander Korotkov)\nMemory resource consumption (docs)\nOur episode about index maintenance\nOur episode about partitioning \nPatch to make postgres_fdw parallel-safe (by Swarm64) \nPostgreSQL Parallelism Do’s and Don’ts (talk by Sebastian Dressler)\nIncreasing max_parallel_workers_per_gather (blog post by Michael)\n\n~~~\nWhat 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!\nIf you would like to share this episode, here's a good link (and thank you!)\n\n~~~\nPostgres FM is brought to you by:\nNikolay Samokhvalov, founder of Postgres.ai\nMichael Christofides, founder of pgMustard\nWith special thanks to:\nJessie Draws for the amazing artwork ","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}