Sure, there are different design patterns for different data sizes. This also adds querying complexity, so just depends on what’s needed.
Also, most applications have peak and low periods of load that are predictable (e.g. users concentrated in a given set of time zones) which make for good times to run otherwise disrupting functions, etc.