From: | Péter Kovács <maxottovonstirlitz(at)gmail(dot)com> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Finding out on exactly what I am stuck |
Date: | 2009-04-09 22:40:25 |
Message-ID: | fdeb32eb0904091540n1f6c250bi2bc0961263dd7fe2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Overlooked your mentioning to timestamps in pg_stat_activity. What
patterns do I need to look for there.
Thanks
Peter
2009/4/9 Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Péter Kovács | 2009-04-09 23:19:45 | Re: Finding out on exactly what I am stuck |
Previous Message | Péter Kovács | 2009-04-09 22:35:25 | Re: Finding out on exactly what I am stuck |