Releases · timescale/timescaledb

06 Oct 07:27

jnidzwetzki

2.8.1

6507848

2.8.1 (2022-10-06)

This release is a patch release. We recommend that you upgrade at the next available opportunity.

Bugfixes

#4454 Keep locks after reading job status
#4658 Fix error when querying a compressed hypertable with compress_segmentby on an enum column
#4671 Fix a possible error while flushing the COPY data
#4675 Fix bad TupleTableSlot drop
#4676 Fix a deadlock when decompressing chunks and performing SELECTs
#4685 Fix chunk exclusion for space partitions in SELECT FOR UPDATE queries
#4694 Change parameter names of cagg_migrate procedure
#4698 Do not use row-by-row fetcher for parameterized plans
#4711 Remove support for procedures as custom checks
#4712 Fix assertion failure in constify_now
#4713 Fix Continuous Aggregate migration policies
#4720 Fix chunk exclusion for prepared statements and dst changes
#4726 Fix gapfill function signature
#4737 Fix join on time column of compressed chunk
#4738 Fix error when waiting for remote COPY to finish
#4739 Fix continuous aggregate migrate check constraint
#4760 Fix segfault when INNER JOINing hypertables
#4767 Fix permission issues on index creation for CAggs

Thanks

@boxhock and @cocowalla for reporting a segfault when JOINing hypertables
@carobme for reporting constraint error during continuous aggregate migration
@choisnetm, @dustinsorensen, @jayadevanm and @joeyberkovitz for reporting a problem with JOINs on compressed hypertables
@daniel-k for reporting a background worker crash
@justinpryzby for reporting an error when compressing very wide tables
@maxtwardowski for reporting problems with chunk exclusion and space partitions
@yuezhihan for reporting GROUP BY error when having compress_segmentby on an enum column

Contributors

daniel-k, carobme, and 9 other contributors

Assets 2

31 Aug 18:16

svenklemm

2.8.0

2410bdf

2.8.0 (2022-08-31)

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

This release includes these noteworthy features:

time_bucket now supports bucketing by month, year and timezone
Improve performance of bulk SELECT and COPY for distributed hypertables
1 step CAgg policy management
Migrate Continuous Aggregates to the new format

Features

#4188 Use COPY protocol in row-by-row fetcher
#4307 Mark partialize_agg as parallel safe
#4380 Enable chunk exclusion for space dimensions in UPDATE/DELETE
#4384 Add schedule_interval to policies
#4390 Faster lookup of chunks by point
#4393 Support intervals with day component when constifying now()
#4397 Support intervals with month component when constifying now()
#4405 Support ON CONFLICT ON CONSTRAINT for hypertables
#4412 Add telemetry about replication
#4415 Drop remote data when detaching data node
#4416 Handle TRUNCATE TABLE on chunks
#4425 Add parameter check_config to alter_job
#4430 Create index on Continuous Aggregates
#4439 Allow ORDER BY on continuous aggregates
#4443 Add stateful partition mappings
#4484 Use non-blocking data node connections for COPY
#4495 Support add_dimension() with existing data
#4502 Add chunks to baserel cache on chunk exclusion
#4545 Add hypertable distributed argument and defaults
#4552 Migrate Continuous Aggregates to the new format
#4556 Add runtime exclusion for hypertables
#4561 Change get_git_commit to return full commit hash
#4563 1 step CAgg policy management
#4641 Allow bucketing by month, year, century in time_bucket and time_bucket_gapfill
#4642 Add timezone support to time_bucket

Bugfixes

