What I've found matters in this area is the mismatch in locality between elements in read batches and elements in write batches. It'd be nice if the emerging DBs that deal with these issues put at least a gloss on the information model and write -> read lifecycle they're targeting.

Otherwise, a lot of these "actually you need X for time series!" are just talking past each other because "time series" means any number of actual patterns.