Re: idle in transaction query makes server unresponsive

Chris Travers wrote:
> If it is truly idle in a transaction, maybe it has locks that are
holding up other transactions?
>
> Locks are usually held until commit time, except advisory locks iirc
but those have to be explicitly
> checked, so if you don't know if you are using them you probably
aren't.

Yes, but locks that block a new connection from succeeding?

Yours,
Laurenz Albe