3 ms·
Wouldn't you need to then commit to remove the entries from the temp table?
by foota 1y ago
Wouldn't you need to then commit to remove the entries from the temp table?
- zbentley 1y agoNo, 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.