idle_in_transaction_session_timeout for idle connections
I have the following problem where some of my DB connections become IDLE and prisma is not cleaning them up nicely for some reason. I want to set SET SESSION idle_in_transaction_session_timeout = '5min'; in postgres to automatically clean these up in case they get stale. Any reason why I should not change this session timeout from unlimited (0) to 5 min?
2 Replies