Re: Adding a test for speculative insert abort case

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Adding a test for speculative insert abort case
Дата
Msg-id EB208EEB-200D-4BD6-935D-BFD03E71CEB4@anarazel.de
обсуждение исходный текст
Ответ на Re: Adding a test for speculative insert abort case  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
Hi,

On April 30, 2019 6:43:08 PM PDT, Peter Geoghegan <pg@bowt.ie> wrote:
>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).

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.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: performance regression when filling in a table
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Adding a test for speculative insert abort case