3 ms·

What kind of compression ratio do you get?

• cevian 9y ago
  (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.