{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Queues in Postgres","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/e86cbb49\"></iframe>","width":"100%","height":180,"duration":2388,"description":"Nikolay and Michael discuss queues in Postgres — the pros and cons vs dedicated queuing tools, and some tips for scaling.\n \nA couple of apologies-in-advance: \nNear the end, we incorrectly say \"idempotent\" when we meant \"stateless\", and also 50 TPS instead of 500 TPS\nWe also had a couple of audio issues, sorry!\n\nHere are links to a few things we mentioned: \nRecent discussion on Hacker News\nPgQ\nWhat is SKIP LOCKED (blog post by Craig Ringer) \nautovacuum\nPostgres queues (blog post by Brandur)\npg_repack\nOur episode on partitioning\nNikolay’s Twitter poll\nSubtransactions Considered Harmful (blog post by Nikolay)\n\n~~~\n\nWhat did you like or not like? What should we discuss next time? Let us know 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}