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

Use larger primary-key field for logger_instance #762

Open
jnm opened this issue Aug 26, 2021 · 2 comments
Open

Use larger primary-key field for logger_instance #762

jnm opened this issue Aug 26, 2021 · 2 comments
Assignees

Comments

@jnm
Copy link
Member

jnm commented Aug 26, 2021

It's not completely impossible that we'll exceed the maximum capacity of the Postgres integer data type, which is what Django's AutoField uses. Luckily, there's also a BigAutoField—but then there's the perennial question about whether or not we can change the column width in logger_instance without rewriting every row in that huge table.

@jnm
Copy link
Member Author

jnm commented Aug 23, 2022

integer max is 2,147,483,647 per https://www.postgresql.org/docs/14/datatype-numeric.html

@noliveleger
Copy link
Contributor

@jnm FYI: It has been done for logger.Instance and viewer.ParsedInstance
I'm wondering whether or not we should also change InstanceHistory

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

2 participants