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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
