On Sun, Mar 8, 2009 at 2:54 PM, Mark Mandel <mark(dot)mandel(at)gmail(dot)com> wrote:
> Just a note on this -
>
> I have tried it on both 8.2 and 8.3
>
> Maybe 'deadlock' isn't the right word, so much as 'hang'.. in that
> once it decided to stop at that point, it goes no further, unless I
> restart the app server that has the connecton to the database.
>
> It seems to be completely random, and I'm got no idea what is going on.
Well, pg_locks can tell you, and us, a lot. Next time it's happening
grab the contents of pg_locks and attach it to an email here. Most
likely it's some long running transaction or something blocking the
access you need.