Transactions

CockroachDB and Postgres let you lock a row with a select if you intend to update it, but what if the transaction gets stuck and the row remains locked? The idle_in_transaction_session_timeout setting can help with this.