Hacker News new | past | comments | ask | show | jobs | submit login

Can someone please summarize what it does because I couldn't figure out from website? It says its "on Postgres", is it a flavor of PG? or it sits on top of multiple PG instances.





How's this:

TimescaleDB is a distributed time-series database that is packaged as a Postgres extension (a "mega-extension" to quote someone else on this thread).

TimescaleDB:

* Scales to over 10 million of metrics per second [0]

* Supports native compression, using delta-delta, Gorilla, Simple-8B RLE, and other best-in-class compression algorithms (achieving a median 94% compression based on user data) [1]

* Offers native time-series capabilities, such as data retention policies, continuous aggregate views, real-time aggregates, downsampling, data gap-filling, and interpolation

* Handles high cardinality [2]

* Outperforms other non-relational databases including InfluxDB [3], Mongo [4], Cassandra [5] for time-series data

With TimescaleDB you also get all of the goodness that is built into Postgres: full SQL, a variety of data types (numerics, text, arrays, JSON, booleans), ACID semantics, and operationally mature capabilities including high-availability, streaming backups, upgrades over time, roles and permissions, and security.

[0] https://blog.timescale.com/blog/building-a-distributed-time-...

[1] https://blog.timescale.com/blog/building-columnar-compressio...

[2] https://blog.timescale.com/blog/what-is-high-cardinality-how...

[3] https://blog.timescale.com/blog/timescaledb-vs-influxdb-for-...

[4] https://blog.timescale.com/blog/how-to-store-time-series-dat...

[5] https://blog.timescale.com/blog/time-series-data-cassandra-v...


Here's the original intro to Timescale blog post - https://blog.timescale.com/blog/when-boring-is-awesome-build...

It's a PG extension.



Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | Legal | Apply to YC | Contact

Search: