Over 5 years ago my then-colleague wrote about problems with Postgres queues and the accumulation of garbage MVCC versions (see brandur.org/postgres-queues). Expect significant improvements in this area for Postgres 14:
Conversation
Very useful work. To get arount this I avoid DELETEs and use partitions to periodically truncate old data from the queue. You can also avoid UPDATEs by storing a "consumer offset" on another small table a la Kafka
1
1
Thanks! I'm not quite prepared to say that you should stop doing that now. More like "there are some sharp corners that will be sanded down in Postgres 14, which is good news for users in a general kind of way".