Re: Avoid stuck of pbgench due to skipped transactions

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Avoid stuck of pbgench due to skipped transactions
Дата
Msg-id ad80113e-1713-ccb2-3d9e-95fc9a46e112@oss.nttdata.com
обсуждение исходный текст
Ответ на Re: Avoid stuck of pbgench due to skipped transactions  (Fabien COELHO <coelho@cri.ensmp.fr>)
Ответы Re: Avoid stuck of pbgench due to skipped transactions  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Список pgsql-hackers

On 2021/09/07 18:24, Fabien COELHO wrote:
> 
> Hello Fujii-san,
> 
>> Stop counting skipped transactions under -T as soon as the timer is exceeded. Because otherwise it can take a very
longtime to count all of them especially when quite a lot of them happen with unrealistically high rate setting in -R,
whichwould prevent pgbench from ending immediately. Because of this behavior, note that there is no guarantee that all
skippedtransactions are counted under -T though there is under -t. This is OK in practice because it's very unlikely to
happenwith realistic setting.
 
> 
> Ok, I find this text quite clear.

Thanks for the check! So attached is the updated version of the patch.


>> One question is; which version do we want to back-patch to?
> 
> If we consider it a "very minor bug fix" which is triggered by somehow unrealistic options, so I'd say 14 & dev, or
possiblyonly dev.
 

Agreed. Since it's hard to imagine the issue happens in practice,
we don't need to bother back-patch to the stable branches.
So I'm thinking to commit the patch to 15dev and 14.

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug in query rewriter - hasModifyingCTE not getting set
Следующее
От: Wu Haotian
Дата:
Сообщение: Re: Add option --drop-cascade for pg_dump/restore