Releases · timescale/timescaledb

07 Jun 14:17

2.15.2

903847e

Release 2.15.2 (2024-06-07) Latest

Latest

This release contains bug fixes since the 2.15.1 release. Best practice is to upgrade at the next available opportunity.

Migrating from self-hosted TimescaleDB v2.14.x and earlier

After you run ALTER EXTENSION, you must run this SQL script. For more details, see the following pull request #6797.

If you are migrating from TimescaleDB v2.15.0 or v2.15.1, no changes are required.

Bugfixes

#6975: Fix sort pushdown for partially compressed chunks.
#6976: Fix removal of metadata function and update script.
#6978: Fix segfault in compress_chunk with a primary space partition.
#6993: Disallow hash partitioning on primary column.

Thanks

@gugu for reporting the issue with catalog corruption due to update.
@srieding for reporting an issue with partially compressed chunks and ordering on joined columns.

Contributors

gugu and srieding

Assets 6

28 May 21:10

fabriziomello

2.15.1

6a8b31f

Release 2.15.1 (2024-05-28)

This release contains bug fixes since the 2.15.0 release.
Best practice is to upgrade at the next available opportunity.

Migrating from self-hosted TimescaleDB v2.14.x and earlier

After you run ALTER EXTENSION, you must run this SQL script. For more details, see the following pull request #6797.

If you are migrating from TimescaleDB v2.15.0, no changes are required.

Bugfixes

#6540: Segmentation fault when you backfill data using COPY into a compressed chunk.
#6858: BEFORE UPDATE trigger not working correctly.
#6908: Fix time_bucket_gapfill() with timezone behaviour around daylight savings time (DST) switches.
#6911: Fix dropped chunk metadata removal in the update script.
#6940: Fix pg_upgrade failure by removing regprocedure from the catalog table.
#6957: Fix then segfault in UNION queries that contain ordering on compressed chunks.

Thanks

@DiAifU, @kiddhombre and @intermittentnrg for reporting the issues with gapfill and daylight saving time.
@edgarzamora for reporting the issue with update triggers.
@hongquan for reporting the issue with the update script.
@iliastsa and @SystemParadox for reporting the issue with COPY into a compressed chunk.

Contributors

hongquan, DiAifU, and 5 other contributors

Assets 6

08 May 15:34

fabriziomello

2.15.0

19f731d

2.15.0 (2024-05-08)

This release contains the performance improvements and bug fixes introduced since
TimescaleDB v2.14.2. Best practice is to upgrade at the next available opportunity.

Highlighted features in this release

Continuous Aggregate now supports time_bucket with origin and/or offset.
The following improvements have been introduced for hypertable compression:
- Recommend optimized defaults for segment by and order by when configuring compression through analysis of table configuration and statistics.
- Added planner support to check more kinds of WHERE conditions before decompression.
  This reduces the number of rows that have to be decompressed.
- You can now use minmax sparse indexes when you compress columns with btree indexes.
- Vectorize filters in the WHERE clause that contain text equality operators and LIKE expressions.

Deprecation warning

You can no longer create continuous aggregates using time_bucket_ng. This feature will be completely removed in the next release. Best practice is to migrate your current continuous aggregates to the new form,
This is the last release supporting PostgreSQL 13.

For self-hosted TimescaleDB v2.15.0 deployments only

After you run ALTER EXTENSION, you must run this SQL script. For more details, see the following pull requests #6797.

Complete list of features

#6382 Support for time_bucket with origin and offset in CAggs.
#6696 Improve the defaults for compression segment_by and order_by.
#6705 Add sparse minmax indexes for compressed columns that have uncompressed btree indexes.
#6754 Allow DROP CONSTRAINT on compressed hypertables.
#6767 Add metadata table _timestaledb_internal.bgw_job_stat_history for tracking job execution history.
#6798 Prevent usage of the deprecated time_bucket_ng in the CAgg definition.
#6810 Add telemetry for access methods.
#6811 Remove the no longer relevant timescaledb.allow_install_without_preload GUC.
#6837 Add migration path for CAggs using time_bucket_ng.
#6865 Update the watermark when truncating a CAgg.

Complete list of bugfixes

#6617 Fix error in show_chunks.
#6621 Remove metadata when dropping chunks.
#6677 Fix snapshot usage in CAgg invalidation scanner.
#6698 Define meaning of 0 retries for jobs as no retries.
#6717 Fix handling of compressed tables with primary or unique index in COPY path.
#6726 Fix constify cagg_watermark using window function when querying a CAgg.
#6729 Fix NULL start value handling in CAgg refresh.
#6732 Fix CAgg migration with custom timezone / date format settings.
#6752 Remove custom autovacuum setting from compressed chunks.
#6770 Fix plantime chunk exclusion for OSM chunk.
#6789 Fix deletes with subqueries and compression.
#6796 Fix a crash involving a view on a hypertable.
#6797 Fix foreign key constraint handling on compressed hypertables.
#6816 Fix handling of chunks with no constraints.
#6820 Fix a crash when the ts_hypertable_insert_blocker was called directly.
#6849 Use non-orderby compressed metadata in compressed DML.
#6867 Clean up compression settings when deleting compressed CAgg.
#6869 Fix compressed DML with constraints of form value OP column.
#6870 Fix bool expression pushdown for queries on compressed chunks.

