Finding tables & columns at risk of hitting max value of int
0
votes
2
answers
883
views
I just took over a medium-sized postgres database and the team has been surprised with many tables hitting their auto-incrementing
id
int
max limits which triggered unscheduled downtime to fix.
Does anyone know of a simple tool to help check all tables/columns and easily find which are at risk of hitting the int
max limits? I'm sure we can come up with a script to check, but I remember reading somewhere of a tool to help me identify potential issues exhaustively.
Asked by leonsas
(233 rep)
Oct 13, 2020, 01:30 PM
Last activity: Sep 18, 2024, 01:45 PM
Last activity: Sep 18, 2024, 01:45 PM