Hi, i would like to ask about timescaleDB for refreshing data in materialized view.
i have:
master_tbl, cont_agg_10s, cont_agg_1m, cont_agg_5m_a, cont_agg_5m_b, cont_agg_5m_c.
- cont_agg_10s is from master_tbl
- cont_agg_1m is from cont_agg_10s
- cont_agg_5m_a is from cont_agg_1m
- cont_agg_5m_b is from cont_agg_5m_a
- cont_agg_5m_c is from cont_agg_5m_a
cont_agg_5m_b & cont_agg_5m_c & cont_agg_5m_a have the same schedule refresh which is every 5 minutes.
cont_agg_5m_c & cont_agg_5m_b sometimes have missing bucket due to race condition. do you have any suggestion how to solve it?
thank you.