News for hackers. Stuff that matters.
Re:Time-series data: Why (and how) to use a relational datab... by jterrace on Thursday April 20, 2017 @03:25PM (#14159973)
What kind of compression ratio do you get?
Re:Time-series data: Why (and how) to use a relational datab... by cevian on Thursday April 20, 2017 @03:35PM (#14160040)
(TimescaleDB developer here)

Yeah, so on-disk compression is one area where we aren't as competitive with NoSQL column stores.

However, two things to note:

1) Often many of those column-oriented DBs, based on LSM trees, actually need to consume a lot more memory to index all of their disjoint SSTables. So it's a tradeoff of memory vs. disk.

2) There are various things we have on our TODO to test, like just running Postgres on ZFS. We'll write up the results when we do.