krischer/jane

Might want to use int8 for id field in waveforms_continuoustrace?

megies opened this issue · 0 comments

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?).