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@xxxxxxxxxxxxxx>
