3 ms·
With your example, I believe you’ve just described TimescaleDB. https://www.timescale.com/ https://www.timescale.com/ We use it to store 150M records a day, an
by LogicX 9y ago
With your example, I believe you’ve just described TimescaleDB. https://www.timescale.com/ https://www.timescale.com/
We use it to store 150M records a day, and be performant enough to have a customer facing analytics dashboard querying against it for real-time results. Pretty amazing approach.
- mfreed 9y agoTimescaleDB person here. Thanks for the call-out. For those who don't know, TimescaleDB is a extension to Postgres that makes it easy to use and scale for time-series data. It works with both PG9.6 and PG10. Some folks might be interested in two recent blog posts we wrote about PG10 partitioning: 1. Technical write-up about PG10 partitioning: https://blog.timescale.com/scaling-partitioning-data-postgresql-10-explained-cd48a712a9a1 https://blog.timescale.com/scaling-partitioning-data-postgre... 2. Why TimescaleDB's partitioning is easier-to-use and more performant than PG10's native partitioning for time-series data: https://blog.timescale.com/time-series-data-postgresql-10-vs-timescaledb-816ee808bac5 https://blog.timescale.com/time-series-data-postgresql-10-vs...