2.5.0 (2021-10-28)

This release adds major new features since the 2.4.2 release.
We deem it moderate priority for upgrading.

This release includes these noteworthy features:

• Continuous Aggregates for Distributed Hypertables
• Support for PostgreSQL 14
• Experimental: Support for timezones in time_bucket_ng(), including
  the origin argument

This release also includes several bug fixes.

Features

• #3034 Add support for PostgreSQL 14
• #3435 Add continuous aggregates for distributed hypertables
• #3505 Add support for timezones in time_bucket_ng()

Bugfixes

• #3580 Fix memory context bug executing TRUNCATE
• #3592 Allow alter column type on distributed hypertable
• #3598 Improve evaluation of stable functions such as now() on access
  node
• #3618 Fix execution of refresh_caggs from user actions
• #3625 Add shared dependencies when creating chunk
• #3626 Fix memory context bug executing TRUNCATE
• #3627 Schema qualify UDTs in multi-node
• #3638 Allow owner change of a data node
• #3654 Fix index attnum mapping in reorder_chunk
• #3661 Fix SkipScan path generation with constant DISTINCT column
• #3667 Fix compress_policy for multi txn handling
• #3673 Fix distributed hypertable DROP within a procedure
• #3701 Allow anyone to use size utilities on distributed hypertables
• #3708 Fix crash in get_aggsplit
• #3709 Fix ordered append pathkey check
• #3712 Fix GRANT/REVOKE ALL IN SCHEMA handling
• #3717 Support transparent decompression on individual chunks
• #3724 Fix inserts into compressed chunks on hypertables with caggs
• #3727 Fix DirectFunctionCall crash in distributed_exec
• #3728 Fix SkipScan with varchar column
• #3733 Fix ANALYZE crash with custom statistics for custom types
• #3747 Always reset expr context in DecompressChunk

Thanks

• @binakot and @sebvett for reporting an issue with DISTINCT queries
• @hardikm10, @DavidPavlicek and @pafiti for reporting bugs on TRUNCATE
• @mjf for reporting an issue with ordered append and JOINs
• @phemmer for reporting the issues on multinode with aggregate queries and evaluation of now()
• @abolognino for reporting an issue with INSERTs into compressed hypertables that have cagg
• @tanglebones for reporting the ANALYZE crash with custom types on multinode
• @amadeubarbosa and @felipenogueirajack for reporting crash using JSONB column in compressed chunks

2.4.2 (2021-09-21)

This release contains bug fixes since the 2.4.1 release. We deem it high priority to upgrade.

Bugfixes

#3437 Rename on all continuous aggregate objects
#3469 Use signal-safe functions in signal handler
#3520 Modify compression job processing logic
#3527 Fix time_bucket_ng behaviour with origin argument
#3532 Fix bootstrap with regresschecks disabled
#3574 Fix failure on job execution by background worker
#3590 Call cleanup functions on backend exit

Thanks

@jankatins for reporting a crash with background workers
@LutzWeischerFujitsu for reporting an issue with bootstrap

2.4.1 (2021-08-19)

This release contains bug fixes since the 2.4.0 release. We deem it
high priority to upgrade.

The release fixes continuous aggregate refresh for postgres 12.8 and
13.4, a crash with ALTER TABLE commands and a crash with continuous
aggregates with HAVING clause.

Bugfixes

• #3430 Fix havingqual processing for continuous aggregates
• #3468 Disable tests by default if tools are not found
• #3462 Fix crash while tracking alter table commands
• #3489 Fix continuous agg bgw job failure for PG 12.8 and 13.4
• #3494 Improve error message when adding data nodes

Thanks

• @brianbenns for reporting a segfault with continuous aggregates
• @usego for reporting an issue with continuous aggregate refresh on PG 13.4

2.4.0 (2021-08-03)

This release adds new experimental features since the 2.3.1 release.

The experimental features in this release are:

• APIs for chunk manipulation across data nodes in a distributed
  hypertable setup. This includes the ability to add a data node and move
  chunks to the new data node for cluster rebalancing.
• The time_bucket_ng function, a newer version of time_bucket. This
  function supports years, months, days, hours, minutes, and seconds.

We’re committed to developing these experiments, giving the community
a chance to provide early feedback and influence the direction of
TimescaleDB’s development. We’ll travel faster with your input!

Please create your feedback as a GitHub issue (using the
experimental-schema label), describe what you found, and tell us the
steps or share the code snip to recreate it.

This release also includes several bug fixes.

PostgreSQL 11 deprecation announcement
Timescale is working hard on our next exciting features. To make that
possible, we require functionality that is available in Postgres 12 and
above. Postgres 11 is not supported with TimescaleDB 2.4.

Experimental Features

• #3293 Add timescaledb_experimental schema
• #3302 Add block_new_chunks and allow_new_chunks API to experimental
  schema. Add chunk based refresh_continuous_aggregate.
