Sign in to confirm you’re not a bot
This helps protect our community. Learn more

How/Why to Sweep Async Tasks Under a Postgres Table | POSETTE 2024

Microsoft Developer
589K subscribers
<__slot-el>
<__slot-el>
1.5K views 10 months ago #PostgreSQL #Database #PosetteConf
Video of a conference talk about how & why to sweep async tasks under a Postgres table presented by Taylor Troesh at POSETTE: An Event for Postgres 2024. Instead of returning hostile "500" errors to users, a small async worker query pattern makes fault-tolerant design the default. In this talk, we'll talk about (1) how backend/database design impacts frontend experience, (2) the pervasive insanity of hand-rolling two-phase commit, (3) Postgres as a platform, (4) how async DB queues form a natural complement to Jira, and (5) how the tiny async query pattern works, and (6) how to tweak the query for optimized parallelism, prioritization, and sampling. Taylor tinkers with writing, learning, time, design, software, ideas, humor, and entrepreneurship. Chapters: 00:00 The problem 02:23 async tasks under a postgres table 03:18 FOR UPDATE SKIP LOCKED 09:19 Postgres vs Alternatives 10:48 Implementing the worker 18:07 Conclusion πŸ“• Everything you need β€¦...more
...more
How/Why to Sweep Async Tasks Under a Postgres Table | POSETTE 2024
33Likes
1,561Views
Jun 132024
Video of a conference talk about how & why to sweep async tasks under a Postgres table presented by Taylor Troesh at POSETTE: An Event for Postgres 2024. Instead of returning hostile "500" errors to users, a small async worker query pattern makes fault-tolerant design the default. In this talk, we'll talk about (1) how backend/database design impacts frontend experience, (2) the pervasive insanity of hand-rolling two-phase commit, (3) Postgres as a platform, (4) how async DB queues form a natural complement to Jira, and (5) how the tiny async query pattern works, and (6) how to tweak the query for optimized parallelism, prioritization, and sampling. Taylor tinkers with writing, learning, time, design, software, ideas, humor, and entrepreneurship. Chapters: 00:00 The problem 02:23 async tasks under a postgres table 03:18 FOR UPDATE SKIP LOCKED 09:19 Postgres vs Alternatives 10:48 Implementing the worker 18:07 Conclusion πŸ“• Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette βœ… Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist-2024 πŸ“Œ Let’s connect: X – @PosetteConf https://x.com/PosetteConf Mastodon - @posetteconf https://mastodon.social/@posetteconf Threads – @posetteconf https://www.threads.net/@posetteconf πŸ”” Subscribe to the POSETTE News: https://aka.ms/posette-subscribe #PosetteConf #PostgreSQL #Database Presenters: Taylor Troesh, mayor of taylor.town

Follow along using the transcript.

Microsoft Developer

589K subscribers