Re: Dead Lock problem with 8.1.3

Joe Conway wrote:
> Martijn van Oosterhout wrote:
>> It probably has something to with the fact that you didn't explain what
>> you meant by "deadlock". Also, you refer to a temp table, yet don't
>> indicate which table it is.

Deadlock means it hangs up and doesn't terminate through timeout.
The system goes into an endless loop. The part ('SELECT sid FROM
stud_vera WHERE veraid = 2') seems to create a temporary table again and
again and again ....

>> You'll need to be a lot more specific about your problem before we can
>> help. For example, a script to reproduce the problem, or a copy of psql
>> output demonstrating it.

There is no output. It just takes forever. We're currently working to
seperate this problem into a simple setup. If we have one, I will post it.

> Also EXPLAIN output, and information regarding the number of rows in
> each table, and the number of rows matching veraid = 2 and veraid = 34
> might help.

Explain produces the same problem. It just takes forever...

> While the query is running, how much CPU is the process consuming, and
> what does vmstat show for disk and swap I/O?

~80% CPU power. Disk usage is not noticable.

Thanks and
*greets*
Kai