Re:
by foota on Thursday July 10, 2025 @06:28PM
(#44526402)
Wouldn't you need to then commit to remove the entries from the temp table?
[ Parent
| on HN ]
No, so long as the rows in there are transactionally guaranteed to be present or not, a sweeper script can handle removing failed “publishes” (notifys that didn’t delete their row) later.
This does sacrifice ordering and increases the risk of duplicates in the message stream, though.