Andrew Sullivan wrote:
> No, it doesn't. Deadlock means, for the two deadlocked queries, both
> cannot possibly finish because each waits on a lock that the other
> one holds.
Thanks for the clarification. I thought a deadlock is also, when the
system runs into an endless loop.
>> There is no output. It just takes forever.
>
> . . .define "forever". Is it doing any work? Do you see i/o? Is it
> in SELECT WAITING state?
No it is not in WAITING state, it is permanently working. strace is
telling me that it is constantly accessing a file:
'postgresql/8.1/main/base/1740468/pgsql_tmp/pgsql_tmp21938.0' It doesn't
cost much performance, but it is running all the time.
Please see the full update at Message-ID: <4o2bkgFclmdhU1@individual.net>