You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We should consider what changes are required so that we don't have to do an annual reset / cleanout of the Freezing Saddles database.
For performance, we could partition the tables so that that queries end up working on just a year's worth of data. This would require reworking indexes and doing partition management, though. Maybe sever the partitioning into its own issue...
This would require reworking a bunch of queries to have where clauses with dates in them.
This is kind of an architecture moonshot, no hurry on this one. It would make the system way more flexible and extensible overall.
The text was updated successfully, but these errors were encountered:
We should consider what changes are required so that we don't have to do an annual reset / cleanout of the Freezing Saddles database.
For performance, we could partition the tables so that that queries end up working on just a year's worth of data. This would require reworking indexes and doing partition management, though. Maybe sever the partitioning into its own issue...
This would require reworking a bunch of queries to have where clauses with dates in them.
This is kind of an architecture moonshot, no hurry on this one. It would make the system way more flexible and extensible overall.
The text was updated successfully, but these errors were encountered: