Re:Building a distributed time-series database on PostgreSQL
by mh- on Wednesday August 21, 2019 @07:39PM
(#20763122)
I was disappointed to see that Adaptive Chunking is deprecated[1]. Are there future plans to ~replace this functionality?
[1] https://docs.timescale.com/latest/api#set_adaptive_chunking
Now, if this time/space partitioning alone isn't sufficient (i.e., demand for a single device/userid/etc at a specific time overcomes the read capacity of K nodes), having time-series data being primarily insert heavy (or even immutable) also gives us a lot of flexibility about how we replicate (as a sibling comment also suggested). And what really helps is that, by design, the architecture we built tracks fine-grained chunk information (rather than just course-grained hash-partitions), which can enable dynamic replication of individual chunks. More on this to come.