Performance issues with materialized_only=false
|
|
0
|
443
|
January 12, 2024
|
Continuous Aggregate gets wrong data and duplicated time bucket after refreshing
|
|
2
|
698
|
December 1, 2023
|
Compress_segmentby notice while creating compression policy on continues aggregates
|
|
3
|
697
|
November 22, 2023
|
Timezone handling for Materialized views
|
|
5
|
1246
|
November 20, 2023
|
Slow performance in query on continuous aggregates
|
|
2
|
994
|
November 17, 2023
|
Timescale DB Aggregations - Not as expected
|
|
0
|
442
|
October 27, 2023
|
(Continuous) aggregation based on other column data
|
|
2
|
637
|
October 19, 2023
|
Update continuous aggregate to hierarchal aggregate
|
|
1
|
626
|
October 10, 2023
|
Trouble getting interpolated_duration_in to show expected results
|
|
8
|
1325
|
September 29, 2023
|
Question on hierarchical aggregates
|
|
2
|
633
|
September 29, 2023
|
Continuous aggregates - apply changes from standard table
|
|
4
|
781
|
September 22, 2023
|
Finding delta between events that are outside of the `time_bucket` window
|
|
2
|
936
|
September 6, 2023
|
Does a select * query trigger refresh of a fresh continuous aggregate created with `WITH NO DATA` option?
|
|
1
|
656
|
September 5, 2023
|
Refreshing already deleted continuous aggregate
|
|
3
|
829
|
August 28, 2023
|
Continuous Aggregate Refresh Policy not refreshing
|
|
3
|
1103
|
August 10, 2023
|
Are refresh policies necessary if no historical data is inserted?
|
|
5
|
1376
|
July 26, 2023
|
Continuous Aggregation policy does not materialize view
|
|
1
|
782
|
July 5, 2023
|
Workaround for Materialized View with Offset
|
|
0
|
640
|
July 4, 2023
|
Continuousaggregate not refreshing without end_offset => NULL
|
|
0
|
642
|
July 2, 2023
|
Send newly inserted rows in materialised view (aggregates) to sqs
|
|
8
|
1412
|
June 29, 2023
|
CAgg timestamp out of range error within job refresh
|
|
2
|
1153
|
June 13, 2023
|
Heartbeat_agg does not exist in schema 'public'
|
|
3
|
1338
|
June 2, 2023
|
Continuous aggregate with heartbeat_agg
|
|
0
|
1071
|
May 23, 2023
|
Creating and managing orderbook
|
|
4
|
1382
|
May 14, 2023
|
Db becomes unresponsive during aggregate refresh
|
|
0
|
630
|
May 5, 2023
|
`lower bound cannot equal upper bound` error when executing `refresh_continuous_aggregate(...);`
|
|
2
|
1014
|
April 6, 2023
|
Materialised view with CAGG and time_bucket_gapfill
|
|
8
|
1676
|
March 22, 2023
|
"ERROR: portal snapshots (1) did not account for all active snapshots (2)" When
|
|
3
|
1253
|
March 7, 2023
|
Continuous aggregate view rebuilt at every query
|
|
4
|
1223
|
February 25, 2023
|
Using gap fill with a continuous aggregate
|
|
0
|
2338
|
February 16, 2023
|