pgbench: allow to exit immediately when any client is aborted

Поиск
Список
Период
Сортировка
От Yugo NAGATA
Тема pgbench: allow to exit immediately when any client is aborted
Дата
Msg-id 20230804130325.df32e60879c38c92bca64207@sraoss.co.jp
обсуждение исходный текст
Ответы Re: pgbench: allow to exit immediately when any client is aborted  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Список pgsql-hackers
Hi,

I would like to propose to add an option to pgbench so that benchmark
can quit immediately when any client is aborted. Currently, when a
client is aborted due to some error, for example, network trouble, 
other clients continue their run until a certain number of transactions
specified -t is reached or the time specified by -T is expired. At the
end, the results are printed, but they are not useful, as the message
"Run was aborted; the above results are incomplete" shows.

For precise benchmark purpose, we would not want to wait to get such
incomplete results, rather we would like to know some trouble happened
to allow a quick retry. Therefore, it would be nice to add an option to
make pgbench exit instead of continuing run in other clients when any
client is aborted. I think adding the optional is better than  whole
behavioural change because some users that use pgbench just in order
to stress on backends for testing purpose rather than benchmark might
not want to stop pgbench even a client is aborted. 

Attached is the patch to add the option --exit-on-abort.
If this option is specified, when any client is aborted, pgbench
immediately quit by calling exit(2).

What do you think about it?

Regards,
Yugo Nagata
-- 
Yugo NAGATA <nagata@sraoss.co.jp>

Вложения

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

Предыдущее
От: Andy Fan
Дата:
Сообщение: Re: Extract numeric filed in JSONB more effectively
Следующее
От: Richard Guo
Дата:
Сообщение: Re: Improve join_search_one_level readibilty (one line change)