Transactions

There are multiple timeouts to work with when using Postgres and CockroachDB. These can help prevent single statements from running too long, stop transactions that are idle or taking too long, and release locks.

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.