Acknowledgments

@brasic for reporting a crash when ts_hypertable_insert_blocker was called directly.
@bvanelli for reporting an issue with the jobs retry count.
@djzurawski for reporting an error about dropping chunks.
@Dzuzepppe for reporting the issue that DELETEs using a subquery on compressed chunks was working incorrectly.
@hongquan for reporting a 'timestamp out of range' error during CAgg migrations.
@kevcenteno for reporting that the show_chunks API returned an incorrect output when 'created_before/created_after' was used with time-partitioned columns.
@mahipv for starting working on the job history PR.
@rovo89 for reporting that constify cagg_watermark was not working using the window function when querying a CAgg.

Contributors

hongquan, brasic, and 6 other contributors

Assets 6

20 Feb 09:38

svenklemm

2.14.2

8f27a70

2.14.2 (2024-02-20)

This release contains bug fixes since the 2.14.1 release.
We recommend that you upgrade at the next available opportunity.

Bugfixes

#6655 Fix segfault in cagg_validate_query
#6660 Fix refresh on empty CAgg with variable bucket
#6670 Don't try to compress osm chunks

Thanks

@kav23alex for reporting a segfault in cagg_validate_query

Contributors

kav23alex

Assets 6

14 Feb 18:10

svenklemm

2.14.1

39616e8

2.14.1 (2024-02-14)

This release contains bug fixes since the 2.14.0 release.
We recommend that you upgrade at the next available opportunity.

Features

#6630 Add views for per chunk compression settings

Bugfixes

#6636 Fixes extension update of compressed hypertables with dropped columns
#6637 Reset sequence numbers on non-rollup compression
#6639 Disable default indexscan for compression
#6651 Fix DecompressChunk path generation with per chunk settings

Thanks

@anajavi for reporting an issue with extension update of compressed hypertables

Contributors

anajavi

Assets 6

08 Feb 15:15

antekresic

2.14.0

5ede370

2.14.0 (2024-02-08)

This release contains performance improvements and bug fixes since the 2.13.1 release. We recommend that you upgrade at the next
available opportunity.

In addition, it includes these noteworthy features:

Ability to change compression settings on existing compressed hypertables at any time.
New compression settings take effect on any new chunks that are compressed after the change.
Reduced locking requirements during chunk recompression
Limiting tuple decompression during DML operations to avoid decompressing a lot of tuples and causing storage issues (100k limit, configurable)
Helper functions for determining compression settings
Plan-time chunk exclusion for real-time Continuous Aggregate by constifying the cagg_watermark function call, leading to faster queries using real-time continuous aggregates

For this release only, you will need to restart the database before running ALTER EXTENSION

Multi-node support removal announcement
Following the deprecation announcement for Multi-node in TimescaleDB 2.13,
Multi-node is no longer supported starting with TimescaleDB 2.14.

TimescaleDB 2.13 is the last version that includes multi-node support. Learn more about it here.

If you want to migrate from multi-node TimescaleDB to single-node TimescaleDB, read the
migration documentation.

Deprecation notice: recompress_chunk procedure
TimescaleDB 2.14 is the last version that will include the recompress_chunk procedure. Its
functionality will be replaced by the compress_chunk function, which, starting on TimescaleDB 2.14,
works on both uncompressed and partially compressed chunks.
The compress_chunk function should be used going forward to fully compress all types of chunks or even recompress
old fully compressed chunks using new compression settings (through the newly introduced recompress optional parameter).

Features

#6325 Add plan-time chunk exclusion for real-time CAggs
#6360 Remove support for creating Continuous Aggregates with old format
#6386 Add functions for determining compression defaults
#6410 Remove multinode public API
#6440 Allow SQLValueFunction pushdown into compressed scan
#6463 Support approximate hypertable size
#6513 Make compression settings per chunk
#6529 Remove reindex_relation from recompression
#6531 Fix if_not_exists behavior for CAgg policy with NULL offsets
#6545 Remove restrictions for changing compression settings
#6566 Limit tuple decompression during DML operations
#6579 Change compress_chunk and decompress_chunk to idempotent version by default
#6608 Add LWLock for OSM usage in loader
#6609 Deprecate recompress_chunk
#6609 Add optional recompress argument to compress_chunk

Bugfixes

#6541 Inefficient join plans on compressed hypertables.
#6491 Enable now() plantime constification with BETWEEN
#6494 Fix create_hypertable referenced by fk succeeds
#6498 Suboptimal query plans when using time_bucket with query parameters
#6507 time_bucket_gapfill with timezones doesn't handle daylight savings
#6509 Make extension state available through function
#6512 Log extension state changes
#6522 Disallow triggers on CAggs
#6523 Reduce locking level on compressed chunk index during segmentwise recompression
#6531 Fix if_not_exists behavior for CAgg policy with NULL offsets
#6571 Fix pathtarget adjustment for MergeAppend paths in aggregation pushdown code
#6575 Fix compressed chunk not found during upserts
#6592 Fix recompression policy ignoring partially compressed chunks
#6610 Ensure qsort comparison function is transitive

