Explore the intricacies of implementing queues in PostgreSQL through this informative conference talk from Citus Con: An Event for Postgres 2022. Delve into queue-like database workloads, examining the pros and cons of building queues within relational databases. Learn about various queue structures, access patterns, and real-world use cases. Gain insights into locking strategies, concurrency, transaction isolation levels, and vacuuming considerations. Discover benchmarking techniques, compare PostgreSQL with other RDBMSs, and explore potential future features. Benefit from the expertise of Thomas Munro, a PostgreSQL developer and committer, as he shares his knowledge on query parallelism, resource management, and database/operating system interfaces. Engage with the Q&A session to further enhance your understanding of queue processing in PostgreSQL.
Queues in PostgreSQL - Building and Optimizing Database Job Queues
Overview
Syllabus
Introduction.
What is a queue?.
Why put a queue in an RDBMS.
Example queue use cases.
How would you build a queue in Postgres.
Complications with queue processing in Postgres.
What could we do better to improve Postgres queue processing?.
Q&A with Thomas & Aaron .
Taught by
Microsoft Developer
