Does anyone know if statement_timeout works with pgBouncer in transaction pooling mode?

@freemo Well, I'm occassionaly experiencing deadlock situations when all queries go into idle mode. Specifically in the puma workers, there is 0 reason for any query to ever take longer than 5s to execute, on any environment. So adding a timeout there would let the problem fix itself. However, I am not sure it works with transaction pooling, because a session doesn't really exist with transaction pooling. Every query you execute, might get a different underlying connection to postgres.

Follow

@Gargron Do you have a link to the offending code? No promises but I can take a look. I can't think of any solutions from the description alone. But I am happy to look over the code to see if anything sticks out to me.

Sign in to participate in the conversation
Qoto Mastodon

QOTO: Question Others to Teach Ourselves
An inclusive, Academic Freedom, instance
All cultures welcome.
Hate speech and harassment strictly forbidden.