timescale/timescaledb issues and pull requests

#7211 - [Enhancement]: 'time_bucket' queries using 'first' or 'distict on' are far slower (10000x) than necessary.

Issue - State: open - Opened by ewoolsey about 1 month ago - 7 comments
Labels: enhancement

#7210 - [Bug]: UPDATEs on hypertables hang

Issue - State: closed - Opened by nckswt about 1 month ago - 1 comment
Labels: bug

#7210 - [Bug]: UPDATEs on hypertables hang

Issue - State: closed - Opened by nckswt about 1 month ago - 1 comment
Labels: bug

#7209 - Add function to drop the osm chunk

Pull Request - State: closed - Opened by zilder about 1 month ago - 2 comments

#7209 - Add function to drop the osm chunk

Pull Request - State: closed - Opened by zilder about 1 month ago - 2 comments

#7208 - [Bug]: Can't drop table from publication if added before `create_hypertable()`

Issue - State: open - Opened by soedirgo about 1 month ago - 2 comments
Labels: bug, hypertable, low-hanging-fruit, native-replication

#7207 - Refactor decompress_batches_scan functions

Pull Request - State: closed - Opened by kpan2034 about 1 month ago - 4 comments
Labels: compression, enhancement

#7206 - [Flaky test] Isolation test reorder_vs_select fails with a timeout

Issue - State: open - Opened by mkindahl about 1 month ago
Labels: flaky-test

#7206 - [Flaky test] Isolation test reorder_vs_select fails with a timeout

Issue - State: open - Opened by mkindahl about 1 month ago
Labels: flaky-test

#7205 - [Feature]: Sliding window cagg aggregation

Issue - State: open - Opened by leppaott about 2 months ago - 5 comments
Labels: feature-request

#7205 - [Feature]: Sliding window cagg aggregation

Issue - State: open - Opened by leppaott about 2 months ago - 5 comments
Labels: feature-request

#7204 - Track additional extensions in telemetry

Pull Request - State: closed - Opened by mkindahl about 2 months ago - 1 comment
Labels: telemetry

#7204 - Track additional extensions in telemetry

Pull Request - State: closed - Opened by mkindahl about 2 months ago - 1 comment
Labels: telemetry

#7203 - Backport to 2.16.x: #7201: Fix extension comment for generic loader package

Pull Request - State: closed - Opened by timescale-automation about 2 months ago
Labels: is-auto-backport

#7203 - Backport to 2.16.x: #7201: Fix extension comment for generic loader package

Pull Request - State: closed - Opened by timescale-automation about 2 months ago
Labels: is-auto-backport

#7202 - Add ts_update_placeholder function

Pull Request - State: closed - Opened by svenklemm about 2 months ago - 1 comment
Labels: ci

#7202 - Add ts_update_placeholder function

Pull Request - State: closed - Opened by svenklemm about 2 months ago - 1 comment
Labels: ci

#7201 - Fix extension comment for generic loader package

Pull Request - State: closed - Opened by svenklemm about 2 months ago - 1 comment
Labels: packaging, backported-2.16.x

#7201 - Fix extension comment for generic loader package

Pull Request - State: closed - Opened by svenklemm about 2 months ago - 1 comment
Labels: packaging, backported-2.16.x

#7200 - Implement more vectorized aggregate functions

Pull Request - State: closed - Opened by akuzm about 2 months ago - 1 comment

#7199 - Null validity bitmap in ArrowArray

Pull Request - State: closed - Opened by akuzm about 2 months ago - 2 comments

#7199 - Null validity bitmap in ArrowArray

Pull Request - State: closed - Opened by akuzm about 2 months ago - 2 comments

#7196 - [Enhancement]: Clarify 2.15.0+ release notes requirement

Issue - State: open - Opened by jflambert about 2 months ago - 3 comments
Labels: enhancement

#7196 - [Enhancement]: Clarify 2.15.0+ release notes requirement

Issue - State: open - Opened by jflambert about 2 months ago - 3 comments
Labels: enhancement

#7195 - Fix check when dropping compressed column (#7102)

Pull Request - State: closed - Opened by kpan2034 about 2 months ago - 2 comments
Labels: bug, compression, auto-backport-not-done

#7195 - Fix check when dropping compressed column (#7102)

Pull Request - State: closed - Opened by kpan2034 about 2 months ago - 2 comments
Labels: bug, compression, auto-backport-not-done

#7193 - Disable CI block of C-functions in latest-dev.sql

Pull Request - State: open - Opened by erimatnor about 2 months ago - 3 comments
Labels: ci

#7193 - Disable CI block of C-functions in latest-dev.sql

Pull Request - State: closed - Opened by erimatnor about 2 months ago - 3 comments
Labels: ci

#7192 - Backport to 2.16.x: #7191: Fix create default indexes on chunks

Pull Request - State: closed - Opened by timescale-automation about 2 months ago
Labels: is-auto-backport

#7192 - Backport to 2.16.x: #7191: Fix create default indexes on chunks

Pull Request - State: closed - Opened by timescale-automation about 2 months ago
Labels: is-auto-backport

