Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql-timescaledb
Request diff between arbitrary revisions
Default branch: MAIN
Revision 1.19 / (download) - annotate - [select for diffs], Fri Apr 28 07:34:42 2023 UTC (6 weeks ago) by adam
Branch: MAIN
CVS Tags: HEAD
Changes since 1.18: +4 -4
lines
Diff to previous 1.18 (colored)
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
Revision 1.18 / (download) - annotate - [select for diffs], Fri Feb 10 11:09:47 2023 UTC (3 months, 3 weeks ago) by tnn
Branch: MAIN
CVS Tags: pkgsrc-2023Q1-base,
pkgsrc-2023Q1
Changes since 1.17: +4 -4
lines
Diff to previous 1.17 (colored)
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
Revision 1.17 / (download) - annotate - [select for diffs], Tue Jan 3 13:23:21 2023 UTC (5 months ago) by tnn
Branch: MAIN
Changes since 1.16: +4 -4
lines
Diff to previous 1.16 (colored)
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
Revision 1.16 / (download) - annotate - [select for diffs], Sat Oct 29 15:26:55 2022 UTC (7 months, 1 week ago) by tnn
Branch: MAIN
CVS Tags: pkgsrc-2022Q4-base,
pkgsrc-2022Q4
Changes since 1.15: +4 -4
lines
Diff to previous 1.15 (colored)
postgresql-timescaledb: update to 2.8.1 bugfixes
Revision 1.15 / (download) - annotate - [select for diffs], Sun Sep 4 11:25:32 2022 UTC (9 months ago) by tnn
Branch: MAIN
CVS Tags: pkgsrc-2022Q3-base,
pkgsrc-2022Q3
Changes since 1.14: +4 -5
lines
Diff to previous 1.14 (colored)
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
Revision 1.14 / (download) - annotate - [select for diffs], Mon Jul 18 15:50:03 2022 UTC (10 months, 3 weeks ago) by tnn
Branch: MAIN
Changes since 1.13: +4 -4
lines
Diff to previous 1.13 (colored)
postgresql-timescaledb: update to 2.7.0 Optimize continuous aggregate query performance and storage The following query clauses and functions can now be used in a continuous aggregate: FILTER, DISTINCT, ORDER BY as well as Ordered-Set Aggregate and Hypothetical-Set Aggregate Optimize now() query planning time Improve COPY insert performance Improve performance of UPDATE/DELETE on PG14 by excluding chunks
Revision 1.13 / (download) - annotate - [select for diffs], Tue Apr 12 22:02:49 2022 UTC (13 months, 3 weeks ago) by tnn
Branch: MAIN
CVS Tags: pkgsrc-2022Q2-base,
pkgsrc-2022Q2
Changes since 1.12: +4 -4
lines
Diff to previous 1.12 (colored)
postgresql-timescaledb: update to 2.6.1 4121 Fix RENAME TO/SET SCHEMA on distributed hypertable 4122 Fix segfault on INSERT into distributed hypertable 4142 Ignore invalid relid when deleting hypertable 4159 Fix ADD COLUMN IF NOT EXISTS error on compressed hypertable 4161 Fix memory handling during scans 4176 Fix remote EXPLAIN with parameterized queries 4181 Fix spelling errors and omissions 4186 Fix owner change for distributed hypertable 4192 Abort sessions after extension reload 4193 Fix relcache callback handling causing crashes 4199 Remove signal-unsafe calls from signal handlers 4219 Do not modify aggregation state in finalize
Revision 1.12 / (download) - annotate - [select for diffs], Fri Mar 11 18:35:32 2022 UTC (14 months, 4 weeks ago) by tnn
Branch: MAIN
CVS Tags: pkgsrc-2022Q1-base,
pkgsrc-2022Q1
Changes since 1.11: +5 -5
lines
Diff to previous 1.11 (colored)
postgresql-timescaledb: update to 2.6.0 - Continuous aggregates with compression - time_bucket_ng support for N months and timezones on cont. aggregates - Query planning performance is improved for hypertables with a large number of chunks.
Revision 1.11 / (download) - annotate - [select for diffs], Fri Dec 10 11:20:03 2021 UTC (17 months, 4 weeks ago) by tnn
Branch: MAIN
CVS Tags: pkgsrc-2021Q4-base,
pkgsrc-2021Q4
Changes since 1.10: +4 -4
lines
Diff to previous 1.10 (colored)
postgresql-timescaledb: update to 2.5.1 Continuous Aggregates for Distributed Hypertables Support for PostgreSQL 14 Experimental: Support for timezones in time_bucket_ng()
Revision 1.10 / (download) - annotate - [select for diffs], Tue Oct 26 10:09:46 2021 UTC (19 months, 1 week ago) by nia
Branch: MAIN
Changes since 1.9: +2 -2
lines
Diff to previous 1.9 (colored)
databases: Replace RMD160 checksums with BLAKE2s checksums All checksums have been double-checked against existing RMD160 and SHA512 hashes The following distfiles could not be fetched (some may be only fetched conditionally): ./databases/cstore/distinfo D6.data.ros.gz ./databases/cstore/distinfo cstore0.2.tar.gz ./databases/cstore/distinfo data4.tar.gz
Revision 1.9 / (download) - annotate - [select for diffs], Thu Oct 7 13:35:34 2021 UTC (20 months ago) by nia
Branch: MAIN
Changes since 1.8: +1 -2
lines
Diff to previous 1.8 (colored)
databases: Remove SHA1 distfile hashes
Revision 1.8 / (download) - annotate - [select for diffs], Sun Oct 3 18:10:21 2021 UTC (20 months ago) by tnn
Branch: MAIN
Changes since 1.7: +5 -5
lines
Diff to previous 1.7 (colored)
postgresql-timescaledb: update to 2.4.2 Fixes the bug that broke background workers, and some other minor things.
Revision 1.7 / (download) - annotate - [select for diffs], Tue Aug 24 18:23:22 2021 UTC (21 months, 2 weeks ago) by tnn
Branch: MAIN
CVS Tags: pkgsrc-2021Q3-base,
pkgsrc-2021Q3
Changes since 1.6: +5 -5
lines
Diff to previous 1.6 (colored)
postgresql-timescaledb: update to 2.4.1 The release fixes continuous aggregate refresh for postgres 12.8 and 13.4, a crash with ALTER TABLE commands and a crash with continuous aggregates with HAVING clause. This release adds new experimental features since the 2.3.1 release: - APIs for chunk manipulation across data nodes - The time_bucket_ng function, a newer version of time_bucket PostgreSQL 11 is deprecated and not supported with TimescaleDB 2.4.
Revision 1.6 / (download) - annotate - [select for diffs], Sun Jul 25 16:45:55 2021 UTC (22 months, 2 weeks ago) by tnn
Branch: MAIN
Changes since 1.5: +6 -6
lines
Diff to previous 1.5 (colored)
postgresql-timescaledb: update to 2.3.1 This maintenance release contains bugfixes since the 2.3.0 release. We deem it moderate priority for upgrading. The release introduces the possibility of generating downgrade scripts, improves the trigger handling for distributed hypertables, adds some more randomness to chunk assignment to avoid thundering herd issues in chunk assignment, and fixes some issues in update handling as well as some other bugs.
Revision 1.5 / (download) - annotate - [select for diffs], Wed Jun 23 19:11:01 2021 UTC (23 months, 2 weeks ago) by tnn
Branch: MAIN
Changes since 1.4: +5 -5
lines
Diff to previous 1.4 (colored)
postgresql-timescaledb: update to 2.3.0 This release adds support for inserting data into compressed chunks and improves performance when inserting data into distributed hypertables. Distributed hypertables now also support triggers and compression policies. The bug fixes in this release address issues related to the handling of privileges on compressed hypertables, locking, and triggers with transition tables.
Revision 1.4 / (download) - annotate - [select for diffs], Sun Apr 25 10:07:42 2021 UTC (2 years, 1 month ago) by tnn
Branch: MAIN
CVS Tags: pkgsrc-2021Q2-base,
pkgsrc-2021Q2
Changes since 1.3: +5 -5
lines
Diff to previous 1.3 (colored)
timescaledb: update to 2.2.0 Major Features Add distributed restore point functionality SkipScan to speed up SELECT DISTINCT Bugfixes Refactor and harden size and stats functions Reduce memory usage for distributed inserts Fix extremely slow multi-node order by queries Fix chunk index column name mapping Keep Append pathkeys in ChunkAppend
Revision 1.3 / (download) - annotate - [select for diffs], Sat Apr 3 17:15:42 2021 UTC (2 years, 2 months ago) by tnn
Branch: MAIN
Changes since 1.2: +5 -5
lines
Diff to previous 1.2 (colored)
postgresql-timescaledb: update to 2.1.1 This release add support for PostgreSQL major version 13.
Revision 1.2 / (download) - annotate - [select for diffs], Sat Feb 13 11:32:35 2021 UTC (2 years, 3 months ago) by tnn
Branch: MAIN
CVS Tags: pkgsrc-2021Q1-base,
pkgsrc-2021Q1
Changes since 1.1: +6 -5
lines
Diff to previous 1.1 (colored)
postgresql-timescaledb: update to 2.0.1 TimescaleDB 2.0 adds the much-anticipated support for distributed hypertables (multi-node TimescaleDB), as well as new features and enhancements to core functionality to give users better clarity and more control and flexibility over their data. This release also adds: - Support for user-defined actions, allowing users to define, customize, and schedule automated tasks, which can be run by the built-in jobs scheduling framework now exposed to users. - Significant changes to continuous aggregates, which now separate the view creation from the policy. Users can now refresh individual regions of the continuous aggregate materialized view, or schedule automated refreshing via policy. - Redesigned informational views, including new (and more general) views for information about hypertable's dimensions and chunks, policies and user-defined actions, as well as support for multi-node TimescaleDB. - Moving all formerly enterprise features into our Community Edition, and updating Timescale License, which now provides additional (more permissive) rights to users and developers. Some of the changes above (e.g., continuous aggregates, updated informational views) do introduce breaking changes to APIs and are not backwards compatible. While the update scripts in TimescaleDB 2.0 will upgrade databases running TimescaleDB 1.x automatically, some of these API and feature changes may require changes to clients and/or upstream scripts that rely on the previous APIs. Before upgrading, we recommend reviewing upgrade documentation at docs.timescale.com for more details.
Revision 1.1 / (download) - annotate - [select for diffs], Fri Oct 9 08:28:05 2020 UTC (2 years, 7 months ago) by otis
Branch: MAIN
CVS Tags: pkgsrc-2020Q4-base,
pkgsrc-2020Q4
databases/postgresql-timescaledb: Import timescaledb-1.7.4 TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL and packaged as a PostgreSQL extension, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. WWW: https://github.com/timescale/timescaledb