Re: Fixing pgbench init overflow

Поиск
Список
Период
Сортировка
От Japin Li
Тема Re: Fixing pgbench init overflow
Дата
Msg-id ME3P282MB316684190982F54BDBD4FE90B69BA@ME3P282MB3166.AUSP282.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Fixing pgbench init overflow  (Chen Hao Hsu <johnhyvr@gmail.com>)
Ответы Re: Fixing pgbench init overflow  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Список pgsql-hackers
On Sat, 23 Dec 2023 at 07:18, Chen Hao Hsu <johnhyvr@gmail.com> wrote:
> Hello,
>
> pgbench mixes int and int64 to initialize the tables.
> When a large enough scale factor is passed, initPopulateTable
> overflows leading to it never completing, ie.
>
> 2147400000 of 2200000000 tuples (97%) of
> pgbench_accounts done (elapsed 4038.83 s, remaining 98.93 s)
> -2147400000 of 2200000000 tuples (-97%) of
> pgbench_accounts done (elapsed 4038.97 s, remaining -8176.86 s)
>
>
> Attached is a patch that fixes this, pgbench -i -s 22000 works now.

I think only the following line can fix this.

+    int64            k;

Do not need to modify the type of `n`, right?

--
Regrads,
Japin Li
ChengDu WenWu Information Technology Co., Ltd.



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

Предыдущее
От: Junwang Zhao
Дата:
Сообщение: Re: Transaction timeout
Следующее
От: Li Japin
Дата:
Сообщение: Re: Transaction timeout