Very cool. Bookmarked in case I ever need to do this. I have implemented a transactional outbox in postgres using a simpler version of this plus a trigger to n

Very cool. Bookmarked in case I ever need to do this. I have implemented a transactional outbox in postgres using a simpler version of this plus a trigger to notify listening workers. It worked well and vastly outpaced the inserting processes. It easily handled several million tasks per hour without issue. It is also nice the article showed the correct CTE based form of the query. It is possible to naively write the query without it and sometimes get way more tasks than you asked for when there are concurrent workers. I discovered that pretty quickly but it had me pulling my hair out…