Database fix
Close idle transactions automatically
Effort basis: One configuration change, applied without downtime.
- 1.Set idle_in_transaction_session_timeout to 60 seconds on the app's database role.
- 2.Watch connection counts during the next import run.
Impact: Frees stuck connections so checkout stays responsive while jobs run.
Pros
- Immediate relief
- No code changes
- Easy to undo
Cons
- Long legitimate transactions over 60 s would be cut off
Who: Your database admin