TimescaleDB release notes

This page contains release notes for TimescaleDB 2.10.0 and newer. For release notes for older versions, see the past releases section.

Note

Want to stay up-to-date with new releases? You can subscribe to new releases on GitHub and be notified by email whenever a new release is available. On the Github page, click Watch, select Custom and then check Releases.

These release notes are for the release of TimescaleDB 2.11.0 on 2023-05-22.

Note

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 new 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
• Performance improvements for real-time hierarchical continuous aggregates

• #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

• #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

Timescale 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

• #5583 Fix parameterization in DecompressChunk path generation
• #5602 Fix broken CAgg with JOIN repair function

These release notes are for the release of TimescaleDB 2.10.2 on 2023-04-20.

Note

This release contains bug fixes since the last release. It is considered low priority for upgrading. Upgrade your TimescaleDB installation at your next opportunity.

• #5410 Fix file trailer handling in the COPY fetcher
• #5446 Add checks for malloc failure in libpq calls
• #5233 Out of on_proc_exit slots on guc license change
• #5428 Use consistent snapshots when scanning metadata
• #5499 Do not segfault on large histogram() parameters
• #5470 Ensure superuser perms during copy/move chunk
• #5500 Fix when no FROM clause in continuous aggregate definition
• #5433 Fix join rte in CAggs with joins
• #5556 Fix duplicated entries on timescaledb_experimental.policies view
• #5462 Fix segfault after column drop on compressed table
• #5543 Copy scheduled_jobs list before sorting it
• #5497 Allow named time_bucket arguments in Cagg definition
• #5544 Fix refresh from beginning of Continuous Aggregate with variable time bucket
• #5558 Use regrole for job owner
• #5542 Enable indexscan on uncompressed part of partially compressed chunks

Timescale thanks:

• @nikolaps for reporting an issue with the COPY fetcher
• @S-imo-n for reporting the issue on Background Worker Scheduler crash
• @geezhu for reporting issue on segfault in historgram()
• @mwahlhuetter for reporting the issue with joins in CAggs
• @mwahlhuetter for reporting issue with duplicated entries on timescaledb_experimental.policies view
• @H25E for reporting error refreshing from beginning of a Continuous Aggregate with variable time bucket

These release notes are for the release of Timescale 2.10.1 on 2023-03-07.

Note

This release contains bug fixes since the last release. It is considered low priority for upgrading. Upgrade your TimescaleDB installation at your next opportunity.

• #5159 Support Continuous Aggregates names in hypertable(detailed)size
• #5226 Fix concurrent locking with chunk_data_node table
• #5317 Fix some incorrect memory handling
• #5336 Use NameData and namestrcpy for names
• #5343 Set PortalContext when starting job
• #5360 Fix uninitialized bucket_info variable
• #5362 Make copy fetcher more async
• #5364 Fix num_chunks inconsistency in hypertables view
• #5367 Fix column name handling in old-style continuous aggregates
• #5378 Fix multinode DML HA performance regression
• #5384 Fix Hierarchical Continuous Aggregates chunk_interval_size

Timescale thanks:

• @justinozavala for reporting an issue with PL/Python procedures in the background worker
• @Medvecrab for discovering an issue with copying NameData when forming heap tuples.
• @pushpeepkmonroe for discovering an issue in upgrading old-style continuous aggregates with renamed columns

These release notes are for the release of TimescaleDB 2.10.1 on 2023-03-07.

Important

This release contains new features and bug fixes since the last release. It is considered moderate priority for upgrading. Upgrade your TimescaleDB installation as soon as possible.

This release includes these new features:

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

This release deprecates these features:

• PostgreSQL 12 is now deprecated in TimescaleDB, and remains supported until July 2023. For more information about upgrading PostgreSQL, see the Upgrading PostgreSQL section.
• The older format of continuous aggregates is now deprecated, and remains supported until July 2023. For more information about the new continuous aggregate format, see the continuous aggregates section.

• #4874 Allow joins in continuous aggregates
• #4926 Refactor INSERT into compressed chunks
• #5241 Allow RETURNING clause when inserting into compressed chunks
• #5245 Manage life-cycle of connections via memory contexts
• #5246 Make connection establishment interruptible
• #5253 Make data node command execution interruptible
• #5262 Extend enabling compression on a continuous aggregrate with 'compress_segmentby' and 'compress_orderby' parameters

• #5214 Fix use of prepared statement in async module
• #5218 Add role-level security to job error log
• #5239 Fix next_start calculation for fixed schedules
• #5290 Fix enabling compression on continuous aggregates with columns requiring quotation

Timescale thanks:

• @henriquegelio for reporting the issue on fixed schedules

For release notes for older TimescaleDB versions, see the past releases section.