Re:Choose Postgres Queue Technology
by bavell on Monday September 25, 2023 @06:53AM
(#37641818)
This is from 2015, does it still hold true in 2023?
[ Parent
| on HN ]
Yes, in that Postgres still
uses oldest-to-newest tuple ordering, and its MVCC hasn’t changed, so you can still cause the issues listed.
Careful monitoring and tuning of parameters mentioned by the sibling comment to you can help mitigate this, though.
Ultimately at scale, no, RDBMS shouldn’t be a queue. But most have a long way to go before they hit that point.