there are several good articles explaining this, especially on Timescable blog, but in short, without time partitioning and just index, at some given point the performance for reads and writes degrades exponencially.
jasonshen's blog is awesome! And regarging the case, that is basically what my father did. Left a corporate job to run his own small business 25 years ago and he has been much happier ever since.
With many news articles on the North Korean missile that flew over Japan yesterday, one obvious question is not even mentioned: why didn't Japan shoot it down? But an article from 2017, at the timing of the previous occurrence might explain it. Maybe it simply cant'.