Re: Adding a test for speculative insert abort case - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Adding a test for speculative insert abort case
Date
Msg-id CAH2-WzmzQX_z9Kct1GWEnz=zR0VQeRMoyT4S1Tc-44+PiW2SWg@mail.gmail.com
Whole thread Raw
In response to Adding a test for speculative insert abort case  (Melanie Plageman <melanieplageman@gmail.com>)
Responses Re: Adding a test for speculative insert abort case
List pgsql-hackers
On Tue, Apr 30, 2019 at 5:16 PM Melanie Plageman
<melanieplageman@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).

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: REINDEX INDEX results in a crash for an index of pg_class since9.6
Next
From: Fabien COELHO
Date:
Subject: Re: performance regression when filling in a table