$CLOUD_LONG supercharges your real-time analytics by letting you run complex queries continuously, with near-zero latency. Under the hood, this is achieved by using hypertables—$PG tables that automatically partition your time-series data by time and optionally by other dimensions. When you run a query, $CLOUD_LONG identifies the correct partition, called chunk, and runs the query on it, instead of going through the entire table.
Hypertables offer the following benefits:
-
Efficient data management with automated partitioning by time: $CLOUD_LONG splits your data into chunks that hold data from a specific time range. For example, one day or one week. You can configure this range to better suit your needs.
-
Better performance with strategic indexing: an index on time in the descending order is automatically created when you create a hypertable. More indexes are created on the chunk level, to optimize performance. You can create additional indexes, including unique indexes, on the columns you need.
-
Faster queries with chunk skipping: $CLOUD_LONG skips the chunks that are irrelevant in the context of your query, dramatically reducing the time and resources needed to fetch results. Even more—you can enable chunk skipping on non-partitioning columns.
-
Advanced data analysis with hyperfunctions: $CLOUD_LONG enables you to efficiently process, aggregate, and analyze significant volumes of data while maintaining high performance.
To top it all, there is no added complexity—you interact with hypertables in the same way as you would with regular $PG tables. All the optimization magic happens behind the scenes.
Inheritance is not supported for hypertables and may lead to unexpected behavior.