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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
