4 ms·
This is true, but given this post and the one linked about their custom column store, I don't think Timescale would fit. Timescale is still row-oriented while i
by claytonjy 5y ago
This is true, but given this post and the one linked about their custom column store, I don't think Timescale would fit. Timescale is still row-oriented while in memory (compressed chunks are columnar), though that may not be a big deal in practice; the bigger deal might be the ability to arbitrarily add columns. With Timescale you either have to issue DDL to add a column (which can be expensive and doesn't work in some cases), or resign yourself to JSONB. My worry with the JSONB is that it'll be expensive to search w/o indices, but if you need indices that goes against the Honeycomb philosophy.
Very curious to hear if folks more deeply familiar with TimescaleDB internals have a different take!