TimescaleDB extensions 2.12.0 and 2.12.1 for Aiven for PostgreSQL^® released

TimescaleDB extension versions 2.12.0 and 2.12.1 are now available for Aiven for PostgreSQL®. They introduce new features and bug fixes on top of release 2.11.2.

Features

• Insert into index during chunk compression
• MERGE support on hypertables
• Make hypertables support replica identity
• Index scan support during UPDATE/DELETE on compressed hypertables
• Support for partial aggregations at chunk level
• Enable ChunkAppend for partially compressed chunks
• Improve the number of parallel workers for decompression
• Enable altering job schedule type through alter_job
• Make logrepl markers for (partial) decompressions
• Relax invalidation threshold table-level lock to row-level when refreshing a Continuous Aggregate
• Support CAgg names in chunk_detailed_size
• Make set_chunk_time_interval CAggs aware
• Allow ALTER TABLE ... REPLICA IDENTITY (FULL|INDEX) on materialized hypertables (continuous aggregates)
• Add job exit status and runtime to log
• CREATE INDEX ONLY ON hypertable creates index on chunks

Bug fixes

• Fix planner distributed table count
• Avoid decompressing batches using an empty slot
• Fix concurrency errors in OSM API
• Do not throw an error when deprecation GUC cannot be read
• Fix interval calculation for hierarchical CAggs
• Check unique indexes when enabling compression
• _timescaledb_internal.create_compressed_chunk doesn't account for existing uncompressed rows
• Move functions to _timescaledb_functions schema
• Chunk_create must add an existing table or fail
• Fix duplicates on partially compressed chunk reads
• Fix crash in COPY from program returning error
• Place data in first/last function in correct mctx
• Call eq_func correctly in time_bucket_gapfill
• Correct row count in EXPLAIN ANALYZE INSERT .. ON CONFLICT output
• Fix server crash on UPDATE of compressed chunk
• Fix server crash when using duplicate segmentby column
• Fix segfault in set_integer_now_func
• Fix approximate_row_count for CAggs
• Improve compressed DML datatype handling
• Propagate parameter changes to decompress child nodes
• Schedule compression policy more often