Dumb question: why can't I just insert a bunch of rows with a timestamp column and indices? Where does that fall short? At a certain # of rows or something?
What does this let me do that can't be achieved with "regular PostgreSQL without the extension"?
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'.