On Fri, Nov 04, 2005 at 08:46:27PM -0400, Marc G. Fournier wrote: > On Fri, 4 Nov 2005, Jim C. Nasby wrote: > For all the talk about "couldn't it be part of regression", I haven't seen > anyone submit a patch that would test for it ... since I believe both you > and Tom have both stated that "for things like race conditions, I don't > know that you can create reproducable cases", can you submit a patch for > how you propose this should be added to the regression tests?
I have an idea, but it might be better if Robert could produce a test case since it would cover both a context storm issue as well as this race condition. Baring that, my idea was to spawn a number of processes, all of which were trying to insert/update a random value in a table using David Fetter's plpgsql code for doing a merge. This would produce a heavy workload that also used subtransactions (due to the exception handling in plpgsql). Suggestions for a better test welcome... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
