Episode 42
Queues in Postgres
Postgres FM · Nikolay Samokhvalov and Michael Christofides
April 21, 202339m 48s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Nikolay and Michael discuss queues in Postgres — the pros and cons vs dedicated queuing tools, and some tips for scaling.
A couple of apologies-in-advance:
- Near the end, we incorrectly say "idempotent" when we meant "stateless", and also 50 TPS instead of 500 TPS
- We also had a couple of audio issues, sorry!
Here are links to a few things we mentioned:
- Recent discussion on Hacker News
- PgQ
- What is SKIP LOCKED (blog post by Craig Ringer)
- autovacuum
- Postgres queues (blog post by Brandur)
- pg_repack
- Our episode on partitioning
- Nikolay’s Twitter poll
- Subtransactions Considered Harmful (blog post by Nikolay)
~~~
What 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.
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
Topics
PostgresPostgreSQLDatabasesSQLtechnology