cityofaustin / atd-data-tech

Austin Transportation Data & Technology Services
17 stars 2 forks source link

[Tech debt] Convert ID sequences to `bigint` #19763

Open johnclary opened 1 week ago

johnclary commented 1 week ago

As discussed in Slack, our ID sequences are incrementing rather quickly due to the frequency of upserts we make during the CRIS import.

We should convert our ID sequences to bigint to avoid the rather unlikely case in which our sequences hit ~2 billion.