Timescaledb: 2.11.0 Release

Release date:
May 19, 2023
Previous version:
2.10.3 (released April 26, 2023)
Magnitude:
10,130 Diff Delta
Contributors:
23 total committers
Data confidence:
Commits:

168 Features Released with 2.11.0

Top Contributors in 2.11.0

erimatnor
akuzm
sb230132
jnidzwetzki
svenklemm
antekresic
fabriziomello
mkindahl
pmwkaa
nikkhils

Directory Browser for 2.11.0

We haven't yet finished calculating and confirming the files and directories changed in this release. Please check back soon.

Release Notes Published

This release contains new features and bug fixes since the 2.10.3 release. We deem it moderate priority for upgrading.

This release includes these noteworthy features: * Support for DML operations on compressed chunks: * UPDATE/DELETE support * Support for unique constraints on compressed chunks * Support for ON CONFLICT DO UPDATE * Support for ON CONFLICT DO NOTHING * Join support for hierarchical Continuous Aggregates

Features * #5212 Allow pushdown of reference table joins * #5261 Improve Realtime Continuous Aggregate performance * #5252 Improve unique constraint support on compressed hypertables * #5339 Support UPDATE/DELETE on compressed hypertables * #5344 Enable JOINS for Hierarchical Continuous Aggregates * #5361 Add parallel support for partialize_agg() * #5417 Refactor and optimize distributed COPY * #5454 Add support for ON CONFLICT DO UPDATE for compressed hypertables * #5547 Skip Ordered Append when only 1 child node is present * #5510 Propagate vacuum/analyze to compressed chunks * #5584 Reduce decompression during constraint checking * #5530 Optimize compressed chunk resorting * #5639 Support sending telemetry event reports

Bugfixes * #5396 Fix SEGMENTBY columns predicates to be pushed down * #5427 Handle user-defined FDW options properly * #5442 Decompression may have lost DEFAULT values * #5459 Fix issue creating dimensional constraints * #5570 Improve interpolate error message on datatype mismatch * #5573 Fix unique constraint on compressed tables * #5615 Add permission checks to run_job() * #5614 Enable run_job() for telemetry job * #5578 Fix on-insert decompression after schema changes * #5613 Quote username identifier appropriately * #5525 Fix tablespace for compressed hypertable and corresponding toast * #5642 Fix ALTER TABLE SET with normal tables * #5666 Reduce memory usage for distributed analyze * #5668 Fix subtransaction resource owner * #5680 Fix DISTINCT query with JOIN on multiple segmentby columns

Thanks * @kovetskiy and @DZDomi for reporting peformance regression in Realtime Continuous Aggregates * @ollz272 for reporting an issue with interpolate error messages * @ericdevries for reporting an issue with DISTINCT queries using segmentby columns of compressed hypertable