Navigation:
Browse pkgsrc
(this page)
databases postgres..
CVSweb ] [ 
Homepage ] [ 
RSS ] [ 
Required by ] [ 
Add to tracker ] 2023-11-03 10:15:34 by Adam Ciarcinski | Files touched by this commit (3) |  |
Log message: postgresql-timescaledb: updated to 2.12.2 2.12.2 This release contains bug fixes since the 2.12.1 release. We recommend that you upgrade at the next available opportunity. Bugfixes * Align gapfill bucket generation with time_bucket * Ensure fixed_schedule field is populated * Fix EXPLAIN ANALYZE for compressed DML 2.12.1 This release contains bug fixes since the 2.12.0 release. We recommend that you upgrade at the next available opportunity. Bugfixes * Fix planner distributed table count * Avoid decompressing batches using an empty slot * Fix concurrency errors in OSM API * do not throw an error when deprecation GUC cannot be read 2.12.0 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 * MERGE support on hypertables * Make hypertables support replica identity * Index scan support during UPDATE/DELETE on compressed hypertables * Support for partial aggregations at chunk level * Enable ChunkAppend for partially compressed chunks * Improve the number of parallel workers for decompression * Enable altering job schedule type through alter_job * Make logrepl markers for (partial) decompressions * Relax invalidation threshold table-level lock to row-level when refreshing a \ Continuous Aggregate * Support CAgg names in chunk_detailed_size * Make set_chunk_time_interval CAggs aware * Allow ALTER TABLE ... REPLICA IDENTITY (FULL|INDEX) on materialized \ hypertables (continuous aggregates) * Add job exit status and runtime to log * CREATE INDEX ONLY ON hypertable creates index on chunks Bugfixes * Fix interval calculation for hierarchical CAggs * Check unique indexes when enabling compression * _timescaledb_internal.create_compressed_chunk doesn't account for existing \ uncompressed rows * Move functions to _timescaledb_functions schema * Chunk_create must add an existing table or fail * Fix duplicates on partially compressed chunk reads * Fix crash in COPY from program returning error * Place data in first/last function in correct mctx * Call eq_func correctly in time_bucket_gapfill * Correct row count in EXPLAIN ANALYZE INSERT .. ON CONFLICT output * Fix server crash on UPDATE of compressed chunk * Fix server crash when using duplicate segmentby column * Fix segfault in set_integer_now_func * Fix approximate_row_count for CAggs * Improve compressed DML datatype handling * Propagate parameter changes to decompress child nodes * Schedule compression policy more often |
| 2023-08-23 17:40:13 by Adam Ciarcinski | Files touched by this commit (3) | |
Log message: postgresql-timescaledb: updated to 2.11.2 2.11.2 This release contains bug fixes since the 2.11.1 release. We recommend that you upgrade at the next available opportunity. Features * Feature flags for TimescaleDB features Bugfixes * Fix DISTINCT query with JOIN on multiple segmentby columns * Fixed two bugs in decompression sorted merge code * Ensure pg_config --cppflags are passed * Fix quoting owners in sql scripts. * Fix crash in 1-step integer policy creation |
| 2023-08-02 08:38:30 by Adam Ciarcinski | Files touched by this commit (3) | |
Log message: postgresql-timescaledb: updated to 2.11.1 2.11.1 (2023-06-29) This release contains bug fixes since the 2.11.0 release. We recommend that you upgrade at the next available opportunity. **Features** * Update the loader to add support for the OSM extension (used for data tiering \ on [Timescale](https://www.timescale.com/)) **Bugfixes** * Scheduler accidentally getting killed when calling `delete_job` * Fix Result node handling with ConstraintAwareAppend on compressed chunks * Ensure tlist is present in decompress chunk plan * Fixed handling of NULL values in bookend_sfunc * Fixed batch look ahead in compressed sorted merge * Mark cagg_watermark function as PARALLEL RESTRICTED * Copy job config JSONB structure into current MemoryContext * Improve continuous aggregate query chunk exclusion 2.11.0 (2023-05-12) This release contains new features and bug fixes since the 2.10.3 release. We deem it moderate priority for upgrading. This release includes these noteworthy features: * Support for DML operations on compressed chunks: * UPDATE/DELETE support * Support for unique constraints on compressed chunks * Support for `ON CONFLICT DO UPDATE` * Support for `ON CONFLICT DO NOTHING` * Join support for Hierarchical Continuous Aggregates * Performance improvements for real-time Hierarchical Continuous Aggregates **Features** * Allow pushdown of reference table joins * Improve Realtime Continuous Aggregate performance * Improve unique constraint support on compressed hypertables * Support UPDATE/DELETE on compressed hypertables * Enable JOINS for Hierarchical Continuous Aggregates * Add parallel support for partialize_agg() * Refactor and optimize distributed COPY * Add support for ON CONFLICT DO UPDATE for compressed hypertables * Skip Ordered Append when only 1 child node is present * Propagate vacuum/analyze to compressed chunks * Reduce decompression during constraint checking * Optimize compressed chunk resorting * Support sending telemetry event reports **Bugfixes** * Fix SEGMENTBY columns predicates to be pushed down * Handle user-defined FDW options properly * Decompression may have lost DEFAULT values * Fix issue creating dimensional constraints * Improve interpolate error message on datatype mismatch * Fix unique constraint on compressed tables * Add permission checks to run_job() * Enable run_job() for telemetry job * Fix on-insert decompression after schema changes * Quote username identifier appropriately * Fix tablespace for compressed hypertable and corresponding toast * Fix ALTER TABLE SET with normal tables * Reduce memory usage for distributed analyze * Fix subtransaction resource owner |
| 2023-04-28 09:34:42 by Adam Ciarcinski | Files touched by this commit (3) | |
Log message: postgresql-timescaledb: updated to 2.10.3 2.10.3 Bug fixes * Fix parameterization in DecompressChunk path generation * Fix broken CAgg with JOIN repair function 2.10.2 Bug fixes * Fix file trailer handling in the COPY fetcher * Add checks for malloc failure in libpq calls * Out of on_proc_exit slots on guc license change * Use consistent snapshots when scanning metadata * Do not segfault on large histogram() parameters * Ensure superuser perms during copy/move chunk * Fix when no FROM clause in continuous aggregate definition * Fix join rte in CAggs with joins * Fix duplicated entries on timescaledb_experimental.policies view * Fix segfault after column drop on compressed table * Copy scheduled_jobs list before sorting it * Allow named time_bucket arguments in Cagg definition * Fix refresh from beginning of Continuous Aggregate with variable time bucket * Use regrole for job owner * Enable indexscan on uncompressed part of partially compressed chunks 2.10.1 Bug fixes * Support Continuous Aggregates names in hypertable_(detailed_)size * Fix concurrent locking with chunk_data_node table * Fix some incorrect memory handling * Use NameData and namestrcpy for names * Set PortalContext when starting job * Fix uninitialized bucket_info variable * Make copy fetcher more async * Fix num_chunks inconsistency in hypertables view * Fix column name handling in old-style continuous aggregates * Fix multinode DML HA performance regression * Fix Hierarchical Continuous Aggregates chunk_interval_size * Fix sub-second intervals in hierarchical caggs 2.10.0 Features * Allow joins in continuous aggregates * Refactor INSERT into compressed chunks * Allow RETURNING clause when inserting into compressed chunks * Manage life-cycle of connections via memory contexts * Make connection establishment interruptible * Make data node command execution interruptible * Extend enabling compression on a continuous aggregrate with \ 'compress_segmentby' and 'compress_orderby' parameters Bugfixes * Fix use of prepared statement in async module * Add role-level security to job error log * Fix next_start calculation for fixed schedules * Fix enabling compression on continuous aggregates with columns requiring quotation |
| 2023-02-10 12:09:47 by Tobias Nygren | Files touched by this commit (3) | |
Log message: postgresql-timescaledb: update to 2.9.3 Skip bucketing when start or end of refresh job is null Fix column ordering in compressed table index not following the order of a multi-column segment by definition Don't enable clang-tidy by default Fix year not being considered as a multiple of day/month in hierarchical continuous aggregates Lock down search_path in SPI calls |
| 2023-01-03 14:23:21 by Tobias Nygren | Files touched by this commit (3) | |
Log message: postgresql-timescaledb: update to 2.9.1 Hierarchical Continuous Aggregates Improve time_bucket_gapfill function Introduce fixed schedules for background jobs Use alter_data_node() to change the data node configuration |
| 2022-10-29 17:26:55 by Tobias Nygren | Files touched by this commit (3) | |
Log message: postgresql-timescaledb: update to 2.8.1 bugfixes |
| 2022-09-04 13:25:32 by Tobias Nygren | Files touched by this commit (4) | |
Log message: postgresql-timescaledb: update to 2.8.0 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 |
New packages: