Version 1.4.0 with more permissive permissions to work correctly when provided by a managed environment. Use the regular version of the release, unless you have specific reason to use this one.

This release updates the toolkit code work with Postgres 14. It also updates the extension to use the 0.2 version of pgx.

Full Changelog: 1.3.1...1.4.0

Version 1.3.1 with more permissive permissions to work correctly when provided by a managed environment. Use the regular version of the release, unless you have specific reason to use this one.

Internal memory usage improvements.

Version 1.3.0 with more permissive permissions to work correctly when provided by a managed environment. Use the regular version of the release, unless you have specific reason to use this one.

This release stabilizes many in-progress features, improves stats_agg, and introduces a new experimental feature, timevector function pipelines, to ease working with time-series data.

Stabilizations

• counter_agg helper functions for Prometheus-style resetting monotonic counters.
• hyperloglog efficient approximate COUNT DISTINCT.
• stats_agg two-step aggregate for common statistics.

Experimental Features

• timevector function pipelines. A compact and readable way to perform a sequence of analytic operations such as the following one for volatility

  timevector(ts, val) -> sort() -> delta() -> abs() -> sum()

• -> accessor for Toolkit types enables syntax like stats_agg(data) -> average()
• to_epoch() wrapper for extract ('EPOCH' FROM timestamp) that makes it work more like an inverse of to_timestamp(DOUBLE PRECISION) #251

Migration Warning

• This release changes the textual I/O format for Toolkit types. We are uncertain if we will need to do so again in the future. Due to this we currently only support dump/restore within a single version of the extension.

New Contributors

• @jonatas made their first contribution in #237
• @burmecia made their first contribution in #251

Full Changelog: 1.2.0...1.3.0

Version 1.2.0 with more permissive permissions to work correctly when provided by a managed environment. Use the regular version of the release, unless you have specific reason to use this one.

This release adds some bugfixes and optimizations and includes new and refined experimental features.

Experimental Features

• Refinements to hyperloglog including a function to report relative error and fixing the functionality of rollup.
• Introduction of a TopN approximation API. Presently this will only work for integer data, but expect to see further refinements that greatly expand this behavior.
• New map_series and map_data pipeline elements for the time series API that allow uses to provide custom transforms of their time series data. Additionally introduced a |>> pipeline operator for an even more streamlined interface into the new mapping functionality.

Bugfixes/Optimizations

• Made a pass through all toolkit functions to correctly label behavior as immutable and parallel safe. This should improve the optimizations Postgres can apply to toolkit plans, particularly when run in a Timescale multinode cluster.
• Improved handling of internal data structures to reduce extraneous copies of data.

Version 1.1.0 with more permissive permissions to work correctly when provided by a managed environment. Use the regular version of the release, unless you have specific reason to use this one.

This release contains new experimental features and bugfixes.

Experimental Features

• hyperloglog has been updated to use Hyperloglog++ under the hood. This does not change the user-facing API but should improve the accuracy of hyperloglog() estimates. This is the last major change expected for hyperloglog() and is now a candidate for stabilization pending user feedback.
• We've started experimenting with the pipeline API. While it's still very much a work in progress, it's at a point where the high-level concepts should be understandable. For example, a pipeline that outputs the daily change of a set of data, interpolating away any gaps in daily data, could look like

  SELECT timeseries(time, val)
      |> sort()
      |> resample_to_rate('trailing_average', '24 hours', true)
      |> fill_holes('interpolate')
      |> delta()
  FROM ...

  It's still early days for this API and it is not yet polished, but we would love feedback about its direction.

Bugfixes

• Fixed a small memory leak in aggregation functions. This could have leaked ≈8 bytes per aggregate call.

As always we love feedback! All in-progress features are tracked in Feature Progress, and please stop by our Discussions or issue tracker if you have any questions, comments, or feedback!