#7191 - Fix create default indexes on chunks

Pull Request - State: closed - Opened by fabriziomello about 2 months ago - 1 comment
Labels: bug, hypertable, backported-2.16.x

#7191 - Fix create default indexes on chunks

Pull Request - State: closed - Opened by fabriziomello about 2 months ago - 1 comment
Labels: bug, hypertable, backported-2.16.x

#7188 - [Bug]: Creating a foreign key referencing a tiered hypertable causes assertion failure

Issue - State: closed - Opened by zilder about 2 months ago - 2 comments
Labels: bug

#7175 - [Enhancement]: Improve messages when picking default compression settings

Issue - State: open - Opened by erimatnor 2 months ago - 1 comment
Labels: bug, enhancement

#7174 - Fix issue with adding foreign key constraint on hypertable with OSM chunk

Pull Request - State: open - Opened by gayyappan 2 months ago - 1 comment

#7148 - Order chunks for compression by range_start

Pull Request - State: open - Opened by RobAtticus 2 months ago - 3 comments

#7147 - Implement vectorized aggregation with grouping on segmentby column

Pull Request - State: closed - Opened by akuzm 2 months ago - 1 comment

#7147 - Implement vectorized aggregation with grouping on segmentby column

Pull Request - State: closed - Opened by akuzm 2 months ago - 1 comment

#7144 - [Enhancement]: Refactor decompress_batches functions

Issue - State: closed - Opened by antekresic 2 months ago
Labels: tech-debt, enhancement

#7144 - [Enhancement]: Refactor decompress_batches functions

Issue - State: closed - Opened by antekresic 2 months ago
Labels: tech-debt, enhancement

#7125 - Fix build on Ubuntu 24.04

Pull Request - State: closed - Opened by mkindahl 3 months ago - 7 comments

#7112 - [Bug]: Queries are faster on decompressed data than on compressed data

Issue - State: open - Opened by cscetbon 3 months ago - 2 comments
Labels: bug, compression

#7112 - [Bug]: Queries are faster on decompressed data than on compressed data

Issue - State: open - Opened by cscetbon 3 months ago - 2 comments
Labels: bug, compression

#7107 - [Feature]: join with multiple equality conditions

Issue - State: open - Opened by fordfrog 3 months ago - 7 comments
Labels: continuous_aggregate, enhancement

#7107 - [Feature]: join with multiple equality conditions

Issue - State: open - Opened by fordfrog 3 months ago - 7 comments
Labels: continuous_aggregate, enhancement

#7104 - Table access method for compressed hypertables

Pull Request - State: open - Opened by mkindahl 3 months ago - 20 comments
Labels: compression, table-access-method

#7103 - Removal of sequence number

Pull Request - State: open - Opened by antekresic 3 months ago - 2 comments

#7079 - [Bug]: Some data not returned in queries when using partition functions in second dimension

Issue - State: open - Opened by GreenArchon 3 months ago - 2 comments
Labels: bug

#7078 - [Bug]: child rel 1 not found in append_rel_array when using any function in a select statement for some chunks but not all

Issue - State: closed - Opened by chris-morris-h2o 3 months ago - 11 comments
Labels: bug

#7062 - Add patch release PR creation scripts

Pull Request - State: open - Opened by pallavisontakke 3 months ago - 1 comment

#7062 - Add patch release PR creation scripts

Pull Request - State: open - Opened by pallavisontakke 3 months ago - 1 comment

#7049 - Support chunkwise aggregation with projection

Pull Request - State: closed - Opened by akuzm 3 months ago - 1 comment

#7049 - Support chunkwise aggregation with projection

Pull Request - State: closed - Opened by akuzm 3 months ago - 1 comment

#7043 - Reduce Postgres logs noise on regression tests

Pull Request - State: open - Opened by fabriziomello 4 months ago - 1 comment
Labels: testing, ci

#7043 - Reduce Postgres logs noise on regression tests

Pull Request - State: open - Opened by fabriziomello 4 months ago - 1 comment
Labels: testing, ci

#7040 - Allow hypertable constraint creation USING INDEX

Pull Request - State: open - Opened by arajkumar 4 months ago - 4 comments

#7040 - Allow hypertable constraint creation USING INDEX

Pull Request - State: open - Opened by arajkumar 4 months ago - 4 comments

#7033 - Use MERGE statement on CAgg Refresh

Pull Request - State: closed - Opened by fabriziomello 4 months ago - 2 comments
Labels: continuous_aggregate

#7025 - Choose cheapest aggregated path as base for chunk-wise aggregation

Pull Request - State: open - Opened by akuzm 4 months ago - 1 comment

#7023 - Block ALTER TABLE...{RENAME | SET SCHEMA} on CAggs

Pull Request - State: open - Opened by fabriziomello 4 months ago - 3 comments
Labels: bug, continuous_aggregate, ddl

#7022 - Reduce drop_extension test flakiness

Pull Request - State: open - Opened by fabriziomello 4 months ago - 1 comment
Labels: flaky-test

#7021 - [Enhancement]: Remove requirement that `compress_after` be larger than refresh policy's `start_offset`

