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