{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":84240850,"defaultBranch":"main","name":"timescaledb","ownerLogin":"timescale","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2017-03-07T20:03:41.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/8986001?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1715226161.0","currentOid":""},"activityList":{"items":[{"before":"ca125cf62039a04a9365057ee7f40290101e7689","after":"f41cf0cbaf9153f9350e814cb076236d2f15ff95","ref":"refs/heads/main","pushedAt":"2024-05-09T13:55:05.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"svenklemm","name":"Sven Klemm","path":"/svenklemm","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/31455525?s=80&v=4"},"commit":{"message":"Improve compressed DML expression pushdown\n\nTry to constify query constraints when filtering batches to cover\na wider range of expressions that are safe to evaluate when we\ndo the batch filtering.\n\nThis will allow the following expressions to be usable with\ncompressed DML batch filtering:\n- IMMUTABLE and STABLE functions\n- SQLValueFunction (CURRENT_TIME,CURRENT_USER,LOCAL_TIME,...)\n- Prepared Statement parameters","shortMessageHtmlLink":"Improve compressed DML expression pushdown"}},{"before":null,"after":"8e90510132c9f674b06c0eec60e946abb71210f3","ref":"refs/heads/js-transition-table-support-in-triggers","pushedAt":"2024-05-09T03:42:41.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"jamessewell","name":"James Sewell","path":"/jamessewell","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1216931?s=80&v=4"},"commit":{"message":"Add support for transition tables\n\nIntial go at adding support for transition tables and relaxing\nthe trigger restrictions on AFTER FOR EACH STATEMENT for hypertables\n\nSeems to work with both INSERT and COPY (copy uses CIM_SINGLE like in\nthe Postgres source)","shortMessageHtmlLink":"Add support for transition tables"}},{"before":null,"after":"2dc29bcdfd32e64517b8d9920c9c16d90016b1ea","ref":"refs/heads/jg/fun-with-compression","pushedAt":"2024-05-08T22:33:26.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"JamesGuthrie","name":"James Guthrie","path":"/JamesGuthrie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1117749?s=80&v=4"},"commit":{"message":"WIP: enable compression activity markers for more activities","shortMessageHtmlLink":"WIP: enable compression activity markers for more activities"}},{"before":"c0cbea052354753a6e3c421c043af4789a574cb3","after":"bf61aafa1a97ef5b2b14f18374b22f2aeee04079","ref":"refs/heads/jg/replident-c-ht","pushedAt":"2024-05-08T14:09:06.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"JamesGuthrie","name":"James Guthrie","path":"/JamesGuthrie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1117749?s=80&v=4"},"commit":{"message":"Allow replica identity on compressed hypertables","shortMessageHtmlLink":"Allow replica identity on compressed hypertables"}},{"before":null,"after":"c0cbea052354753a6e3c421c043af4789a574cb3","ref":"refs/heads/jg/replident-c-ht","pushedAt":"2024-05-08T13:28:48.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"JamesGuthrie","name":"James Guthrie","path":"/JamesGuthrie","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/1117749?s=80&v=4"},"commit":{"message":"Allow replica identity on compressed hypertables","shortMessageHtmlLink":"Allow replica identity on compressed hypertables"}},{"before":"c5ef48965cf6f0a2bc8628f57225850e279fe003","after":"ca125cf62039a04a9365057ee7f40290101e7689","ref":"refs/heads/main","pushedAt":"2024-05-07T19:44:43.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Post-release changes for 2.15.0.","shortMessageHtmlLink":"Post-release changes for 2.15.0."}},{"before":"16f903caece6930ad893132cd0d3fc3114e7b762","after":null,"ref":"refs/heads/expression_utils","pushedAt":"2024-05-07T18:03:13.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"svenklemm","name":"Sven Klemm","path":"/svenklemm","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/31455525?s=80&v=4"}},{"before":"5bf6a3f502c8fe4e9910a1759056dfe2981c38dd","after":"c5ef48965cf6f0a2bc8628f57225850e279fe003","ref":"refs/heads/main","pushedAt":"2024-05-07T18:03:12.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"svenklemm","name":"Sven Klemm","path":"/svenklemm","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/31455525?s=80&v=4"},"commit":{"message":"Use ts_extract_expr_args for HypertableRestrictInfo\n\nRefactor HypertableRestrictInfo code to make use of the newly added\nts_extract_expr_args function.","shortMessageHtmlLink":"Use ts_extract_expr_args for HypertableRestrictInfo"}},{"before":"d8057c432625981ecc44db960b72f394cabd3b35","after":"19f731d174820dfc0f33e073235c99368b3ad98c","ref":"refs/heads/2.15.x","pushedAt":"2024-05-07T17:14:08.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Release 2.15.0\n\nThis release contains performance improvements and bug fixes since\nthe 2.14.2 release. We recommend that you upgrade at the next\navailable opportunity.\n\nIn addition, it includes these noteworthy features:\n* Support `time_bucket` with `origin` and/or `offset` on Continuous Aggregate\n* Compression improvements:\n  - Improve expression pushdown\n  - Add minmax sparse indexes when compressing columns with btree indexes\n  - Make compression use the defaults functions\n  - Vectorize filters in WHERE clause that contain text equality operators and LIKE expressions\n\n**Deprecation warning**\n* Starting on this release will not be possible to create Continuous Aggregate using `time_bucket_ng` anymore and it will be completely removed on the upcoming releases.\n* Recommend users to [migrate their old Continuous Aggregate format to the new one](https://docs.timescale.com/use-timescale/latest/continuous-aggregates/migrate/) because it support will be completely removed in next releases prevent them to migrate.\n* This is the last release supporting PostgreSQL 13.\n\n**For on-premise users and this release only**, you will need to run [this SQL script](https://github.com/timescale/timescaledb-extras/blob/master/utils/2.15.X-fix_hypertable_foreign_keys.sql) after running `ALTER EXTENSION`. More details can be found in the pull request [#6786](https://github.com/timescale/timescaledb/pull/6797).\n\n**Features**\n* #6382 Support for time_bucket with origin and offset in CAggs\n* #6696 Improve defaults for compression segment_by and order_by\n* #6705 Add sparse minmax indexes for compressed columns that have uncompressed btree indexes\n* #6754 Allow DROP CONSTRAINT on compressed hypertables\n* #6767 Add metadata table `_timestaledb_internal.bgw_job_stat_history` for tracking job execution history\n* #6798 Prevent usage of deprecated time_bucket_ng in CAgg definition\n* #6810 Add telemetry for access methods\n* #6811 Remove no longer relevant timescaledb.allow_install_without_preload GUC\n* #6837 Add migration path for CAggs using time_bucket_ng\n* #6865 Update the watermark when truncating a CAgg\n\n**Bugfixes**\n* #6617 Fix error in show_chunks\n* #6621 Remove metadata when dropping chunks\n* #6677 Fix snapshot usage in CAgg invalidation scanner\n* #6698 Define meaning of 0 retries for jobs as no retries\n* #6717 Fix handling of compressed tables with primary or unique index in COPY path\n* #6726 Fix constify cagg_watermark using window function when querying a CAgg\n* #6729 Fix NULL start value handling in CAgg refresh\n* #6732 Fix CAgg migration with custom timezone / date format settings\n* #6752 Remove custom autovacuum setting from compressed chunks\n* #6770 Fix plantime chunk exclusion for OSM chunk\n* #6789 Fix deletes with subqueries and compression\n* #6796 Fix a crash involving a view on a hypertable\n* #6797 Fix foreign key constraint handling on compressed hypertables\n* #6816 Fix handling of chunks with no contraints\n* #6820 Fix a crash when the ts_hypertable_insert_blocker was called directly\n* #6849 Use non-orderby compressed metadata in compressed DML\n* #6867 Clean up compression settings when deleting compressed cagg\n* #6869 Fix compressed DML with constraints of form value OP column\n* #6870 Fix bool expression pushdown for queries on compressed chunks\n\n**Thanks**\n* @brasic for reporting a crash when the ts_hypertable_insert_blocker was called directly\n* @bvanelli for reporting an issue with the jobs retry count\n* @djzurawsk For reporting error when dropping chunks\n* @Dzuzepppe for reporting an issue with DELETEs using subquery on compressed chunk working incorrectly.\n* @hongquan For reporting a 'timestamp out of range' error during CAgg migrations\n* @kevcenteno for reporting an issue with the show_chunks API showing incorrect output when 'created_before/created_after' was used with time-partitioned columns.\n* @mahipv For starting working on the job history PR\n* @rovo89 For reporting constify cagg_watermark not working using window function when querying a CAgg","shortMessageHtmlLink":"Release 2.15.0"}},{"before":"defe4ef581e2e8cad0fa5cadb470382242b87fe4","after":"5bf6a3f502c8fe4e9910a1759056dfe2981c38dd","ref":"refs/heads/main","pushedAt":"2024-05-07T07:22:15.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"erimatnor","name":"Erik Nordström","path":"/erimatnor","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/819732?s=80&v=4"},"commit":{"message":"Fix use of ObjectId datums in compression settings\n\nUse ObjectId datum functions in compression settings instead of int32\nfunctions when storing `regclass` types.\n\nAlso fix a minor issue where an array for Datum information was using\nthe wrong size.","shortMessageHtmlLink":"Fix use of ObjectId datums in compression settings"}},{"before":"8c34a207d9cc1a3f6e0b26755d72bca17f0a6c8c","after":"2d0ed64017a2cf18d33a19b733186a37006a4499","ref":"refs/heads/benchmark","pushedAt":"2024-05-06T18:08:37.000Z","pushType":"push","commitsCount":167,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Release 2.15.0\n\nThis release contains performance improvements and bug fixes since\nthe 2.14.2 release. We recommend that you upgrade at the next\navailable opportunity.\n\nIn addition, it includes these noteworthy features:\n* Support `time_bucket` with `origin` and/or `offset` on Continuous Aggregate\n* Compression improvements:\n  - Improve expression pushdown\n  - Add minmax sparse indexes when compressing columns with btree indexes\n  - Make compression use the defaults functions\n  - Vectorize filters in WHERE clause that contain text equality operators and LIKE expressions\n\n**Deprecation warning**\n* Starting on this release will not be possible to create Continuous Aggregate using `time_bucket_ng` anymore and it will be completely removed on the upcoming releases.\n* Recommend users to [migrate their old Continuous Aggregate format to the new one](https://docs.timescale.com/use-timescale/latest/continuous-aggregates/migrate/) because it support will be completely removed in next releases prevent them to migrate.\n* This is the last release supporting PostgreSQL 13.\n\n**For on-premise users and this release only**, you will need to run [this SQL script](https://github.com/timescale/timescaledb-extras/blob/master/utils/2.15.X-fix_hypertable_foreign_keys.sql) after running `ALTER EXTENSION`. More details can be found in the pull request [#6786](https://github.com/timescale/timescaledb/pull/6797).\n\n**Features**\n* #6382 Support for time_bucket with origin and offset in CAggs\n* #6696 Improve defaults for compression segment_by and order_by\n* #6705 Add sparse minmax indexes for compressed columns that have uncompressed btree indexes\n* #6754 Allow DROP CONSTRAINT on compressed hypertables\n* #6767 Add metadata table `_timestaledb_internal.bgw_job_stat_history` for tracking job execution history\n* #6798 Prevent usage of deprecated time_bucket_ng in CAgg definition\n* #6810 Add telemetry for access methods\n* #6811 Remove no longer relevant timescaledb.allow_install_without_preload GUC\n* #6837 Add migration path for CAggs using time_bucket_ng\n* #6865 Update the watermark when truncating a CAgg\n\n**Bugfixes**\n* #6617 Fix error in show_chunks\n* #6621 Remove metadata when dropping chunks\n* #6677 Fix snapshot usage in CAgg invalidation scanner\n* #6698 Define meaning of 0 retries for jobs as no retries\n* #6717 Fix handling of compressed tables with primary or unique index in COPY path\n* #6726 Fix constify cagg_watermark using window function when querying a CAgg\n* #6729 Fix NULL start value handling in CAgg refresh\n* #6732 Fix CAgg migration with custom timezone / date format settings\n* #6752 Remove custom autovacuum setting from compressed chunks\n* #6770 Fix plantime chunk exclusion for OSM chunk\n* #6789 Fix deletes with subqueries and compression\n* #6796 Fix a crash involving a view on a hypertable\n* #6797 Fix foreign key constraint handling on compressed hypertables\n* #6816 Fix handling of chunks with no contraints\n* #6820 Fix a crash when the ts_hypertable_insert_blocker was called directly\n* #6849 Use non-orderby compressed metadata in compressed DML\n* #6867 Clean up compression settings when deleting compressed cagg\n* #6869 Fix compressed DML with constraints of form value OP column\n* #6870 Fix bool expression pushdown for queries on compressed chunks\n\n**Thanks**\n* @brasic for reporting a crash when the ts_hypertable_insert_blocker was called directly\n* @bvanelli for reporting an issue with the jobs retry count\n* @djzurawsk For reporting error when dropping chunks\n* @Dzuzepppe for reporting an issue with DELETEs using subquery on compressed chunk working incorrectly.\n* @hongquan For reporting a 'timestamp out of range' error during CAgg migrations\n* @kevcenteno for reporting an issue with the show_chunks API showing incorrect output when 'created_before/created_after' was used with time-partitioned columns.\n* @mahipv For starting working on the job history PR\n* @rovo89 For reporting constify cagg_watermark not working using window function when querying a CAgg","shortMessageHtmlLink":"Release 2.15.0"}},{"before":"ba87fac4f4866a4f0023e05655326a9db25c755d","after":"2d0ed64017a2cf18d33a19b733186a37006a4499","ref":"refs/heads/coverity_scan","pushedAt":"2024-05-06T18:06:55.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Release 2.15.0\n\nThis release contains performance improvements and bug fixes since\nthe 2.14.2 release. We recommend that you upgrade at the next\navailable opportunity.\n\nIn addition, it includes these noteworthy features:\n* Support `time_bucket` with `origin` and/or `offset` on Continuous Aggregate\n* Compression improvements:\n  - Improve expression pushdown\n  - Add minmax sparse indexes when compressing columns with btree indexes\n  - Make compression use the defaults functions\n  - Vectorize filters in WHERE clause that contain text equality operators and LIKE expressions\n\n**Deprecation warning**\n* Starting on this release will not be possible to create Continuous Aggregate using `time_bucket_ng` anymore and it will be completely removed on the upcoming releases.\n* Recommend users to [migrate their old Continuous Aggregate format to the new one](https://docs.timescale.com/use-timescale/latest/continuous-aggregates/migrate/) because it support will be completely removed in next releases prevent them to migrate.\n* This is the last release supporting PostgreSQL 13.\n\n**For on-premise users and this release only**, you will need to run [this SQL script](https://github.com/timescale/timescaledb-extras/blob/master/utils/2.15.X-fix_hypertable_foreign_keys.sql) after running `ALTER EXTENSION`. More details can be found in the pull request [#6786](https://github.com/timescale/timescaledb/pull/6797).\n\n**Features**\n* #6382 Support for time_bucket with origin and offset in CAggs\n* #6696 Improve defaults for compression segment_by and order_by\n* #6705 Add sparse minmax indexes for compressed columns that have uncompressed btree indexes\n* #6754 Allow DROP CONSTRAINT on compressed hypertables\n* #6767 Add metadata table `_timestaledb_internal.bgw_job_stat_history` for tracking job execution history\n* #6798 Prevent usage of deprecated time_bucket_ng in CAgg definition\n* #6810 Add telemetry for access methods\n* #6811 Remove no longer relevant timescaledb.allow_install_without_preload GUC\n* #6837 Add migration path for CAggs using time_bucket_ng\n* #6865 Update the watermark when truncating a CAgg\n\n**Bugfixes**\n* #6617 Fix error in show_chunks\n* #6621 Remove metadata when dropping chunks\n* #6677 Fix snapshot usage in CAgg invalidation scanner\n* #6698 Define meaning of 0 retries for jobs as no retries\n* #6717 Fix handling of compressed tables with primary or unique index in COPY path\n* #6726 Fix constify cagg_watermark using window function when querying a CAgg\n* #6729 Fix NULL start value handling in CAgg refresh\n* #6732 Fix CAgg migration with custom timezone / date format settings\n* #6752 Remove custom autovacuum setting from compressed chunks\n* #6770 Fix plantime chunk exclusion for OSM chunk\n* #6789 Fix deletes with subqueries and compression\n* #6796 Fix a crash involving a view on a hypertable\n* #6797 Fix foreign key constraint handling on compressed hypertables\n* #6816 Fix handling of chunks with no contraints\n* #6820 Fix a crash when the ts_hypertable_insert_blocker was called directly\n* #6849 Use non-orderby compressed metadata in compressed DML\n* #6867 Clean up compression settings when deleting compressed cagg\n* #6869 Fix compressed DML with constraints of form value OP column\n* #6870 Fix bool expression pushdown for queries on compressed chunks\n\n**Thanks**\n* @brasic for reporting a crash when the ts_hypertable_insert_blocker was called directly\n* @bvanelli for reporting an issue with the jobs retry count\n* @djzurawsk For reporting error when dropping chunks\n* @Dzuzepppe for reporting an issue with DELETEs using subquery on compressed chunk working incorrectly.\n* @hongquan For reporting a 'timestamp out of range' error during CAgg migrations\n* @kevcenteno for reporting an issue with the show_chunks API showing incorrect output when 'created_before/created_after' was used with time-partitioned columns.\n* @mahipv For starting working on the job history PR\n* @rovo89 For reporting constify cagg_watermark not working using window function when querying a CAgg","shortMessageHtmlLink":"Release 2.15.0"}},{"before":"b5f04133ef419005debec29c842dd3d20e22d32d","after":"2d0ed64017a2cf18d33a19b733186a37006a4499","ref":"refs/heads/prerelease_test","pushedAt":"2024-05-06T18:06:38.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Release 2.15.0\n\nThis release contains performance improvements and bug fixes since\nthe 2.14.2 release. We recommend that you upgrade at the next\navailable opportunity.\n\nIn addition, it includes these noteworthy features:\n* Support `time_bucket` with `origin` and/or `offset` on Continuous Aggregate\n* Compression improvements:\n  - Improve expression pushdown\n  - Add minmax sparse indexes when compressing columns with btree indexes\n  - Make compression use the defaults functions\n  - Vectorize filters in WHERE clause that contain text equality operators and LIKE expressions\n\n**Deprecation warning**\n* Starting on this release will not be possible to create Continuous Aggregate using `time_bucket_ng` anymore and it will be completely removed on the upcoming releases.\n* Recommend users to [migrate their old Continuous Aggregate format to the new one](https://docs.timescale.com/use-timescale/latest/continuous-aggregates/migrate/) because it support will be completely removed in next releases prevent them to migrate.\n* This is the last release supporting PostgreSQL 13.\n\n**For on-premise users and this release only**, you will need to run [this SQL script](https://github.com/timescale/timescaledb-extras/blob/master/utils/2.15.X-fix_hypertable_foreign_keys.sql) after running `ALTER EXTENSION`. More details can be found in the pull request [#6786](https://github.com/timescale/timescaledb/pull/6797).\n\n**Features**\n* #6382 Support for time_bucket with origin and offset in CAggs\n* #6696 Improve defaults for compression segment_by and order_by\n* #6705 Add sparse minmax indexes for compressed columns that have uncompressed btree indexes\n* #6754 Allow DROP CONSTRAINT on compressed hypertables\n* #6767 Add metadata table `_timestaledb_internal.bgw_job_stat_history` for tracking job execution history\n* #6798 Prevent usage of deprecated time_bucket_ng in CAgg definition\n* #6810 Add telemetry for access methods\n* #6811 Remove no longer relevant timescaledb.allow_install_without_preload GUC\n* #6837 Add migration path for CAggs using time_bucket_ng\n* #6865 Update the watermark when truncating a CAgg\n\n**Bugfixes**\n* #6617 Fix error in show_chunks\n* #6621 Remove metadata when dropping chunks\n* #6677 Fix snapshot usage in CAgg invalidation scanner\n* #6698 Define meaning of 0 retries for jobs as no retries\n* #6717 Fix handling of compressed tables with primary or unique index in COPY path\n* #6726 Fix constify cagg_watermark using window function when querying a CAgg\n* #6729 Fix NULL start value handling in CAgg refresh\n* #6732 Fix CAgg migration with custom timezone / date format settings\n* #6752 Remove custom autovacuum setting from compressed chunks\n* #6770 Fix plantime chunk exclusion for OSM chunk\n* #6789 Fix deletes with subqueries and compression\n* #6796 Fix a crash involving a view on a hypertable\n* #6797 Fix foreign key constraint handling on compressed hypertables\n* #6816 Fix handling of chunks with no contraints\n* #6820 Fix a crash when the ts_hypertable_insert_blocker was called directly\n* #6849 Use non-orderby compressed metadata in compressed DML\n* #6867 Clean up compression settings when deleting compressed cagg\n* #6869 Fix compressed DML with constraints of form value OP column\n* #6870 Fix bool expression pushdown for queries on compressed chunks\n\n**Thanks**\n* @brasic for reporting a crash when the ts_hypertable_insert_blocker was called directly\n* @bvanelli for reporting an issue with the jobs retry count\n* @djzurawsk For reporting error when dropping chunks\n* @Dzuzepppe for reporting an issue with DELETEs using subquery on compressed chunk working incorrectly.\n* @hongquan For reporting a 'timestamp out of range' error during CAgg migrations\n* @kevcenteno for reporting an issue with the show_chunks API showing incorrect output when 'created_before/created_after' was used with time-partitioned columns.\n* @mahipv For starting working on the job history PR\n* @rovo89 For reporting constify cagg_watermark not working using window function when querying a CAgg","shortMessageHtmlLink":"Release 2.15.0"}},{"before":"d8057c432625981ecc44db960b72f394cabd3b35","after":"defe4ef581e2e8cad0fa5cadb470382242b87fe4","ref":"refs/heads/main","pushedAt":"2024-05-06T15:40:40.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Release 2.15.0\n\nThis release contains performance improvements and bug fixes since\nthe 2.14.2 release. We recommend that you upgrade at the next\navailable opportunity.\n\nIn addition, it includes these noteworthy features:\n* Support `time_bucket` with `origin` and/or `offset` on Continuous Aggregate\n* Compression improvements:\n  - Improve expression pushdown\n  - Add minmax sparse indexes when compressing columns with btree indexes\n  - Make compression use the defaults functions\n  - Vectorize filters in WHERE clause that contain text equality operators and LIKE expressions\n\n**Deprecation warning**\n* Starting on this release will not be possible to create Continuous Aggregate using `time_bucket_ng` anymore and it will be completely removed on the upcoming releases.\n* Recommend users to [migrate their old Continuous Aggregate format to the new one](https://docs.timescale.com/use-timescale/latest/continuous-aggregates/migrate/) because it support will be completely removed in next releases prevent them to migrate.\n* This is the last release supporting PostgreSQL 13.\n\n**For on-premise users and this release only**, you will need to run [this SQL script](https://github.com/timescale/timescaledb-extras/blob/master/utils/2.15.X-fix_hypertable_foreign_keys.sql) after running `ALTER EXTENSION`. More details can be found in the pull request [#6786](https://github.com/timescale/timescaledb/pull/6797).\n\n**Features**\n* #6382 Support for time_bucket with origin and offset in CAggs\n* #6696 Improve defaults for compression segment_by and order_by\n* #6705 Add sparse minmax indexes for compressed columns that have uncompressed btree indexes\n* #6754 Allow DROP CONSTRAINT on compressed hypertables\n* #6767 Add metadata table `_timestaledb_internal.bgw_job_stat_history` for tracking job execution history\n* #6798 Prevent usage of deprecated time_bucket_ng in CAgg definition\n* #6810 Add telemetry for access methods\n* #6811 Remove no longer relevant timescaledb.allow_install_without_preload GUC\n* #6837 Add migration path for CAggs using time_bucket_ng\n* #6865 Update the watermark when truncating a CAgg\n\n**Bugfixes**\n* #6617 Fix error in show_chunks\n* #6621 Remove metadata when dropping chunks\n* #6677 Fix snapshot usage in CAgg invalidation scanner\n* #6698 Define meaning of 0 retries for jobs as no retries\n* #6717 Fix handling of compressed tables with primary or unique index in COPY path\n* #6726 Fix constify cagg_watermark using window function when querying a CAgg\n* #6729 Fix NULL start value handling in CAgg refresh\n* #6732 Fix CAgg migration with custom timezone / date format settings\n* #6752 Remove custom autovacuum setting from compressed chunks\n* #6770 Fix plantime chunk exclusion for OSM chunk\n* #6789 Fix deletes with subqueries and compression\n* #6796 Fix a crash involving a view on a hypertable\n* #6797 Fix foreign key constraint handling on compressed hypertables\n* #6816 Fix handling of chunks with no contraints\n* #6820 Fix a crash when the ts_hypertable_insert_blocker was called directly\n* #6849 Use non-orderby compressed metadata in compressed DML\n* #6867 Clean up compression settings when deleting compressed cagg\n* #6869 Fix compressed DML with constraints of form value OP column\n* #6870 Fix bool expression pushdown for queries on compressed chunks\n\n**Thanks**\n* @brasic for reporting a crash when the ts_hypertable_insert_blocker was called directly\n* @bvanelli for reporting an issue with the jobs retry count\n* @djzurawsk For reporting error when dropping chunks\n* @Dzuzepppe for reporting an issue with DELETEs using subquery on compressed chunk working incorrectly.\n* @hongquan For reporting a 'timestamp out of range' error during CAgg migrations\n* @kevcenteno for reporting an issue with the show_chunks API showing incorrect output when 'created_before/created_after' was used with time-partitioned columns.\n* @mahipv For starting working on the job history PR\n* @rovo89 For reporting constify cagg_watermark not working using window function when querying a CAgg","shortMessageHtmlLink":"Release 2.15.0"}},{"before":null,"after":"d8057c432625981ecc44db960b72f394cabd3b35","ref":"refs/heads/2.15.x","pushedAt":"2024-05-06T14:24:48.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Fix policy refresh window too small\n\nWhen adding a CAgg refresh policy using `start_offset => '2 months'` and\n`end_offset => '0 months'` was failing because the policy refresh window\nis too small and it should cover at least two buckets in the valid time\nrange of timestamptz.\n\nThe problem was when calculating the bucket width for the variable\nbucket size (like months) we're assuming 31 days for each month but when\nconverting the end offset to integer using `interval_to_int64` we use 30\ndays per month. Fixed it by aligning the variable bucket size\ncalculation to also use 30 days.","shortMessageHtmlLink":"Fix policy refresh window too small"}},{"before":"bc644f7965db16a36865b2491dfdbd88a547dd19","after":null,"ref":"refs/heads/2.15.X","pushedAt":"2024-05-06T14:24:11.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"}},{"before":"bc644f7965db16a36865b2491dfdbd88a547dd19","after":null,"ref":"refs/heads/2.15.x","pushedAt":"2024-05-06T14:23:59.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"}},{"before":null,"after":"bc644f7965db16a36865b2491dfdbd88a547dd19","ref":"refs/heads/2.15.X","pushedAt":"2024-05-06T14:23:59.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Release notes header 2.15.0","shortMessageHtmlLink":"Release notes header 2.15.0"}},{"before":null,"after":"bc644f7965db16a36865b2491dfdbd88a547dd19","ref":"refs/heads/2.15.x","pushedAt":"2024-05-06T14:23:07.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Release notes header 2.15.0","shortMessageHtmlLink":"Release notes header 2.15.0"}},{"before":"bc644f7965db16a36865b2491dfdbd88a547dd19","after":"d8057c432625981ecc44db960b72f394cabd3b35","ref":"refs/heads/main","pushedAt":"2024-05-06T06:50:51.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Fix policy refresh window too small\n\nWhen adding a CAgg refresh policy using `start_offset => '2 months'` and\n`end_offset => '0 months'` was failing because the policy refresh window\nis too small and it should cover at least two buckets in the valid time\nrange of timestamptz.\n\nThe problem was when calculating the bucket width for the variable\nbucket size (like months) we're assuming 31 days for each month but when\nconverting the end offset to integer using `interval_to_int64` we use 30\ndays per month. Fixed it by aligning the variable bucket size\ncalculation to also use 30 days.","shortMessageHtmlLink":"Fix policy refresh window too small"}},{"before":"bc644f7965db16a36865b2491dfdbd88a547dd19","after":null,"ref":"refs/heads/2.15.X","pushedAt":"2024-05-04T18:15:10.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"}},{"before":"bc644f7965db16a36865b2491dfdbd88a547dd19","after":null,"ref":"refs/heads/2.15.x","pushedAt":"2024-05-04T18:14:54.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"}},{"before":null,"after":"bc644f7965db16a36865b2491dfdbd88a547dd19","ref":"refs/heads/2.15.X","pushedAt":"2024-05-04T18:14:53.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Release notes header 2.15.0","shortMessageHtmlLink":"Release notes header 2.15.0"}},{"before":null,"after":"bc644f7965db16a36865b2491dfdbd88a547dd19","ref":"refs/heads/2.15.x","pushedAt":"2024-05-04T18:12:20.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Release notes header 2.15.0","shortMessageHtmlLink":"Release notes header 2.15.0"}},{"before":"bc644f7965db16a36865b2491dfdbd88a547dd19","after":null,"ref":"refs/heads/2.15.X","pushedAt":"2024-05-04T18:09:47.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"}},{"before":"bc644f7965db16a36865b2491dfdbd88a547dd19","after":null,"ref":"refs/heads/2.15.x","pushedAt":"2024-05-04T18:09:42.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"}},{"before":null,"after":"bc644f7965db16a36865b2491dfdbd88a547dd19","ref":"refs/heads/2.15.X","pushedAt":"2024-05-04T18:09:41.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Release notes header 2.15.0","shortMessageHtmlLink":"Release notes header 2.15.0"}},{"before":null,"after":"bc644f7965db16a36865b2491dfdbd88a547dd19","ref":"refs/heads/2.15.x","pushedAt":"2024-05-04T18:09:00.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"},"commit":{"message":"Release notes header 2.15.0","shortMessageHtmlLink":"Release notes header 2.15.0"}},{"before":"bc644f7965db16a36865b2491dfdbd88a547dd19","after":null,"ref":"refs/heads/2.15.X","pushedAt":"2024-05-04T18:07:27.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"}},{"before":"bc644f7965db16a36865b2491dfdbd88a547dd19","after":null,"ref":"refs/heads/2.15.x","pushedAt":"2024-05-04T18:07:18.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"fabriziomello","name":"Fabrízio de Royes Mello","path":"/fabriziomello","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/612482?s=80&v=4"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAERauzzwA","startCursor":null,"endCursor":null}},"title":"Activity · timescale/timescaledb"}