Re: BUG #14452: Unexpected transaction behaviour

On 12/6/2016 6:46 PM, rjsdg(at)sapo(dot)pt wrote:
> The system normal throughput is about 110 transactions/min constantly
> without degradation. Recently a new Java module of the application was
> installed and when the app startups the system throughput starts to degrade
> to the point that reaches 50 transactions/min, it’s not an immediate
> downfall in the throughput but it looses like 5 to 10 transactions per
> minute until it reaches 50 transactions per minute. At this point if we
> terminate the only existing backend pid of the new Java module (that is in
> “idle in transaction” with a backend_xmin value) immediatly in the next
> minute the throughput rises again to 110 transactions/min.

'idle in transaction' for more than a short amount of time is bad news,
it blocks all maintenance activity like vacuuming, and causes frequently
updated tables and indexes to bloat badly.

--
john r pierce, recycling bits in santa cruz