#4359 Create composite index on segmentby columns
#4374 Remove constified now() constraints from plan
#4416 Handle TRUNCATE TABLE on chunks
#4478 Synchronize chunk cache sizes
#4486 Adding boolean column with default value doesn't work on compressed table
#4512 Fix unaligned pointer access
#4519 Throw better error message on incompatible row fetcher settings
#4549 Fix dump_meta_data for windows
#4553 Fix timescaledb_post_restore GUC handling
#4573 Load TSL library on compressed_data_out call
#4575 Fix use of get_partition_hash and get_partition_for_key inside an IMMUTABLE function
#4577 Fix segfaults in compression code with corrupt data
#4580 Handle default privileges on CAggs properly
#4582 Fix assertion in GRANT .. ON ALL TABLES IN SCHEMA
#4583 Fix partitioning functions
#4589 Fix rename for distributed hypertable
#4601 Reset compression sequence when group resets
#4611 Fix a potential OOM when loading large data sets into a hypertable
#4624 Fix heap buffer overflow
#4627 Fix telemetry initialization
#4631 Ensure TSL library is loaded on database upgrades
#4646 Fix time_bucket_ng origin handling
#4647 Fix the error "SubPlan found with no parent plan" that occurred if using joins in RETURNING clause.

Thanks

@AlmiS for reporting error on get_partition_hash executed inside an IMMUTABLE function
@Creatation for reporting an issue with renaming hypertables
@janko for reporting an issue when adding bool column with default value to compressed hypertable
@jayadevanm for reporting error of TRUNCATE TABLE on compressed chunk
@michaelkitson for reporting permission errors using default privileges on Continuous Aggregates
@mwahlhuetter for reporting error in joins in RETURNING clause
@ninjaltd and @mrksngl for reporting a potential OOM when loading large data sets into a hypertable
@PBudmark for reporting an issue with dump_meta_data.sql on Windows
@ssmoss for reporting an issue with time_bucket_ng origin handling

Contributors

janko, michaelkitson, and 8 other contributors

Assets 2

25 Jul 06:51

svenklemm

2.7.2

54ab29a

2.7.2 (2022-07-25)

This release is a patch release. We recommend that you upgrade at the
next available opportunity.
Among other things this release fixes several memory leaks, handling
of TOASTed values in GapFill and parameter handling in prepared statements.

Bugfixes

#4517 Fix prepared statement param handling in ChunkAppend
#4522 Fix ANALYZE on dist hypertable for a set of nodes
#4526 Fix gapfill group comparison for TOASTed values
#4527 Handle stats properly for range types
#4532 Fix memory leak in function telemetry
#4534 Use explicit memory context with hash_create
#4538 Fix chunk creation on hypertables with non-default statistics

Thanks

@3a6u9ka, @bgemmill, @hongquan, @stl-leonid-kalmaev and @victor-sudakov for reporting a memory leak
@hleung2021 and @laocaixw for reporting an issue with parameter handling in prepared statements

Contributors

hongquan, bgemmill, and 5 other contributors

Assets 2

25 Jul 06:24

svenklemm

2.7.1

4c31440

2.7.1 (2022-07-07)

This release is a patch release. We recommend that you upgrade at the
next available opportunity.

Bugfixes

#4494 Handle timescaledb versions aptly in multinode
#4493 Segfault when executing IMMUTABLE functions
#4482 Fix race conditions during chunk (de)compression
#4367 Improved buffer management in the copy operator
#4375 Don't ask for orderby column if default already set
#4400 Use our implementation of find_em_expr_for_rel for PG15+
#4408 Fix crash during insert into distributed hypertable
#4411 Add shmem_request_hook
#4437 Fix segfault in subscription_exec
#4442 Fix perms in copy/move chunk
#4450 Retain hypertable ownership on attach_data_node
#4451 Repair numeric partial state on the fly
#4463 Fix empty bytea handlng with distributed tables
#4469 Better superuser handling for move_chunk

Features

#4244 Function telemetry
#4287 Add internal api for foreign table chunk
#4470 Block drop chunk if chunk is in frozen state
#4464 Add internal api to associate a hypertable with custom jobs

Thanks

@xin-hedera Finding bug in empty bytea values for distributed tables
@jflambert for reporting a bug with IMMUTABLE functions
@nikugogoi for reporting a bug with CTEs and upserts on distributed hypertables

Contributors

jflambert, nikugogoi, and xin-hedera

Assets 2

24 May 08:51

svenklemm

2.7.0

7d3c092

2.7.0 (2022-05-24)

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

This release includes these noteworthy features:

