JLockerman

note: the LATERAL query above benefits significantly from being able to perform an index-only scan on `foo2`, you would want an index like ```SQL CREATE INDEX ON foo2 (time DESC)...

@k-rus as far as I know: I believe that the chunk is being compressed in the background concurrently with foreground compression, so it _should_ be compressed, but I've never actually...

@svenklemm in the output for `views.out` I'm not sure why it's outputting `info_views` first, I suspect it's random. (also if you haven't already, you should re-pull the `duplicate-trigger-repro` it briefly...

@NunoFilipeSantos I haven't heard anything. @cevian Have you guys seen the bug recently, or did we work around it on the promscale end?

(the [promscale `duplicate-trigger-repro`](https://github.com/timescale/promscale/tree/duplicate-trigger-repro) branch is still up so the reproduction steps in the original post should still trigger the bug, if it still exists)

> Why not the standard syntax > `interpolate(sample(timeseries(time,value), '1 minute'))`? Is it just ergonomics? @cevian I expanded more in the [discussion topic](https://github.com/timescale/timescale-analytics/discussions/10), but to summarize it's a combination of ergonomics...

Scafodling and operator is merged as of PR # Next up is downsampling, bucketing, and gapfilling. These should serve as an minimal viable example for the pipelining.

Gap handling operations: 1. remove gaps (example: remove NULLs) 2. fill with constant 3. fill with some calculated value

Thank you for the excellent bug report! I was able to reproduce the bug locally, and will report back one we've determined the cause. (note for future repro'ers: you need...

Simpler repro of the same issue: install the extension and run ```SQL SELECT timescale_analytics_experimental.hyperloglog_count('{ "version":1, "element_type":"VARCHAR", "collation":["pg_catalog","en_US.utf8"], "b":6, "registers":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,0] }'); ``` This will cause an error like ``` ERROR: called...