Timescale/timescaledb: Release 2.2.0

Name: timescaledb

Owner: Timescale

Release: 2.2.0 (2021-04-13)

Released: 2021-04-13

License: NOASSERTION

Release Assets:

This release adds major new features since the 2.1.1 release. We deem it moderate priority for upgrading.

This release adds the Skip Scan optimization, which significantly improves the performance of queries with DISTINCT ON. This optimization is not yet available for queries on distributed hypertables.

This release also adds a function to create a distributed restore point, which allows performing a consistent restore of a multi-node cluster from a backup.

The bug fixes in this release address issues with size and stats functions, high memory usage in distributed inserts, slow distributed ORDER BY queries, indexes involving INCLUDE, and single chunk query planning.

PostgreSQL 11 deprecation announcement

Timescale is working hard on our next exciting features. To make that possible, we require functionality that is unfortunately absent on PostgreSQL 11. For this reason, we will continue supporting PostgreSQL 11 until mid-June 2021. Sooner to that time, we will announce the specific version of TimescaleDB in which PostgreSQL 11 support will not be included going forward.

Major Features

  • #2843 Add distributed restore point functionality
  • #3000 SkipScan to speed up SELECT DISTINCT

Bugfixes

  • #2989 Refactor and harden size and stats functions
  • #3058 Reduce memory usage for distributed inserts
  • #3067 Fix extremely slow multi-node order by queries
  • #3082 Fix chunk index column name mapping
  • #3083 Keep Append pathkeys in ChunkAppend

Thanks

  • @BowenGG for reporting an issue with indexes with INCLUDE
  • @fvannee for reporting an issue with ChunkAppend pathkeys
  • @pedrokost and @RobAtticus for reporting an issue with size functions on empty hypertables
  • @phemmer and @ryanbooz for reporting issues with slow multi-node order by queries
  • @stephane-moreau for reporting an issue with high memory usage during single-transaction inserts on a distributed hypertable.

The music for this release was Michael Jackson's Thriller.

To top