Release 2.12.0

[svenklemm]

This release contains performance improvements for compressed hypertables
and continuous aggregates and bug fixes since the 2.11.2 release.
We recommend that you upgrade at the next available opportunity.

This release moves all internal functions from the _timescaleb_internal
schema into the _timescaledb_functions schema. This separates code from
internal data objects and improves security by allowing more restrictive
permissions for the code schema. If you are calling any of those internal
functions you should adjust your code as soon as possible. This version
also includes a compatibility layer that allows calling them in the old
location but that layer will be removed in 2.14.0.

PostgreSQL 12 support removal announcement
Following the deprecation announcement for PostgreSQL 12 in TimescaleDB 2.10,
PostgreSQL 12 is not supported starting with TimescaleDB 2.12.
Currently supported PostgreSQL major versions are 13, 14 and 15.
PostgreSQL 16 support will be added with a following TimescaleDB release.

Features

• Insert into index during chunk compression #5137 Insert into index during chunk compression
• MERGE support on hypertables #5150 MERGE support on hypertables
• Make hypertables support replica identity #5515 Make hypertables support replica identity
• Index scan support during UPDATE/DELETE on compressed hypertables. #5586 Index scan support during UPDATE/DELETE on compressed hypertables
• Support for partial aggregations at chunk level #5596 Support for partial aggregations at chunk level
• Enable ChunkAppend for partial chunks #5599 Enable ChunkAppend for partially compressed chunks
• Improve parallel workers for decompression #5655 Improve the number of parallel workers for decompression
• Enable altering job schedule type through alter_job #5758 Enable altering job schedule type through alter_job
• Make logrepl markers for (partial) decompressions #5805 Make logrepl markers for (partial) decompressions
• Relax strong table lock when refreshing a Continuous Aggregate #5809 Relax invalidation threshold table-level lock to row-level when refreshing a Continuous Aggregate
• Support CAGG names in chunk_detailed_size #5839 Support CAgg names in chunk_detailed_size
• Make set_chunk_time_interval CAGGs aware #5852 Make set_chunk_time_interval CAggs aware
• Allow Replica Identity (Alter Table) on CAGGs #5868 Allow ALTER TABLE ... REPLICA IDENTITY (FULL|INDEX) on materialized hypertables (continuous aggregates)
• Add job exit status and runtime to log #5875 Add job exit status and runtime to log
• Support CREATE INDEX ONLY ON main table #5909 CREATE INDEX ONLY ON hypertable creates index on chunks

Bugfixes

• Rectify interval calculation #5860 Fix interval calculation for hierarchical CAggs
• Check unique indexes when enabling compression #5894 Check unique indexes when enabling compression
• Account for uncompressed rows in 'create_compressed_chunk' #5951 _timescaledb_internal.create_compressed_chunk doesn't account for existing uncompressed rows
• Move functions to _timescaledb_functions schema #5988 Move functions to _timescaledb_functions schema
• Chunk_create must add existing table or fail #5788 Chunk_create must add an existing table or fail
• Fix duplicates on partially compressed chunk reads #5872 Fix duplicates on partially compressed chunk reads
• Fix crash in COPY from program returning error #5918 Fix crash in COPY from program returning error
• Place data in first/last function in correct mctx #5990 Place data in first/last function in correct mctx
• Call eq_func correctly in time_bucket_gapfill #5991 Call eq_func correctly in time_bucket_gapfill
• Fix incorrect row count in EXPLAIN ANALYZE INSERT .. ON CONFLICT output #6015 Correct row count in EXPLAIN ANALYZE INSERT .. ON CONFLICT output
• Fix server crash on UPDATE of compressed chunk #6035 Fix server crash on UPDATE of compressed chunk
• Server crash when using duplicate segmentby column #6044 Fix server crash when using duplicate segmentby column
• Fix segfault in set_integer_now_func #6045 Fix segfault in set_integer_now_func
• Function approximate_row_count returns 0 for caggs #6053 Fix approximate_row_count for CAggs
• Improve compression datatype handling #6081 Improve compressed DML datatype handling
• Propagate parameter changes to decompress child nodes #6084 Propagate parameter changes to decompress child nodes

Thanks

• @ajcanterbury for reporting a problem with lateral joins on compressed chunks
• @alexanderlaw for reporting multiple server crashes
• @lukaskirner for reporting a bug with monthly continuous aggregates
• @mrksngl for reporting a bug with unusual user names
• @willsbit for reporting a crash in time_bucket_gapfill

Disable-check: force-changelog-file
Disable-check: commit-count

[github-actions]

@mahipv, @mkindahl: please review this pull request.

Powered by pull-review

[codecov]

Codecov Report

Merging #6086 (4f985aa) into main (9dc699a) will decrease coverage by 0.02%.
The diff coverage is n/a.

@@            Coverage Diff             @@
##             main    #6086      +/-   ##
==========================================
- Coverage   81.51%   81.49%   -0.02%     
==========================================
  Files         246      246              
  Lines       56773    56727      -46     
  Branches    12587    12568      -19     
==========================================
- Hits        46276    46229      -47     
+ Misses       8114     8107       -7     
- Partials     2383     2391       +8     

see 19 files with indirect coverage changes

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more

[iroussos]

Thank you @svenklemm, I have added a few small comments

[iroussos]

I don't see #6067 included - the updates required for Data Tiering GA is a major reason why we are having 2.12 a little bit earlier, so we should make sure that everything is included before tagging.

@svenklemm do you mind also making sure with @zilder, @gayyappan that this is the only one remaining and that there is nothing else we forgot to add to the 2.12 milestone?

[svenklemm]

I don't see #6067 included - the updates required for Data Tiering GA is a major reason why we are having 2.12 a little bit earlier, so we should make sure that everything is included before tagging.

@svenklemm do you mind also making sure with @zilder, @gayyappan that this is the only one remaining and that there is nothing else we forgot to add to the 2.12 milestone?

#6067 has not been merged yet, will add it once its merged.

[horzsolt]

Shouldn't we include PG12 deprecation? @iroussos, what would be a good one-liner for the release notes?