On Fri, Aug 16, 2013 at 9:45 AM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote: > On Thu, Aug 15, 2013 at 1:28 PM, Andrew Berman <rexxe98@xxxxxxxxx> wrote: >> Hi Jeff, >> >> Here is the full process list at the time it stopped working (I have changed >> the actual username, db and IP for security). Would the idle in transaction >> process be the culprit? > > Most likely, yes. You should be able to dig into pg_locks to verify. Actually, you can't. The waiting doesn't show up in pg_locks, because it polls in a sleep-loop, rather than doing a normal wait on the lock. Still, that idle in transaction process is almost surely the culprit. Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