Issue - State: open - Opened by RobAtticus 4 months ago - 2 comments
Labels: enhancement, internal-team-ask

#7020 - Add support for column dimension range tracking

Pull Request - State: open - Opened by nikkhils 4 months ago - 6 comments

#7019 - Continuous aggregation calculation error

Issue - State: open - Opened by nieyuan1980 4 months ago
Labels: bug

#7018 - Fix search_path quoting in compression defaults function

Pull Request - State: open - Opened by svenklemm 4 months ago

#7017 - [Bug]: Upgradee PostgreSQL 15.3 with TS 2.15 to PostgreSQL 16.3 failed

Issue - State: closed - Opened by pgloader 4 months ago - 1 comment
Labels: bug

#7016 - Post release 2.15.2

Pull Request - State: closed - Opened by fabriziomello 4 months ago - 1 comment
Labels: release

#7015 - [Bug]: realtime aggregation select planning and execution time is poor

Issue - State: open - Opened by pohmelie 4 months ago
Labels: bug

#7014 - Release 2.15.2

Pull Request - State: closed - Opened by pallavisontakke 4 months ago - 1 comment

#7013 - Release 2.15.2

Pull Request - State: closed - Opened by fabriziomello 4 months ago - 1 comment
Labels: release

#7012 - Add known flaky tests to linux32bit CI

Pull Request - State: closed - Opened by fabriziomello 4 months ago
Labels: ci

#7011 - Backport to 2.15.x: #7005: Allow CAggs with variable sized bucked with origin/offset

Pull Request - State: closed - Opened by fabriziomello 4 months ago - 1 comment
Labels: manual-backport

#7010 - [Bug]: UPDATE is hundreds of times less effective as UPSERT statement

Issue - State: open - Opened by igor2x 4 months ago - 7 comments
Labels: bug

#7009 - Backport to 2.15.x: #6984: Fix show_chunks on hypertable by hash

Pull Request - State: closed - Opened by timescale-automation 4 months ago
Labels: is-auto-backport

#7008 - Reorder some tests in bgw_custom

Pull Request - State: closed - Opened by fabriziomello 4 months ago - 1 comment
Labels: testing, bgw, tech-debt

#7007 - Backport to 2.15.x: #7004: Fix segfault with closed primary dimension

Pull Request - State: closed - Opened by timescale-automation 4 months ago
Labels: is-auto-backport

#7006 - Calendar-based chunking PoC

Pull Request - State: open - Opened by erimatnor 4 months ago

#7005 - Allow CAggs with variable sized bucked with origin/offset

Pull Request - State: closed - Opened by fabriziomello 4 months ago - 2 comments
Labels: continuous_aggregate, time_bucket, auto-backport-not-done, force-auto-backport, backported-2.15.x

#7004 - Fix segfault with closed primary dimension

Pull Request - State: closed - Opened by svenklemm 4 months ago - 1 comment
Labels: backported-2.15.x

#7003 - Backport to 2.15.x: #6981: Fix segfault creating CAgg on hypertable by hash

Pull Request - State: closed - Opened by timescale-automation 4 months ago
Labels: is-auto-backport

#7002 - Backport to 2.15.x: #6996: Fix removal of metadata function and update script

Pull Request - State: closed - Opened by timescale-automation 4 months ago
Labels: is-auto-backport

#7001 - Backport to 2.15.x: #6992: Fix sort pushdown for partially compressed chunks

Pull Request - State: closed - Opened by antekresic 4 months ago

#7000 - Backport to 2.15.x: #6993: Disallow hash partitioning on primary column

Pull Request - State: closed - Opened by timescale-automation 4 months ago
Labels: is-auto-backport

#6999 - [Bug]: average(time_weight('linear')) yields incorrect result

Issue - State: open - Opened by relativityboy 4 months ago
Labels: bug, toolkit

#6998 - Consider origin time on monthly buckets

Pull Request - State: closed - Opened by fabriziomello 4 months ago - 2 comments
Labels: time_bucket

#6997 - Fix stale code in Ensure

Pull Request - State: closed - Opened by akuzm 4 months ago - 1 comment

#6996 - Fix removal of metadata function and update script

Pull Request - State: closed - Opened by antekresic 4 months ago - 1 comment
Labels: bug, backported-2.15.x

#6995 - Backport to 2.15.x: #6891: Fix the flaky merge_append_partially_compressed test

Pull Request - State: closed - Opened by timescale-automation 4 months ago
Labels: is-auto-backport

#6994 - Backport to 2.15.x: #6892: Fix some flakiness in transparent_decompression test

Pull Request - State: closed - Opened by timescale-automation 4 months ago
Labels: is-auto-backport

#6993 - Disallow hash partitioning on primary column

Pull Request - State: closed - Opened by nikkhils 4 months ago - 2 comments
Labels: bug, backported-2.15.x

#6992 - Fix sort pushdown for partially compressed chunks

Pull Request - State: closed - Opened by antekresic 4 months ago - 3 comments
Labels: bug, planner, compression, auto-backport-not-done, backported-2.15.x