4 ms·
NB: I'm the author of the post, and I work at Timescale. Yep! Though I will say a number of the hyperfunctions are optimized to work on time-series data whethe
by djk447 5y ago
NB: I'm the author of the post, and I work at Timescale.
Yep! Though I will say a number of the hyperfunctions are optimized to work on time-series data whether or not there's a hypertable involved, but the name is meant to echo the hypertable concept. In general, hyperfunctions are meant to improve the user experience for working with time-series data inside of SQL.
- jhgb 5y agoSo there's no strict semantic connection between the "hyper-" in "hyperfunction" and "hyper-" in "hypertable"? Sounds quite confusing to me.
- djk447 5y agoTechnically, the hyper in hypertable was originally connected to the fact that they hypercubes as part of the partitioning logic: https://github.com/timescale/timescaledb/blob/master/src/hypercube.h https://github.com/timescale/timescaledb/blob/master/src/hyp... Over time, that connection sort of got lost in favor of hypertables just being useful for storing and analyzing time-series data. So, these functions are conceptually similar in that they make analyzing time-series data easier, even if they don't involve hypercubes or the like. And I'd bet that most users will use hyperfunctions on their data in hypertables, but you can also use them on data in regular Postgres tables etc.