Slow commits and row locks in Postgres

How an explicit row lock can block writes on completely different tables, and why it only shows up at commit time

How asyncio works

An in-depth look at how asyncio works in Python