Publishing details

• Published on 2019-05-06
• Copied from ubuntu trusty in TimescaleDB Experimental by Timescale

Changelog

timescaledb-postgresql-10 (1.3.0~ubuntu14.04) trusty; urgency=low

  * This release contains major new functionality that we call continuous aggregates.

  * Aggregate queries which touch large swathes of time-series data can take a long time to compute because the system needs to scan large amounts of data on every query execution. Our continuous aggregates continuously calculate the results of a query in the background and materialize the results. Queries to the continuous aggregate view are then significantly faster as they do not need to touch the raw data in the hypertable, instead using the pre-computed aggregates in the view.

  * Continuous aggregates are somewhat similar to PostgreSQL materialized views, but unlike a materialized view, continuous aggregates do not need to be refreshed manually; the view will be refreshed automatically in the background as new data is added, or old data is modified. Additionally, it does not need to re-calculate all of the data on every refresh. Only new and/or invalidated data will be calculated. Since this re-aggregation is automatic, it doesn’t add any maintenance burden to your database.

  * Our continuous aggregate approach supports high-ingest rates by avoiding the high-write amplification associated with trigger-based approaches. Instead, we use invalidation techniques to track what data has changed, and then correct the materialized aggregate the next time that the automated process executes.

 -- Timescale <email address hidden>  Mon, 06 May 2019 18:01:44 +0000

Builds

• amd64

Built packages

• timescaledb-postgresql-10 An open-source time-series database based on PostgreSQL, as an extension.

Package files

• timescaledb-postgresql-10_1.3.0~ubuntu14.04.dsc (1.2 KiB)
• timescaledb-postgresql-10_1.3.0~ubuntu14.04.tar.gz (2.4 MiB)
• timescaledb-postgresql-10_1.3.0~ubuntu14.04_amd64.deb (503.0 KiB)