Timescaledb - Continuous Aggregates

Pages: 21

---

本篇目录

• Permissions error when migrating a continuous aggregate
• CREATE MATERIALIZED VIEW (Continuous Aggregate)
• Queries fail when defining continuous aggregates but work on regular tables
• Hierarchical continuous aggregate fails with incompatible bucket width
• About data retention with continuous aggregates
• Data retention on a continuous aggregate itself
• Jobs in TimescaleDB
• Continuous aggregate doesn't refresh with newly inserted historical data
• Convert continuous aggregates to the columnstore
• Enable compression on continuous aggregates
• Compression policies on continuous aggregates
• Time and continuous aggregates
• Declare an explicit timezone
• Integer-based time
• Create an index on a continuous aggregate
• Automatically created indexes
• Manually create and drop indexes
• ALTER MATERIALIZED VIEW (Continuous Aggregate)
• caggmigrate()
• Required arguments
• Optional arguments
• Dropping data
• Drop a continuous aggregate view
• Drop raw data from a hypertable
• PolicyVisualizerDownsampling
• Continuous aggregates on continuous aggregates
• Create a continuous aggregate on top of another continuous aggregate
• Use real-time aggregation with hierarchical continuous aggregates
• Roll up calculations
• Continuous aggregate watermark is in the future
• About continuous aggregates
• Types of aggregation
• Continuous aggregates on continuous aggregates
• Continuous aggregates with a JOIN clause
• Components of a continuous aggregate
• Continuous aggregates
• refreshcontinuousaggregate()
• Required arguments
• Optional arguments
• DROP MATERIALIZED VIEW (Continuous Aggregate)
• Migrate a continuous aggregate to the new form
• Configure continuous aggregate migration
• Check on continuous aggregate migration status
• Refresh continuous aggregates
• Change the refresh policy
• Add concurrent refresh policies
• Manually refresh a continuous aggregate