News for hackers. Stuff that matters.
Re:Timescale, an open-source time-series SQL database for Po... by Throaway786 on Thursday August 10, 2017 @09:52PM (#14986043)
We have a requirement of saving 100million data points every 5 mins. What options should we explore for real time system for last 15 days of data and archival system for last 3 years of data?
Re:Timescale, an open-source time-series SQL database for Po... by mfreed on Thursday August 10, 2017 @10:15PM (#14986135)
We've had users at that scale at least on the real-time side (e.g., 100M/5min, 500B rows), although requires some care.

Might be easiest to discuss more on Slack (https://slack-login.timescale.com/) or email (mike at timescale) if you're interested.

Re:Timescale, an open-source time-series SQL database for Po... by subleq on Thursday August 10, 2017 @11:53PM (#14986481)
I don't have any experience with this type of thing, so that sounds like an incredibly large amount of data. What are you doing that requires it? What type of useful queries are you even able to perform over 432 billion records?
Re:Timescale, an open-source time-series SQL database for Po... by sureshv on Friday August 11, 2017 @02:12AM (#14987032)
300k+ sensors sampling at 1 hertz would get you there.
Re:Timescale, an open-source time-series SQL database for Po... by d21d3q on Tuesday August 15, 2017 @05:15PM (#15022669)
What do you do with that data? Just store or do some analysis on it (how? With what kind of resources?)?