• #3211 Introduce experimental time_bucket_ng function
• #3366 Allow use of experimental time_bucket_ng function in continuous aggregates
• #3408 Support for seconds, minutes and hours in time_bucket_ng
• #3446 Implement cleanup for chunk copy/move.

Bugfixes

• #3401 Fix segfault for RelOptInfo without fdw_private
• #3411 Verify compressed chunk validity for compressed path
• #3416 Fix targetlist names for continuous aggregate views
• #3434 Remove extension check from relcache invalidation callback
• #3440 Fix remote_tx_heal_data_node to work with only current database

Thanks

• @fvannee for reporting an issue with hypertable expansion in functions
• @amalek215 for reporting an issue with cache invalidation during pg_class vacuum full
• @hardikm10 for reporting an issue with inserting into compressed chunks
• @dberardo-com and @iancmcc for reporting an issue with extension updates after renaming columns of continuous aggregates.

2.3.1 (2021-07-07)

This maintenance release contains bugfixes since the 2.3.0 release. We
deem it moderate priority for upgrading. The release introduces the
possibility of generating downgrade scripts, improves the trigger
handling for distributed hypertables, adds some more randomness to
chunk assignment to avoid thundering herd issues in chunk assignment,
and fixes some issues in update handling as well as some other bugs.

Bugfixes

• #3279 Add some more randomness to chunk assignment
• #3288 Fix failed update with parallel workers
• #3300 Improve trigger handling on distributed hypertables
• #3304 Remove paths that reference parent relids for compressed chunks
• #3305 Fix pull_varnos miscomputation of relids set
• #3310 Generate downgrade script
• #3314 Fix heap buffer overflow in hypertable expansion
• #3317 Fix heap buffer overflow in remote connection cache.
• #3327 Make aggregate in caggs fully qualified
• #3327 Make aggregates in caggs fully qualified
• #3336 Fix pg_init_privs objsubid handling
• #3345 Fix SkipScan distinct column identification
• #3355 Fix heap buffer overflow when renaming compressed hypertable columns.
• #3367 Improve DecompressChunk qual pushdown
• #3377 Fix bad use of repalloc

Thanks

• @db-adrian for reporting an issue when accessing cagg view through postgres_fdw
• @fncaldas and @pgwhalen for reporting an issue accessing caggs when public is not in search_path
• @fvannee, @mglonnro and @ebreijo for reporting an issue with the upgrade script
• @fvannee for reporting a performance regression with SkipScan

The music for this release was Izzy Stradlin's On Down the Road.

2.3.0 (2021-05-25)

This release adds major new features since the 2.2.1 release.
We deem it moderate priority for upgrading.

This release adds support for inserting data into compressed chunks
and improves performance when inserting data into distributed hypertables.
Distributed hypertables now also support triggers and compression policies.

The bug fixes in this release address issues related to the handling
of privileges on compressed hypertables, locking, and triggers with transition tables.

Features

• #3116 Add distributed hypertable compression policies
• #3162 Use COPY when executing distributed INSERTs
• #3199 Add GENERATED column support on distributed hypertables
• #3210 Add trigger support on distributed hypertables
• #3230 Support for inserts into compressed chunks

Bugfixes

• #3213 Propagate grants to compressed hypertables
• #3229 Use correct lock mode when updating chunk
• #3243 Fix assertion failure in decompress_chunk_plan_create
• #3250 Fix constraint triggers on hypertables
• #3251 Fix segmentation fault due to incorrect call to chunk_scan_internal
• #3252 Fix blocking triggers with transition tables

Thanks

• @yyjdelete for reporting a crash with decompress_chunk and identifying the bug in the code
• @fabriziomello for documenting the prerequisites when compiling against PostgreSQL 13

The music for this release was Queen's The Works.

2.2.1 (2021-05-05)

This maintenance release contains bugfixes since the 2.2.0 release. We
deem it high priority for upgrading.

This release extends Skip Scan to multinode by enabling the pushdown
of DISTINCT to data nodes. It also fixes a number of bugs in the
implementation of Skip Scan, in distributed hypertables, in creation
of indexes, in compression, and in policies.

Features

• #3113 Pushdown "SELECT DISTINCT" in multi-node to allow use of Skip
  Scan

Bugfixes

