2.11.0 (2023-05-22)

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