3 ms·
Can you tell me more about the use case where you'd create a new table every minute?
by np_tedious 5y ago
Can you tell me more about the use case where you'd create a new table every minute?
- valzam 5y agoNot OP but for analytics use cases it is common to create new tables for each minute, hour, day or whatever granularity you collect data in. This makes it easier to aggregate later, you don't end up with extremely big tables, you can drop a subset of the data without affecting the performance of the table currently being written to etc..
- dafelst 5y agoThat sounds like what table row partitioning is for, I thought all the major databases supported that?