On Sun, Mar 8, 2009 at 2:54 PM, Mark Mandel <mark.man...@gmail.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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
