Re: Slow network retrieves - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: Slow network retrieves
Date
Msg-id 40A10678.2070603@bigfoot.com
Whole thread Raw
In response to Slow network retrieves  (<wespvp@syntegra.com>)
List pgsql-general
wespvp@syntegra.com wrote:

> The back end is pretty much idle.  It shows 'idle in transaction'.

Well, is not soo much idle, it's holding a transaction id!

That "idle in transaction" is not your problem but however I suggest you
take a look at why you have idle in transaction backend; do you
have back end sitting there days and days in that state ?



Regards
Gaetano Mendola




pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: How to move data from 1 database to another?
Next
From: "Carl E. McMillin"
Date:
Subject: Re: Cancel query based on a timeout