Might want to use int8 for id field in waveforms_continuoustrace?
megies opened this issue · 0 comments
megies commented
In our production instance, the id
field in waveforms_continuoustrace
table is currently at ~200e6. For postgres type integer
that is ~10% of the maximum value possible (~2.1e9). I assume that problems might/will arise if we ever hit the maximum value? So in the future it might be a good idea to use bigint
for that field instead (it seems that postgres does not have unsigned integer types, unfortunately?).