Thanks

@coney21 and @GStechschulte for reporting the problem with inefficient join plans on compressed hypertables.
@HollowMan6 for reporting triggers not working on materialized views of
CAggs
@jbx1 for reporting suboptimal query plans when using time_bucket with query parameters
@JerkoNikolic for reporting the issue with gapfill and DST
@pdipesh02 for working on removing the old Continuous Aggregate format
@raymalt and @martinhale for reporting very slow query plans on realtime CAggs queries

Contributors

jbx1, martinhale, and 6 other contributors

Assets 6

09 Jan 10:24

jnidzwetzki

2.13.1

27398c4

2.13.1 (2024-01-09)

This release contains bug fixes since the 2.13.0 release.
We recommend that you upgrade at the next available opportunity.

Bugfixes

#6365 Use numrows_pre_compression in approximate row count
#6377 Use processed group clauses in PG16
#6384 Change bgw_log_level to use PGC_SUSET
#6393 Disable vectorized sum for expressions.
#6405 Read CAgg watermark from materialized data
#6408 Fix groupby pathkeys for gapfill in PG16
#6428 Fix index matching during DML decompression
#6439 Fix compressed chunk permission handling on PG16
#6443 Fix lost concurrent CAgg updates
#6454 Fix unique expression indexes on compressed chunks
#6465 Fix use of freed path in decompression sort logic

Thanks

@MA-MacDonald for reporting an issue with gapfill in PG16
@aarondglover for reporting an issue with unique expression indexes on compressed chunks
@adriangb for reporting an issue with security barrier views on pg16

Contributors

adriangb, MA-MacDonald, and aarondglover

Assets 6

28 Nov 14:21

jnidzwetzki

2.13.0

96f81a3

2.13.0 (2023-11-28)

This release contains performance improvements, an improved hypertable DDL API
and bug fixes since the 2.12.2 release. We recommend that you upgrade at the next
available opportunity.

In addition, it includes these noteworthy features:

Full PostgreSQL 16 support for all existing features
Vectorized aggregation execution for sum()
Track chunk creation time used in retention/compression policies

Deprecation notice: Multi-node support
TimescaleDB 2.13 is the last version that will include multi-node support. Multi-node
support in 2.13 is available for PostgreSQL 13, 14 and 15. Learn more about it
here.

If you want to migrate from multi-node TimescaleDB to single-node TimescaleDB read the
migration documentation.

PostgreSQL 13 deprecation announcement
We will continue supporting PostgreSQL 13 until April 2024. Sooner to that time, we will announce the specific version of TimescaleDB in which PostgreSQL 13 support will not be included going forward.

Starting from TimescaleDB 2.13.0

No Amazon Machine Images (AMI) are published. If you previously used AMI, please
use another installation method
Continuous Aggregates are materialized only (non-realtime) by default

Features

#5575 Add chunk-wise sorted paths for compressed chunks
#5761 Simplify hypertable DDL API
#5890 Reduce WAL activity by freezing compressed tuples immediately
#6050 Vectorized aggregation execution for sum()
#6062 Add metadata for chunk creation time
#6077 Make Continous Aggregates materialized only (non-realtime) by default
#6177 Change show_chunks/drop_chunks using chunk creation time
#6178 Show batches/tuples decompressed during DML operations in EXPLAIN output
#6185 Keep track of catalog version
#6227 Use creation time in retention/compression policy
#6307 Add SQL function cagg_validate_query

Bugfixes

#6188 Add GUC for setting background worker log level
#6222 Allow enabling compression on hypertable with unique expression index
#6240 Check if worker registration succeeded
#6254 Fix exception detail passing in compression_policy_execute
#6264 Fix missing bms_del_member result assignment
#6275 Fix negative bitmapset member not allowed in compression
#6280 Potential data loss when compressing a table with a partial index that matches compression order.
#6289 Add support for startup chunk exclusion with aggs
#6290 Repair relacl on upgrade
#6297 Fix segfault when creating a cagg using a NULL width in time bucket function
#6305 Make timescaledb_functions.makeaclitem strict
#6332 Fix typmod and collation for segmentby columns
#6339 Fix tablespace with constraints
#6343 Enable segmentwise recompression in compression policy

Thanks

@fetchezar for reporting an issue with compression policy error messages
@jflambert for reporting the background worker log level issue
@torazem for reporting an issue with compression and large oids
@fetchezar for reporting an issue in the compression policy
@lyp-bobi for reporting an issue with tablespace with constraints
@pdipesh02 for contributing to the implementation of the metadata for chunk creation time,
the generalized hypertable API, and show_chunks/drop_chunks using chunk creation time
@lkshminarayanan for all his work on PG16 support