What will happen to the counter?

Question

PostgreSQL

There is one table in which one of the fields uses a sequence of type integer. According to my calculations, after about 2000 or 4000 daily cycles (only 5-10 years), the values ​​​​for the counter will end. What then needs to be done? (Provided that I have infinite server resources and the memory does not run out before)

Answer 1

Use sequence of type bigserial. The maximum value for BigInteger is 9223372036854775807. At 1000 records per second, it will take you about 300 million years to exhaust the capacity of identifiers.