Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Might want to use int8 for id field in waveforms_continuoustrace? #86

Open
megies opened this issue Aug 23, 2018 · 0 comments
Open

Might want to use int8 for id field in waveforms_continuoustrace? #86

megies opened this issue Aug 23, 2018 · 0 comments

Comments

@megies
Copy link
Collaborator

megies commented Aug 23, 2018

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant