There are a variety of Postgres queue implementations. We implemented the most important features and packaged them as a Postgres extension written in Rust. Our favorites: usage of a visibility timeout to guarantee delivery of messages to exactly one consumer (within the visibility timeout) and bootstrapped pg_partman to automate the handling of table bloat and partitioning.
