How deeply does Just Use Postgres! cover continuous aggregate?

Defines hypertable storage, time bucketing, querying, and refresh policies without detailed implementation internals.

Continuous aggregate

A continuous aggregate is a TimescaleDB query-result object that stores precomputed aggregate data and refreshes it incrementally according to a defined policy.

A continuous aggregate stores a precomputed query result in a hypertable and refreshes it incrementally. It suits analytical queries over large historical datasets or data queried more often than it changes. section 9.6 section 9.6.1

Detecting low heart rate

For smartwatch monitoring, aggregate measurements into five-minute buckets per watch. Store the minimum rate, readings below 50 BPM, and total measurements; then treat low_rate_count >= 5 as a detected event. Querying three consecutive buckets returns three positive results.

New measurements do not automatically update the aggregate. Define a policy with start_offset, end_offset, and schedule_interval, or refresh a precise time range manually when working with fixed historical timestamps. section 9.6.2

How Just Use Postgres! covers it

liveBook manning.com

Read Just Use Postgres! on liveBook Get the book at manning.com

Related concepts

hypertableuses · A hypertable is a TimescaleDB-managed table that automatically organizes time-series rows into partitions called chunks.
materialized viewkind of · A materialized view is a persistently stored result of a defining query that can be read without recomputing it and is refreshed or maintained from underlying data.
TimescaleDBused by · TimescaleDB is a PostgreSQL extension optimized for storing and querying time-series data.
bucketuses · A bucket is a grouping or storage unit to which data or items are assigned according to a criterion, range, hash, or partitioning scheme.
retention policyused by · A retention policy is a rule specifying what data or records are preserved, for how long, and under what conditions they may be archived, deleted, or otherwise disposed of.

This explainer was generated by Manning's knowledge graph from the text of Just Use Postgres!. The section links point to the parts of the book it draws on.