Path to this page:
./
databases/postgresql-timescaledb,
The timescaledb extension for PostgreSQL
Branch: CURRENT,
Version: 2.19.3,
Package name: postgresql16-timescaledb-2.19.3,
Maintainer: otisTimescaleDB is an open-source time-series database optimized for fast ingest
and complex queries. It speaks "full SQL" and is correspondingly easy to use
like a traditional relational database, yet scales in ways previously reserved
for NoSQL databases.
WWW: https://docs.timescale.com/latest/introduction
Required to run:[
databases/postgresql14-client] [
databases/postgresql14-server]
Package options: timescale-license
Master sites:
Filesize: 7823.191 KB
Version history: (Expand)
- (2025-04-23) Updated to version: postgresql16-timescaledb-2.19.3
- (2025-04-08) Updated to version: postgresql16-timescaledb-2.19.2
- (2025-02-19) Updated to version: postgresql16-timescaledb-2.18.2
- (2025-02-11) Updated to version: postgresql16-timescaledb-2.18.1
- (2025-01-25) Updated to version: postgresql16-timescaledb-2.18.0
- (2024-11-08) Updated to version: postgresql14-timescaledb-2.17.2
CVS history: (Expand)
2025-04-17 06:59:38 by Adam Ciarcinski | Files touched by this commit (3) |  |
Log message:
postgresql-timescaledb: updated to 2.19.3
2.19.3
This release contains bug fixes since the 2.19.2 release. We recommend that you \
upgrade at the next available opportunity.
Bug fixes
* Don't capture hard errors in with-clause parser
* Don't capture hard errors for old cagg format
* Don't capture errors estimating time max spread
* Fix not using SkipScan over one chunk
* Allow TAM chunk creation as non-owner
* Fix TAM segfault on DELETE using segmentby column
* Allow scheduler restarts to be disabled
* Crash when grouping by multiple columns of a compressed table, one of which is \
a UUID segmentby column.
|
2025-04-08 09:33:08 by Adam Ciarcinski | Files touched by this commit (3) |  |
Log message:
postgresql-timescaledb: updated to 2.19.2
2.19.2
This release contains bug fixes since the 2.19.1 release. We recommend that you \
upgrade at the next available opportunity.
2.19.1
This release contains bug fixes since the 2.19.0 release. We recommend that you \
upgrade at the next available opportunity.
2.19.0
This release contains performance improvements and bug fixes since the 2.18.2 \
release. We recommend that you upgrade at the next available opportunity.
Improved concurrency of INSERT, UPDATE, and DELETE operations on the columnstore \
by no longer blocking DML statements during the recompression of a chunk.
Improved system performance during continuous aggregate refreshes by breaking \
them into smaller batches. This reduces systems pressure and minimizes the risk \
of spilling to disk.
Faster and more up-to-date results for queries against continuous aggregates by \
materializing the most recent data first, as opposed to old data first in prior \
versions.
Faster analytical queries with SIMD vectorization of aggregations over text \
columns and GROUP BY over multiple columns.
Enable optimizing the chunk size for better query performance in the columnstore \
by merging them with merge_chunk.
|
2025-02-19 20:28:04 by Adam Ciarcinski | Files touched by this commit (3) |  |
Log message:
postgresql-timescaledb: updated to 2.18.2
2.18.2
This release contains performance improvements and bug fixes since
the 2.18.1 release. We recommend that you upgrade at the next
available opportunity.
Bugfixes
* Potential wrong aggregation result when using vectorized aggregation with hash \
grouping in reverse order
* Fix ExplainHook breaking call chain
* Block dropping internal compressed chunks with drop_chunk()
* License error when using hypercore handler
* Respect other extensions' ExecutorStart hooks
|
2025-02-11 10:31:22 by Adam Ciarcinski | Files touched by this commit (3) |  |
Log message:
postgresql-timescaledb: updated to 2.18.1
2.18.1
Features
* Remove limitation of compression policy for continuous aggregates
Bugfixes
* Fix lock order when dropping index
* Allow EXPLAIN in read-only mode
* Fix DELETE on compressed chunk with non-btree operators
* Allow non-btree operator pushdown in UPDATE/DELETE queries on compressed chunks
* Push down orderby scankeys to Hypercore TAM
* Block merging of frozen chunks
* Don't abort additional INSERTs when hitting first conflict
GUCs
enable_hypercore_scankey_pushdown: Push down qualifiers as scankeys when using \
Hypercore TAM introduced with
|
2025-01-25 13:07:48 by Adam Ciarcinski | Files touched by this commit (3) |  |
Log message:
postgresql-timescaledb: updated to 2.18.0
2.18.0 (2025-01-23)
This release introduces the ability to add secondary indexes to the columnstore, \
improves group by and filtering performance through columnstore vectorization, \
and contains the highly upvoted community request of transition table support. \
We recommend that you upgrade at the next available opportunity.
Highlighted features in TimescaleDB v2.18.0
The ability to add secondary indexes to the columnstore through the new \
hypercore table access method.
Significant performance improvements through vectorization (SIMD) for \
aggregations using a group by with one column and/or using a filter clause when \
querying the columnstore.
Hypertables support triggers for transition tables, which is one of the most \
upvoted community feature requests.
Updated methods to manage Timescale's hybrid row-columnar store (hypercore) that \
highlight the usage of the columnstore which includes both an optimized columnar \
format as well as compression.
|
2024-11-08 14:46:49 by Adam Ciarcinski | Files touched by this commit (3) |  |
Log message:
postgresql-timescaledb: updated to 2.17.2
2.17.2 (2024-11-06)
This release contains bug fixes since the 2.17.1 release. We recommend that you
upgrade at the next available opportunity.
Bugfixes
Fix "negative bitmapset member not allowed" and performance degradation
on queries to compressed tables with ORDER BY clause matching the order of the
compressed data
Use-after-free in vectorized grouping by segmentby columns
2.17.1 (2024-10-21)
This release contains performance improvements and bug fixes since the 2.17.0 \
release. We recommend that you upgrade at the next available opportunity.
Features
Add chunk skipping GUC
Bugfixes
Change log level used in compression
Fix collation for in-memory tuple filtering
2.17.0 (2024-10-08)
This release adds support for PostgreSQL 17, significantly improves the \
performance of continuous aggregate refreshes, and contains performance \
improvements for analytical queries and delete operations over compressed \
hypertables.
We recommend that you upgrade at the next available opportunity.
Highlighted features in TimescaleDB v2.17.0
Full PostgreSQL 17 support for all existing features. TimescaleDB v2.17 is \
available for PostgreSQL 14, 15, 16, and 17.
Significant performance improvements for continuous aggregate policies:
Continuous aggregate refresh is now using merge instead of deleting old \
materialized data and re-inserting. This update can decrease dramatically the \
amount of data that must be written on the continuous aggregate in the presence \
of a small number of changes, reduce the i/o cost of refreshing a continuous \
aggregate, and generate fewer Write-Ahead Logs (WAL). Overall, continuous \
aggregate policies will be more lightweight, use less system resources, and \
complete faster.
Increased performance for real-time analytical queries over compressed hypertables:
We are excited to introduce additional Single Instruction, Multiple Data (SIMD) \
vectorization optimization to our engine by supporting vectorized execution for \
queries that group by using the segment_by column(s) and aggregate using the \
basic aggregate functions (sum, count, avg, min, max).
Stay tuned for more to come in follow-up releases! Support for grouping
on additional columns, filtered aggregation,
vectorized expressions, and time_bucket is coming soon.
Improved performance of deletes on compressed hypertables when a large amount of \
data is affected.
This improvement speeds up operations that delete whole segments by skipping the \
decompression step. It is enabled for all deletes that filter by the segment_by \
column(s).
|
2024-08-25 08:19:21 by Thomas Klausner | Files touched by this commit (575) |
Log message:
*: replace CMAKE_ARGS with CMAKE_CONFIGURE_ARGS
|
2024-08-07 11:40:31 by Adam Ciarcinski | Files touched by this commit (3) |  |
Log message:
postgresql-timescaledb: updated to 2.16.1
2.16.1
This release contains bug fixes since the 2.16.0 release. We recommend that you \
upgrade at the next available opportunity.
Bugfixes
Fix untier_chunk for hypertables with foreign keys
|