pgbench % output incorrect with large scales - Mailing list pgsql-bugs

From Thom Brown
Subject pgbench % output incorrect with large scales
Date
Msg-id CAA-aLv7JXKZoMrvmFk2s4iJJ9kwHNPxhjVZjAYYtV12Wq+R+CQ@mail.gmail.com
Whole thread Raw
Responses Re: pgbench % output incorrect with large scales  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #7521: Cannot disable WAL log while using pg_dump
Next
From: Tom Lane
Date:
Subject: Re: pgbench % output incorrect with large scales