Re: Avoid stuck of pbgench due to skipped transactions

Поиск
Список
Период
Сортировка
Искать
От
Fabien COELHO
Тема
Re: Avoid stuck of pbgench due to skipped transactions
Дата
Msg-id
alpine.DEB.2.22.394.2109040817460.2329925@pseudo
Ответ на
Список
Дерево обсуждения
Avoid stuck of pbgench due to skipped transactions Yugo NAGATA <nagata@sraoss.co.jp>
Re: Avoid stuck of pbgench due to skipped transactions Fabien COELHO <coelho@cri.ensmp.fr>
Re: Avoid stuck of pbgench due to skipped transactions Yugo NAGATA <nagata@sraoss.co.jp>
Re: Avoid stuck of pbgench due to skipped transactions Fabien COELHO <coelho@cri.ensmp.fr>
Re: Avoid stuck of pbgench due to skipped transactions Yugo NAGATA <nagata@sraoss.co.jp>
Re: Avoid stuck of pbgench due to skipped transactions Yugo NAGATA <nagata@sraoss.co.jp>
Re: Avoid stuck of pbgench due to skipped transactions Greg Sabino Mullane <htamfids@gmail.com>
Re: Avoid stuck of pbgench due to skipped transactions Yugo NAGATA <nagata@sraoss.co.jp>
Re: Avoid stuck of pbgench due to skipped transactions Greg Sabino Mullane <htamfids@gmail.com>
Re: Avoid stuck of pbgench due to skipped transactions Yugo NAGATA <nagata@sraoss.co.jp>
Re: Avoid stuck of pbgench due to skipped transactions Fujii Masao <masao.fujii@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>
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>
Re: Avoid stuck of pbgench due to skipped transactions Fujii Masao <masao.fujii@oss.nttdata.com>

Hello Fujii-san,

> ISTM that the patch changes pgbench so that it can skip counting
> some skipped transactions here even for realistic rates under -T.
> Of course, which would happen very rarely. Is this understanding right?

Yes. The point is to get out of the scheduling loop when time has expired, 
as soon it is known, instead of looping there for some possibly long time.

> On the other hand, even without the patch, in the first place, there seems
> no guarantee that all the skipped transactions are counted under -T.
> When the timer is exceeded in CSTATE_END_TX, a client ends without
> checking outstanding skipped transactions.

Indeed. But that should be very few transactions under latency limit.

> Therefore the "issue" that some skipped transactions are not counted is 
> not one the patch newly introdues.

Yep. The patch counts less of them though, because of the early exit 
introduced in the patch in the scheduling state. Before it could be stuck 
in the "while (late) { count; schedule; }" loop.

> So that behavior change by the patch would be acceptable. Is this 
> understanding right?

I think so.

-- 
Fabien.


В списке pgsql-hackers по дате отправления
От: Noah Misch
Дата:
От: Amit Kapila
Дата:
FAQ