TimescaleDB extension 2.11.0 for Aiven for PostgreSQL released

TimescaleDB extension version 2.11.0 is now available for Aiven for PostgreSQL. It contains new features and various bug fixes on top of release 2.10.3.

Key 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

All features

• Allow pushdown of reference table joins
• Improve Realtime Continuous Aggregate performance
• Improve unique constraint support on compressed hypertables
• Support UPDATE/DELETE on compressed hypertables
• Enable JOINS for Hierarchical Continuous Aggregates
• Add parallel support for partialize_agg()
• Refactor and optimize distributed COPY
• Add support for ON CONFLICT DO UPDATE for compressed hypertables
• Skip Ordered Append when only 1 child node is present
• Propagate vacuum/analyze to compressed chunks
• Reduce decompression during constraint checking
• Optimize compressed chunk resorting
• Support sending telemetry event reports

Bug fixes

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