| From: | Kai Hessing <kai(dot)hessing(at)hobsons(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Dead Lock problem with 8.1.3 |
| Date: | 2006-09-06 10:33:23 |
| Message-ID: | 4m7mf6F4saleU1@individual.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2006-09-06 12:28:31 | Estimate on gborg rescue? |
| Previous Message | Sim Zacks | 2006-09-06 10:15:48 | NT4 client problem |