Optimize continuous aggregate query performance and storage
The following query clauses and functions can now be used in a continuous
aggregate: FILTER, DISTINCT, ORDER BY as well as Ordered-Set Aggregate
and Hypothetical-Set Aggregate
Optimize now() query planning time
Improve COPY insert performance
Improve performance of UPDATE/DELETE on PG14 by excluding chunks

This release also includes several bug fixes.

If you are upgrading from a previous version and were using compression
with a non-default collation on a segmentby-column you should recompress
those hypertables.

Features

#4045 Custom origin's support in CAGGs
#4120 Add logging for retention policy
#4158 Allow ANALYZE command on a data node directly
#4169 Add support for chunk exclusion on DELETE to PG14
#4209 Add support for chunk exclusion on UPDATE to PG14
#4269 Continuous Aggregates finals form
#4301 Add support for bulk inserts in COPY operator
#4311 Support non-superuser move chunk operations
#4330 Add GUC "bgw_launcher_poll_time"
#4340 Enable now() usage in plan-time chunk exclusion

Bugfixes

#3899 Fix segfault in Continuous Aggregates
#4225 Fix TRUNCATE error as non-owner on hypertable
#4236 Fix potential wrong order of results for compressed hypertable with a non-default collation
#4249 Fix option "timescaledb.create_group_indexes"
#4251 Fix INSERT into compressed chunks with dropped columns
#4255 Fix option "timescaledb.create_group_indexes"
#4259 Fix logic bug in extension update script
#4269 Fix bad Continuous Aggregate view definition reported in #4233
#4289 Support moving compressed chunks between data nodes
#4300 Fix refresh window cap for cagg refresh policy
#4315 Fix memory leak in scheduler
#4323 Remove printouts from signal handlers
#4342 Fix move chunk cleanup logic
#4349 Fix crashes in functions using AlterTableInternal
#4358 Fix crash and other issues in telemetry reporter

Thanks

@abrownsword for reporting a bug in the telemetry reporter and testing the fix
@jsoref for fixing various misspellings in code, comments and documentation
@yalon for reporting an error with ALTER TABLE RENAME on distributed hypertables
@zhuizhuhaomeng for reporting and fixing a memory leak in our scheduler

Contributors

yalon, jsoref, and 2 other contributors

Assets 2

12 Apr 10:50

svenklemm

2.6.1

9ae47c6

2.6.1 (2022-04-11)

This release is a patch release. We recommend that you upgrade at the next available opportunity.

Bugfixes

#4121 Fix RENAME TO/SET SCHEMA on distributed hypertable
#4122 Fix segfault on INSERT into distributed hypertable
#4142 Ignore invalid relid when deleting hypertable
#4159 Fix ADD COLUMN IF NOT EXISTS error on compressed hypertable
#4161 Fix memory handling during scans
#4176 Fix remote EXPLAIN with parameterized queries
#4181 Fix spelling errors and omissions
#4186 Fix owner change for distributed hypertable
#4192 Abort sessions after extension reload
#4193 Fix relcache callback handling causing crashes
#4199 Remove signal-unsafe calls from signal handlers
#4219 Do not modify aggregation state in finalize

Thanks

