Dead Lock problem with 8.1.3

Поиск
Список
Период
Сортировка
От Kai Hessing
Тема Dead Lock problem with 8.1.3
Дата
Msg-id 4m7mf6F4saleU1@individual.net
обсуждение исходный текст
Ответы Re: Dead Lock problem with 8.1.3
Список pgsql-general
Hi Folks,

I have a strange Problem (to be honest there are more than one, but this
is one of it) after Upgrading to Postgres 8.1.3. The following SQL seems
to produce a deadlock while doing an endless reading of a temp table:

SELECT s.sid FROM stud s, stud_vera v WHERE s.sid = v.sid AND v.veraid =
34 AND s.sid NOT IN ( SELECT sid FROM stud_vera WHERE veraid = 2 );

It should give me a List of sids which are connected to veraid 34 but
not to veraid 2 at the same time. When removing the 'AND v.veraid = 34':

SELECT s.sid FROM stud s, stud_vera v WHERE s.sid = v.sid AND s.sid NOT
IN ( SELECT sid FROM stud_vera WHERE veraid = 2 );

everything works really fine (even if I include an additional criteria
like 'AND stud_vera.status > 0' ). On Postgres 8.0.8 this problem
doesn't exist. The first clause works with a lot of additional criteria
very fast.

Any Idea?

*greets*
Kai

В списке pgsql-general по дате отправления:

Предыдущее
От: Mark Morgan Lloyd
Дата:
Сообщение: Re: NT4 client problem
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Estimate on gborg rescue?