Questions tagged [continuous-aggregates]
17 questions
0
votes
2 answers
TimeScaleDB continuous aggregate refresh policy end offset is not working as expected
I am new to TimeScaleDB, I have created a continuous aggregate view as
CREATE MATERIALIZED VIEW minute_data
WITH (timescaledb.continuous)
AS
SELECT
time_bucket('1 min', time_stamp) as bucket,
thing_key,
avg(pulse_l) as avg_pulse_l,
…
Swapnil
- 15
- 4
0
votes
1 answer
TimescaleDB - Continuous Aggregation Refresh takes long time for even small volume of data
Continuous Aggregation Refresh takes long time for even small volume of data
This is regarding the continuous aggregation and refreshing it.
We ran the following queries and noted the observations.
Creating a table and converting it into hypertable…
BilalS10
- 16
- 2