@abrownsword for reporting a crash in the telemetry reporter (fixed with #4161)
@daydayup863 for reporting issue with remote explain

Contributors

abrownsword and daydayup863

Assets 2

23 Feb 13:59

NunoFilipeSantos

2.6.0

23962c8

2.6.0 (2022-02-16)

This release is a medium priority for upgrade. We recommend that you upgrade at the next available opportunity.

This release adds major new features since the 2.5.2 release, including:

Continuous aggregates with compression
time_bucket_ng support for N months and timezones on continuous aggregates
You can read more about this release on our blog post. This release also contains bug fixes since the 2.5.0 release.

The experimental features in the 2.6 release are:

The time_bucket_ng function, a newer version of time_bucket. This function supports years, months, days, hours, minutes, seconds, and timezones.
time_bucket_ng support for N months and Timezones on continuous aggregates.
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.

Features

#3768 Allow ALTER TABLE ADD COLUMN with DEFAULT on compressed hypertable
#3769 Allow ALTER TABLE DROP COLUMN on compressed hypertable
#3873 Enable compression on continuous aggregates
#3943 Optimize first/last
#3945 Add support for ALTER SCHEMA on multi-node
#3949 Add support for DROP SCHEMA on multi-node
#3977 Timezones support in CAGGs

Bugfixes

#3808 Properly handle max_retries option
#3863 Fix remote transaction heal logic
#3869 Fix ALTER SET/DROP NULL contstraint on distributed hypertable
#3944 Fix segfault in add_compression_policy
#3961 Fix crash in EXPLAIN VERBOSE on distributed hypertable
#4015 Eliminate float rounding instabilities in interpolate
#4019 Update ts_extension_oid in transitioning state
#4073 Fix buffer overflow in partition scheme

Improvements
Query planning performance is improved for hypertables with a large number of chunks.

Thanks

@fvannee for reporting a first/last memory leak
@mmouterde for reporting an issue with floats and interpolate

Assets 2

10 Feb 00:36

svenklemm

2.5.2

6794b14

2.5.2 (2022-02-09)

This release contains bug fixes since the 2.5.1 release.
This release is high priority for upgrade. We strongly recommend that you
upgrade as soon as possible.

Bugfixes

#3900 Improve custom scan node registration
#3911 Fix role type deparsing for GRANT command
#3918 Fix DataNodeScan plans with one-time filter
#3921 Fix segfault on insert into internal compressed table
#3938 Fix subtract_integer_from_now on 32-bit platforms and improve error handling
#3939 Fix projection handling in time_bucket_gapfill
#3948 Avoid double PGclear() in data fetchers
#3979 Fix deparsing of index predicates
#4015 Eliminate float rounding instabilities in interpolate
#4020 Fix ALTER TABLE EventTrigger initialization
#4024 Fix premature cache release call
#4037 Fix status for dropped chunks that have catalog entries
#4069 Fix riinfo NULL handling in ANY construct
#4071 Fix extension installation privilege escalation (CVE-2022-24128)

Thanks

@carlocperez for reporting crash with NULL handling in ANY construct
@erikhh for reporting an issue with time_bucket_gapfill
@fvannee for reporting a first/last memory leak
@kancsuki for reporting drop column and partial index creation not working
@mmouterde for reporting an issue with floats and interpolate
Pedro Gallegos for reporting a possible privilege escalation during extension installation

Contributors

erikhh, mmouterde, and 3 other contributors

Assets 2

03 Dec 13:37

duncan-tsdb

2.5.1

a2530ab

2.5.1 (2021-12-02)

This release contains bug fixes since the 2.5.0 release.
We deem it medium priority to upgrade.

Bugfixes

#3706 Test enabling dist compression within a procedure
#3734 Rework distributed DDL processing logic
#3737 Fix flaky pg_dump
#3739 Fix compression policy on tables using INTEGER
#3766 Fix segfault in ts_hist_sfunc
#3779 Support GRANT/REVOKE on distributed database
#3789 Fix time_bucket comparison transformation
#3797 Fix DISTINCT ON queries for distributed hyperatbles
#3799 Fix error printout on correct security label
#3801 Fail size utility functions when data nodes do not respond
#3809 Fix NULL pointer evaluation in fill_result_error()
#3811 Fix INSERT..SELECT involving dist hypertables
#3819 Fix reading garbage value from TSConnectionError
#3824 Remove pointers from CAGG lists for 64-bit archs
#3846 Eliminate deadlock in recompress chunk policy
#3881 Fix SkipScan crash due to pruned unique path
#3884 Fix create_distributed_restore_point memory issue

Thanks

@cbisnett for reporting and fixing a typo in an error message
@CaptainCuddleCube for reporting bug on compression policy procedure on tables using INTEGER on time dimension
@phemmer for reporting bugs on multi-node

Contributors

cbisnett, phemmer, and CaptainCuddleCube

Assets 2

28 Oct 10:32

fabriziomello

2.5.0

e6f137f

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