| From: | Thom Brown <thom(at)linux(dot)com> |
|---|---|
| To: | pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | pgbench % output incorrect with large scales |
| Date: | 2012-10-20 12:30:19 |
| Message-ID: | CAA-aLv7JXKZoMrvmFk2s4iJJ9kwHNPxhjVZjAYYtV12Wq+R+CQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi all,
I've run pgbench with a scale of 2000, and have noticed that the %
done goes a bit wonky:
thom(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-10-20 16:46:34 | Re: pgbench % output incorrect with large scales |
| Previous Message | Robert Haas | 2012-10-19 20:25:07 | Re: BUG #7521: Cannot disable WAL log while using pg_dump |