pgbench % output incorrect with large scales
От | Thom Brown |
---|---|
Тема | pgbench % output incorrect with large scales |
Дата | |
Msg-id | CAA-aLv7JXKZoMrvmFk2s4iJJ9kwHNPxhjVZjAYYtV12Wq+R+CQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: pgbench % output incorrect with large scales
|
Список | pgsql-bugs |
Hi all, I've run pgbench with a scale of 2000, and have noticed that the % done goes a bit wonky: thom@bison:~$ pgbench -i -s 2000 pgbench NOTICE: table "pgbench_history" does not exist, skipping NOTICE: table "pgbench_tellers" does not exist, skipping NOTICE: table "pgbench_accounts" does not exist, skipping NOTICE: table "pgbench_branches" does not exist, skipping creating tables... 100000 of 200000000 tuples (0%) done. 200000 of 200000000 tuples (0%) done. 300000 of 200000000 tuples (0%) done. ... 2000000 of 200000000 tuples (1%) done. ... 20000000 of 200000000 tuples (10%) done. ... 21500000 of 200000000 tuples (-10%) done. ... 23000000 of 200000000 tuples (-9%) done. ... 31000000 of 200000000 tuples (-5%) done. ... 41000000 of 200000000 tuples (0%) done. and so on, and so forth. Presumably this is just an int overflowing repeatedly. -- Thom
В списке pgsql-bugs по дате отправления: