TimescaleDB extensions 2.10.0 and 2.10.1 for Aiven for PostgreSQL released

TimescaleDB extension versions 2.10.0 and 2.10.1 are now available for Aiven for PostgreSQL. They contain new features and bug fixes on top of release 2.9.3.

Key features

• Joins in continuous aggregates that are defined over hypertables (upcoming in a follow-up release: the support for joins in hierarchical continuous aggregates)
• Re-architecture of how compression works: ~2x improvement on the INSERT rate into compressed chunks.
• Full PostgreSQL 15 support for all existing features (upcoming in a follow-up release: the support for the newly-introduced MERGE command on hypertables)

Bug fixes

• Support continuous aggregates names in hypertable_(detailed_)size
• Fix concurrent locking with the chunk_data_node table
• Fix incorrect memory handling
• Use NameData and namestrcpy for names
• Set PortalContext when starting a job
• Fix the uninitialized bucket_info variable
• Make the copy fetcher more asynchronous
• Fix the num_chunks inconsistency in the hypertables view
• Fix the column names handling in old-style continuous aggregates
• Fix the multi-node DML HA performance regression
• Fix the hierarchical continuous aggregates chunk_interval_size
• Fix sub-second intervals in hierarchical continuous aggregates
• Fix the use of the prepared statement in the async module
• Add a role-level security to the job error log
• Fix the next_start calculation for fixed schedules
• Fix the enabling of compression on continuous aggregates with columns requiring quotation marks