Re: pgbench bug candidate: negative "initial connection time"

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: pgbench bug candidate: negative "initial connection time"
Дата
Msg-id alpine.DEB.2.22.394.2106162018040.2407635@pseudo
обсуждение исходный текст
Ответ на Re: pgbench bug candidate: negative "initial connection time"  (Yugo NAGATA <nagata@sraoss.co.jp>)
Ответы Re: pgbench bug candidate: negative "initial connection time"  (Yugo NAGATA <nagata@sraoss.co.jp>)
Список pgsql-hackers
Hello Yugo-san,

>> When connection break while the bench has already started,
>> maybe it makes more sense to proceed,
>
> The result would be incomplete also in this case. However, the reason why
> it is worth to proceed is that  such information is still useful for users,
> or we don't want to waste the bench that has already started?

Hmmm. It depends on what the user is testing. If one is interested in 
client resilience under errors, the bench should probably attempt a 
reconnect. If one is interested in best performance when all is well,
then clearly something is amiss and there is no point to go on.

>> although I guess that maybe reattempting connections would make also 
>> sense in such case.
>
> This might become possible after pgbench gets the feature to retry in deadlock
> or serialization errors.

Yes, I agree that part of the needed infrastructure would be in place for 
that. As reconnecting is already in place under -c, so possibly it is just 
a matter of switching between states with some care.

> I am working on rebase of the patch [2] and I will submit this in a few 
> days.

Ok. Very good, I look forward to your submission! I'll be sure to look at 
it.

-- 
Fabien.



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: snapshot too old issues, first around wraparound and then more.
Следующее
От: Andres Freund
Дата:
Сообщение: Re: snapshot too old issues, first around wraparound and then more.