Databases · Middle · Question 73 of 75
What does statement_timeout protect against?
- 1Slow network connections between client and server
- 2Transactions that are idle
- ✓Correct answer: Runaway queries: any statement running longer than the limit is cancelled
Explanation
Set it per role or per session for web traffic, e.g. a few seconds. idle_in_transaction_session_timeout handles forgotten open transactions.