Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> Partial output of "select * from pg_locks":
> | | 1192675195 | 62860 | ShareLock | f
> | | 1192675195 | 62814 | ExclusiveLock | t
> | | 1192675195 | 62838 | ShareLock | f
> | | 1192675195 | 63525 | ShareLock | f
> where 1192675195 is the 'transaction' field.
> I am not at all clear what the processes are waiting for,
Neither are we, because you left out all the columns that might tell
that ...
regards, tom lane