• #3101 Use commit date in get_git_commit()
• #3102 Fix REINDEX TABLE for distributed hypertables
• #3104 Fix use after free in add_reorder_policy
• #3106 Fix use after free in chunk_api_get_chunk_stats
• #3109 Copy recreated object permissions on update
• #3111 Fix CMAKE_BUILD_TYPE check
• #3112 Use %u to format Oid instead of %d
• #3118 Fix use after free in cache
• #3123 Fix crash while using REINDEX TABLE CONCURRENTLY
• #3135 Fix SkipScan path generation in DISTINCT queries with expressions
• #3146 Fix SkipScan for IndexPaths without pathkeys
• #3147 Skip ChunkAppend if AppendPath has no children
• #3148 Make SELECT DISTINCT handle non-var targetlists
• #3151 Fix fdw_relinfo_get assertion failure on DELETE
• #3155 Inherit CFLAGS from PostgreSQL
• #3169 Fix incorrect type cast in compression policy
• #3183 Fix segfault in calculate_chunk_interval
• #3185 Fix wrong datatype for integer based retention policy

Thanks

• @Dead2, @dv8472 and @einsibjarni for reporting an issue with multinode queries and views
• @aelg for reporting an issue with policies on integer-based hypertables
• @hperez75 for reporting an issue with Skip Scan
• @nathanloisel for reporting an issue with compression on hypertables with integer-based timestamps
• @xin-hedera for fixing an issue with compression on hypertables with integer-based timestamps

The music for this release was Justin Timberlake's The 20/20 Experience – 2 of 2.

2.2.0 (2021-04-13)

This release adds major new features since the 2.1.1 release.
We deem it moderate priority for upgrading.

This release adds the Skip Scan optimization, which significantly
improves the performance of queries with DISTINCT ON. This
optimization is not yet available for queries on distributed
hypertables.

This release also adds a function to create a distributed
restore point, which allows performing a consistent restore of a
multi-node cluster from a backup.

The bug fixes in this release address issues with size and stats
functions, high memory usage in distributed inserts, slow distributed
ORDER BY queries, indexes involving INCLUDE, and single chunk query
planning.

PostgreSQL 11 deprecation announcement

Timescale is working hard on our next exciting features. To make that
possible, we require functionality that is unfortunately absent on
PostgreSQL 11. For this reason, we will continue supporting PostgreSQL
11 until mid-June 2021. Sooner to that time, we will announce the
specific version of TimescaleDB in which PostgreSQL 11 support will
not be included going forward.

Major Features

• #2843 Add distributed restore point functionality
• #3000 SkipScan to speed up SELECT DISTINCT

Bugfixes

• #2989 Refactor and harden size and stats functions
• #3058 Reduce memory usage for distributed inserts
• #3067 Fix extremely slow multi-node order by queries
• #3082 Fix chunk index column name mapping
• #3083 Keep Append pathkeys in ChunkAppend

Thanks

• @BowenGG for reporting an issue with indexes with INCLUDE
• @fvannee for reporting an issue with ChunkAppend pathkeys
• @pedrokost and @RobAtticus for reporting an issue with size
  functions on empty hypertables
• @phemmer and @ryanbooz for reporting issues with slow
  multi-node order by queries
• @stephane-moreau for reporting an issue with high memory usage during
  single-transaction inserts on a distributed hypertable.

The music for this release was Michael Jackson's Thriller.

2.1.1 (2021-03-29)

This maintenance release contains bugfixes since the 2.1.0 release. We
deem it high priority for upgrading.

The bug fixes in this release address issues with CREATE INDEX and
UPSERT for hypertables, custom jobs, and gapfill queries.

This release marks TimescaleDB as a trusted extension in PG13, so that
superuser privileges are not required anymore to install the extension.

Minor features

• #2998 Mark timescaledb as trusted extension

Bugfixes

• #2948 Fix off by 4 error in histogram deserialize
• #2974 Fix index creation for hypertables with dropped columns
• #2990 Fix segfault in job_config_check for cagg
• #2987 Fix crash due to txns in emit_log_hook_callback
• #3042 Commit end transaction for CREATE INDEX
• #3053 Fix gapfill/hashagg planner interaction
• #3059 Fix UPSERT on hypertables with columns with defaults

Thanks

• @eloyekunle and @kitwestneat for reporting an issue with UPSERT
• @jocrau for reporting an issue with index creation
• @kev009 for fixing a compilation issue
• @majozv and @pehlert for reporting an issue with time_bucket_gapfill

The music for this release was David Bowie's Let's Dance.

2.1.0 (2021-02-22)

This release adds major new features since the 2.0.2 release.
We deem it moderate priority for upgrading.

This release adds the long-awaited support for PostgreSQL 13 to TimescaleDB.
The minimum required PostgreSQL 13 version is 13.2 due to a security vulnerability
affecting TimescaleDB functionality present in earlier versions of PostgreSQL 13.

This release also relaxes some restrictions for compressed hypertables;
namely, TimescaleDB now supports adding columns to compressed hypertables
and renaming columns of compressed hypertables.

Major Features

• #2779 Add support for PostgreSQL 13

Minor features

• #2736 Support adding columns to hypertables with compression enabled
• #2909 Support renaming columns of hypertables with compression enabled

The music for this release was Rush's 2112.