Timescaledb: Resultset downsampling

[sanpa1977]

As real time timeseries datasets can be large and visualizing the same on any browser based technology creates a huge load on the client browsers, it would be good to have the possibility of Downsampling feature within the query itself; such as Largest-Triangle-Three Bucket Downsampling or Douglas Peucker Reduction. This will help reducing the output of data in the sql response itself.

[est]

when downsampling, can we choose to fill null with 0 or previous values?

[jedwards1211]

Or just min/max in each bucket, which avoids losing peaks and valleys

[AndyMender]

Usually, I restrict the sample size by either limiting the boundaries of the time window or bucketing, though it does in fact sound like a potent feature :).

[harshajayaweeraXHJ]

Is this feature available yet?

[markfarnan]

+1 for supporting LTTB as part of time_bucket or time_bucket_gapfill