Queues in Postgres

Postgres FM

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:

1. Near the end, we incorrectly say "idempotent" when we meant "stateless", and also 50 TPS instead of 500 TPS
2. 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