part of the issue is that because postgres has an application-layer mvcc system, we need to serialize writes, which means that overlapping writes need to be retried