News for hackers. Stuff that matters.
Re:Timescale, an open-source time-series SQL database for Po... by riku_iki on Friday August 11, 2017 @12:21PM (#14991391)
> Regarding native storage, the insert rate really goes down as your table gets large, e.g., Timescale gets 20x higher throughput than PG: https://blog.timescale.com/timescaledb-vs-6a696248104e

I actually looked at this benchmark briefly, but couldn't find what kind of PostgreSQL schema you used there. Did you use similar array based schema as was described by Tgress author in his post? https://grisha.org/blog/2015/09/23/storing-time-series-in-po...

Re:Timescale, an open-source time-series SQL database for Po... by RobAtticus on Friday August 11, 2017 @12:44PM (#14991699)
We used a pretty basic approach for both: 12 columns - timestamp, hostname, 10 CPU metrics.