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
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.