"integer overflow what will be next" Code Answer

think of it this way: how long did it take you to fill up an int? perhaps six months?

now multiply that time by roughly 4 billion.

that's how long it will take to fill up a bigint, if you insert data at the same rate. so if it took you half a year to fill an int, the bigint will last 2 billion years.

that gives you some scope of how much larger the range of a bigint is than an int. a bigint supports up to 2⁶⁴ values, which is 2³² times larger than the number of values in an int.

By Hartmut Holzgraefe on July 8 2022