News for hackers. Stuff that matters.
Re:Using SIMD to aggregate billions of values per second by stereosteve on Tuesday April 07, 2020 @05:15PM (#22807538)
In the reference there's no mention of SQL Window functions. Is it possible to do multiple moving averages over different time spans?

If not, are there plans to add support in the future?

Re:Using SIMD to aggregate billions of values per second by TheTank on Tuesday April 07, 2020 @05:26PM (#22807653)
Window functions are in draft, we will release them imminently. We will support moving averages. In fact we plan to support generic multi-pass and window functions. Having multi-pass will allow you to do things like `select sum(x -sum(x)) from tab`.
Re:Using SIMD to aggregate billions of values per second by jnordwick on Wednesday April 08, 2020 @12:53AM (#22810173)
those things are so useless if your time points arent equidistant (ie, you don't care about the last 100 rows, you care about the last 5 minutes). they basically force you to use very slow correlated subqueries. please do something better.