Content
View differences
Updated by Oliver Günther about 4 years ago
Some of the frequently updated tables i.e. `relations` need to have their primary key column `id` switched from `integer` to `bigint` to avoid an overflow.
* [ ] Update the primary key type
* [ ] Update the accompanying sequence overflow.
On a customer database, the primary key is at 1.4 \* 10 ^ 9 which is over half of what `integer` [supports](https://www.postgresql.org/docs/13/datatype-numeric.html)
* [ ] Update the primary key type
* [ ] Update the accompanying sequence
On a customer database, the primary key is at 1.4 \* 10 ^ 9 which is over half of what `integer` [supports](https://www.postgresql.org/docs/13/datatype-numeric.html)