Re: idle in transaction query makes server unresponsive - Mailing list pgsql-general

From Albe Laurenz
Subject Re: idle in transaction query makes server unresponsive
Date
Msg-id D960CB61B694CF459DCFB4B0128514C20874C197@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: idle in transaction query makes server unresponsive  (Chris Travers <chris.travers@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: idle in transaction query makes server unresponsive
Next
From: "Albe Laurenz"
Date:
Subject: Re: Re: Need help in reclaiming disk space by deleting the selected records