Hi, On April 30, 2019 6:43:08 PM PDT, Peter Geoghegan <p...@bowt.ie> wrote: >On Tue, Apr 30, 2019 at 5:16 PM Melanie Plageman ><melanieplage...@gmail.com> wrote: >> Can anyone think of a good way to put this codepath under test? > >During the initial development of ON CONFLICT, speculative insertion >itself was tested using custom stress testing that you can still get >here: > >https://github.com/petergeoghegan/jjanes_upsert > >I'm not sure that this is something that you can adopt, but I >certainly found it very useful at the time. It tests whether or not >there is agreement among concurrent speculative inserters, and whether >or not there are "unprincipled deadlocks" (user hostile deadlocks that >cannot be fixed by reordering something in application code).
I think we want a deterministic case. I recall asking for that back then... Andres -- Sent from my Android device with K-9 Mail. Please excuse my brevity.