Péter Kovács <maxottovonstirlitz(at)gmail(dot)com> wrote:
> postgres 14727 9868 0 22:34 ? 00:00:00 postgres: pkovacs
> chemaxon 127.0.0.1(12496) idle in transaction
> postgres 14735 9868 0 22:34 ? 00:00:00 postgres: pkovacs
> chemaxon 127.0.0.1(12497) idle in transaction
> postgres 14737 9868 0 22:34 ? 00:00:00 postgres: pkovacs
> chemaxon 127.0.0.1(12498) UPDATE waiting
I would start by looking at pg_locks to see if your update is blocked
by one of the connections which is idle in a transaction. Any locks
won't be released until the idle transaction commits or rolls back.
Then look at pg_stat_activity to check timestamps. Be sure your
software doesn't have any code path which leaves things dangling.
(Since you seem to be using Java, I recommend proper use of
try/finally blocks to ensure resources are released.)
-Kevi