Re:Timescale raises $16M from Benchmark, NEA, Two Sigma Vent...
by manigandham on Wednesday January 24, 2018 @12:44PM
(#16224599)
> Pretty much the columnar/mpp stuff is good for simple aggregates for ad-hoc non-real-time queries
How is a column-oriented database which is primarily designed for fast performance across large data not good for real-time queries? Memsql, clickhouse, vertica, druid, etc are all fast systems that can scan terabytes in milliseconds with complex queries.
It's great that timescale provides new options and works with postgres but let's keep things accurate in a field that has plenty of confusion already.
Re:Timescale raises $16M from Benchmark, NEA, Two Sigma Vent...
by ddorian43 on Wednesday January 24, 2018 @12:33PM
(#16224488)
See Clickhouse for `oltp` columnar store (built for powering dashboards).
Re:Timescale raises $16M from Benchmark, NEA, Two Sigma Vent...
by cevian on Wednesday January 24, 2018 @01:32PM
(#16225049)
Clickhouse is a very cool project but is more analytical than OLTP. Percona had a nice writeup[1] (the comparison to mysql is especially apt -- note the lack of real-time updates and deletes in Clickhouse).
[1] https://www.percona.com/blog/2017/02/13/clickhouse-new-opens...
Plus, when you know which particular aggregates you want to regularly query, TimescaleDB makes it easily to perform continuous roll-ups so you can store in a separate (hyper)table.