Avatar for Leon Mika
Leon Mika
Software engineer in Melbourne, Australia.
About Now Projects Archive Follow More Search

Another thing I learnt about PostgreSQL: notifications sent within a transaction will only be dispatch to listeners until and unless the transaction is committed. So inserting rows in one transaction, and notifying something which will consume those rows in another should not result in a deadlock.

October 2, 2026 10:49am
Leon Mika Leon Mika
dev-notes

Dev Notes

  • ❮ Previous Post
  • Next Post ❯