Re: BUG #4945: Parallel update(s) gone wild - Mailing list pgsql-bugs

From Dan Boeriu
Subject Re: BUG #4945: Parallel update(s) gone wild
Date
Msg-id EF2E22898E35844BA4479BBF97078AC1FD0ABA@be10.exg4.exghost.com
Whole thread Raw
In response to BUG #4945: Parallel update(s) gone wild  ("dan boeriu" <dan.boeriu@roost.com>)
Responses Re: BUG #4945: Parallel update(s) gone wild  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs

Attached is the reproducible test case - I was able to reproduce the problem on 32 and 64 bit 8.3.6 and 8.4.0 RedHat 5.3 kernel 2.6.18-128.1.16.el5 #1 SMP

JUST IN CASE - if the second update ever finishes just do a couple of times:

INSERT INTO xxx SELECT * FROM xxx;

That should do it.

Please let me know if you were able to reproduce the problem.


Dan Boeriu
Senior Architect - Roost.com
P: (415) 742 8056
Roost.com - 2008 Inman Award Winner for Most Innovative New Technology

Attachment

pgsql-bugs by date:

Previous
From: "Jeff Janes"
Date:
Subject: BUG #4952: commit_delay ignored because CountActiveBackends always returns zero
Next
From: "Axel Fix"
Date:
Subject: BUG #4954: very slow query with 2 statements