[SQL] Best practice for long-lived journal tables: bigint or recycling IDs?

Hello, I have some tables that continually collect statistics, and then over time are pruned as the stats are aggregated into more useful formats. For some of these tables, it it is fore-seeable that the associated sequences would be incremented past the max value of the int type in the normal

Re: [SQL] Best practice for long-lived journal tables: bigint or recycling IDs?

Mark Stosberg wrote: Hello, I have some tables that continually collect statistics, and then over time are pruned as the stats are aggregated into more useful formats. For some of these tables, it it is fore-seeable that the associated sequences would be incremented past the max value