Claudio Freire <claudio@livra.com> wrote:
> I know it doesn't look like a deadlock from where you're standing,
> but it does so from where I am.
It's possible that you're filtering out the information which would
be most useful to diagnosing the problem. Next time it happens,
please send the entire output from pg_locks and pg_stat_activity
(preferably as attachments to avoid wrapping issues), along with the
information listed under "Things you need to mention" on this page:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
-Kevin