Really good article explaining the implementation detail within Postgres regarding subtransactions. Very cool benchmark that I was unaware of