head	1.52;
access;
symbols
	pkgsrc-2026Q1:1.50.0.2
	pkgsrc-2026Q1-base:1.50
	pkgsrc-2025Q4:1.46.0.4
	pkgsrc-2025Q4-base:1.46
	pkgsrc-2025Q3:1.46.0.2
	pkgsrc-2025Q3-base:1.46
	pkgsrc-2025Q2:1.44.0.2
	pkgsrc-2025Q2-base:1.44
	pkgsrc-2025Q1:1.38.0.2
	pkgsrc-2025Q1-base:1.38
	pkgsrc-2024Q4:1.35.0.2
	pkgsrc-2024Q4-base:1.35
	pkgsrc-2024Q3:1.34.0.2
	pkgsrc-2024Q3-base:1.34
	pkgsrc-2024Q2:1.30.0.2
	pkgsrc-2024Q2-base:1.30
	pkgsrc-2024Q1:1.27.0.2
	pkgsrc-2024Q1-base:1.27
	pkgsrc-2023Q4:1.23.0.2
	pkgsrc-2023Q4-base:1.23
	pkgsrc-2023Q3:1.22.0.2
	pkgsrc-2023Q3-base:1.22
	pkgsrc-2023Q2:1.20.0.2
	pkgsrc-2023Q2-base:1.20
	pkgsrc-2023Q1:1.19.0.2
	pkgsrc-2023Q1-base:1.19
	pkgsrc-2022Q4:1.17.0.2
	pkgsrc-2022Q4-base:1.17
	pkgsrc-2022Q3:1.16.0.2
	pkgsrc-2022Q3-base:1.16
	pkgsrc-2022Q2:1.14.0.2
	pkgsrc-2022Q2-base:1.14
	pkgsrc-2022Q1:1.13.0.2
	pkgsrc-2022Q1-base:1.13
	pkgsrc-2021Q4:1.12.0.2
	pkgsrc-2021Q4-base:1.12
	pkgsrc-2021Q3:1.10.0.2
	pkgsrc-2021Q3-base:1.10
	pkgsrc-2021Q2:1.7.0.2
	pkgsrc-2021Q2-base:1.7
	pkgsrc-2021Q1:1.5.0.2
	pkgsrc-2021Q1-base:1.5
	pkgsrc-2020Q4:1.3.0.2
	pkgsrc-2020Q4-base:1.3;
locks; strict;
comment	@# @;


1.52
date	2026.04.30.09.16.05;	author adam;	state Exp;
branches;
next	1.51;
commitid	QoUpyUvlcP2JMXDG;

1.51
date	2026.04.17.10.14.09;	author adam;	state Exp;
branches;
next	1.50;
commitid	9C6y0yD8uoOtwiCG;

1.50
date	2026.03.05.10.38.19;	author adam;	state Exp;
branches;
next	1.49;
commitid	NEnzyFcBlXlz2MwG;

1.49
date	2026.02.18.07.29.06;	author adam;	state Exp;
branches;
next	1.48;
commitid	xRvzIFKf7YWrtPuG;

1.48
date	2026.02.13.11.51.53;	author adam;	state Exp;
branches;
next	1.47;
commitid	Xs2v0ijM0igz5duG;

1.47
date	2025.12.26.09.21.02;	author adam;	state Exp;
branches;
next	1.46;
commitid	uts6GpFYvfdzPTnG;

1.46
date	2025.08.19.07.33.33;	author adam;	state Exp;
branches;
next	1.45;
commitid	5uID4E3QLvQKnj7G;

1.45
date	2025.08.08.09.16.27;	author adam;	state Exp;
branches;
next	1.44;
commitid	kPZrFlynsAwWiU5G;

1.44
date	2025.06.11.12.41.24;	author adam;	state Exp;
branches;
next	1.43;
commitid	xz8IH2yunsFRitYF;

1.43
date	2025.06.02.15.57.39;	author adam;	state Exp;
branches;
next	1.42;
commitid	cVVEPmiE7Kd2GkXF;

1.42
date	2025.05.19.09.11.27;	author adam;	state Exp;
branches;
next	1.41;
commitid	wp5LEIzvXAgISuVF;

1.41
date	2025.05.06.09.44.07;	author wiz;	state Exp;
branches;
next	1.40;
commitid	yd7RHCI3r0jUtPTF;

1.40
date	2025.04.17.04.59.38;	author adam;	state Exp;
branches;
next	1.39;
commitid	IdGoOguECAK3wmRF;

1.39
date	2025.04.08.07.33.08;	author adam;	state Exp;
branches;
next	1.38;
commitid	pX07Eq1i8iAzEdQF;

1.38
date	2025.02.19.19.28.04;	author adam;	state Exp;
branches;
next	1.37;
commitid	xfcunzHSjO3s97KF;

1.37
date	2025.02.11.09.31.22;	author adam;	state Exp;
branches;
next	1.36;
commitid	j8JkIjH1JzkM62JF;

1.36
date	2025.01.25.12.07.48;	author adam;	state Exp;
branches;
next	1.35;
commitid	PQaxt2pzxidpwRGF;

1.35
date	2024.11.08.13.46.49;	author adam;	state Exp;
branches;
next	1.34;
commitid	Q2yvRUzBqohBzQwF;

1.34
date	2024.08.25.06.18.31;	author wiz;	state Exp;
branches;
next	1.33;
commitid	BcrSL94SO85mvanF;

1.33
date	2024.08.07.09.40.31;	author adam;	state Exp;
branches;
next	1.32;
commitid	Xwd0KowJBFpFcSkF;

1.32
date	2024.08.04.07.26.04;	author adam;	state Exp;
branches;
next	1.31;
commitid	jKVjhbfBZNiuytkF;

1.31
date	2024.07.13.05.22.59;	author adam;	state Exp;
branches;
next	1.30;
commitid	vBcnI1Ioizq0ADhF;

1.30
date	2024.06.07.20.38.05;	author adam;	state Exp;
branches;
next	1.29;
commitid	WEBtfQb3zLZKN5dF;

1.29
date	2024.05.29.11.11.25;	author adam;	state Exp;
branches;
next	1.28;
commitid	7ioapc6I7BVmXSbF;

1.28
date	2024.05.11.05.22.54;	author adam;	state Exp;
branches;
next	1.27;
commitid	qr3SPWAGrJrDBx9F;

1.27
date	2024.02.20.19.46.50;	author adam;	state Exp;
branches;
next	1.26;
commitid	gydTJPVSuNPpZcZE;

1.26
date	2024.02.14.21.54.21;	author adam;	state Exp;
branches;
next	1.25;
commitid	9k2VFN3OAIi9TrYE;

1.25
date	2024.02.10.11.04.53;	author adam;	state Exp;
branches;
next	1.24;
commitid	BweForYS0mWbqSXE;

1.24
date	2024.01.22.09.10.14;	author adam;	state Exp;
branches;
next	1.23;
commitid	3GBXU7EYn8uGoqVE;

1.23
date	2023.11.03.09.15.34;	author adam;	state Exp;
branches;
next	1.22;
commitid	qcFl96Dc4XoRZ8LE;

1.22
date	2023.08.23.15.40.13;	author adam;	state Exp;
branches;
next	1.21;
commitid	exnKbWgAVgExrVBE;

1.21
date	2023.08.02.06.38.30;	author adam;	state Exp;
branches;
next	1.20;
commitid	HIBAj9PfFwTl7bzE;

1.20
date	2023.04.28.07.34.42;	author adam;	state Exp;
branches;
next	1.19;
commitid	lxhFQP61kkPlvQmE;

1.19
date	2023.02.10.11.09.47;	author tnn;	state Exp;
branches;
next	1.18;
commitid	RbX9pNE4lyMabYcE;

1.18
date	2023.01.03.13.23.21;	author tnn;	state Exp;
branches;
next	1.17;
commitid	qJB8ELJJbej1968E;

1.17
date	2022.10.29.15.26.55;	author tnn;	state Exp;
branches;
next	1.16;
commitid	apg2muesDFFVWCZD;

1.16
date	2022.09.04.11.25.32;	author tnn;	state Exp;
branches;
next	1.15;
commitid	53gqFf0r4A3JnxSD;

1.15
date	2022.07.18.15.50.03;	author tnn;	state Exp;
branches;
next	1.14;
commitid	657SJ2yABaPOnoMD;

1.14
date	2022.04.12.22.02.49;	author tnn;	state Exp;
branches;
next	1.13;
commitid	Hq1Zyr9GSFelzXzD;

1.13
date	2022.03.11.18.35.32;	author tnn;	state Exp;
branches;
next	1.12;
commitid	eG67DDxYiMkTrPvD;

1.12
date	2021.12.10.11.20.03;	author tnn;	state Exp;
branches;
next	1.11;
commitid	Adgy2mglSkVXX5kD;

1.11
date	2021.10.03.18.10.21;	author tnn;	state Exp;
branches;
next	1.10;
commitid	65eYTzjEum1FpobD;

1.10
date	2021.08.24.18.23.22;	author tnn;	state Exp;
branches;
next	1.9;
commitid	LdLBbRbUb9akMf6D;

1.9
date	2021.07.25.16.45.55;	author tnn;	state Exp;
branches;
next	1.8;
commitid	mRX046I5odzIco2D;

1.8
date	2021.06.23.19.11.01;	author tnn;	state Exp;
branches;
next	1.7;
commitid	Ost6CBvyiVza2iYC;

1.7
date	2021.04.25.10.07.42;	author tnn;	state Exp;
branches;
next	1.6;
commitid	QeRxiSeS2JZtVEQC;

1.6
date	2021.04.03.17.15.42;	author tnn;	state Exp;
branches;
next	1.5;
commitid	tDZ6hBOr6dtHZRNC;

1.5
date	2021.02.13.15.16.04;	author gdt;	state Exp;
branches;
next	1.4;
commitid	PiF7Qgpa8a0QUyHC;

1.4
date	2021.02.13.11.32.35;	author tnn;	state Exp;
branches;
next	1.3;
commitid	MChZm5o03Bl3GxHC;

1.3
date	2020.10.27.12.12.09;	author adam;	state Exp;
branches;
next	1.2;
commitid	ixNyPHnWjwMXoxtC;

1.2
date	2020.10.10.11.20.10;	author mef;	state Exp;
branches;
next	1.1;
commitid	9RMkIIUkn8P0FlrC;

1.1
date	2020.10.09.08.28.05;	author otis;	state Exp;
branches;
next	;
commitid	HOEjNP9w3UvYJcrC;


desc
@@


1.52
log
@postgresql-timescaledb: updated to 2.26.4

2.26.4

Sanitize `DT_NOBEGIN` next_start to recover jobs stuck after primary failover
Fix `now()` constification for continuous aggregate queries
Fix out of memory when propagating `ALTER TABLE` to many chunks
Fix `InstrStartNode` called twice in a row
Fix use-after-free of `PlaceHolderVar.phrels` in cached ChunkAppend plans
Fix `PlaceHolderVar` error in runtime chunk exclusion
Remove stale hypertable entries during upgrade
Fix segfault with transition tables after column drop
Use `DROP CASCADE` for trigger removal
Error when querying compressed chunks under Apache license
Make `timescaledb_post_restore()` reliably restart background workers in a single call
Fix lost orderby sparse index
Replace `ERRCODE_INTERNAL_ERROR` on user-reachable error paths
Add Error on missing custom job function in `ts_bgw_job_get_funci`
Fix data corruption when merging chunks with different compression settings
Fix `sort_transform` crash with hypertable on nullable side of outer join
Fix concurrent merge of compressed chunks dropping the new heap
Fix `COPY` path with transition tables after column drop
Fix incremental continuous aggregate refresh so that `extend_last_bucket` only applies to the boundary batch
Fix segmentby crash in cagg invalidation tracking
@
text
@# $NetBSD: Makefile,v 1.51 2026/04/17 10:14:09 adam Exp $

DISTNAME=	timescaledb-2.26.4
PKGNAME=	postgresql${PGSQL_VERSION}-${DISTNAME}
CATEGORIES=	databases
MASTER_SITES=	${MASTER_SITE_GITHUB:=timescale/}
GITHUB_PROJECT=	timescaledb

MAINTAINER=	otis@@NetBSD.org
HOMEPAGE=	https://github.com/timescale/timescaledb
COMMENT=	The timescaledb extension for PostgreSQL
LICENSE=	apache-2.0

DEPENDS+=	postgresql${PGSQL_VERSION}-server>=0:../../databases/postgresql${PGSQL_VERSION}-server

CMAKE_CONFIGURE_ARGS+=	-DUSE_OPENSSL=ON
CMAKE_CONFIGURE_ARGS+=	-DREGRESS_CHECKS=OFF

PGSQL_VERSIONS_ACCEPTED=	18 17 16 15

PKG_OPTIONS_VAR=		PKG_OPTIONS.timescaledb
PKG_SUPPORTED_OPTIONS+=		timescale-license
PKG_SUGGESTED_OPTIONS+=		timescale-license

.include "../../mk/bsd.options.mk"

PLIST_VARS+=		tsl
.if !empty(PKG_OPTIONS:Mtimescale-license)
LICENSE+=		AND timescale-license
CMAKE_CONFIGURE_ARGS+=	-DAPACHE_ONLY=OFF
RESTRICTED=		No clear permission granted to distribute
NO_SRC_ON_FTP=		${RESTRICTED}
NO_SRC_ON_CDROM=	${RESTRICTED}
NO_BIN_ON_FTP=		${RESTRICTED}
NO_BIN_ON_CDROM=	${RESTRICTED}
PLIST.tsl=		yes
.else
CMAKE_CONFIGURE_ARGS+=	-DAPACHE_ONLY=ON
.endif

.include "../../devel/cmake/build.mk"
.include "../../mk/pgsql.buildlink3.mk"
.include "../../mk/bsd.pkg.mk"
@


1.51
log
@postgresql-timescaledb: updated to 2.26.3

2.26.3 (2026-04-14)

This release contains bug fixes since the 2.26.2 release. We recommend that you upgrade at the next available opportunity.

2.26.2 (2026-04-07)

This release contains bug fixes since the 2.26.1 release. We recommend that you upgrade at the next available opportunity.

2.26.1 (2026-03-30)

This release contains bug fixes since the 2.26.0 release. We recommend that you upgrade at the next available opportunity.

2.26.0 (2026-03-24)

This release contains performance improvements and bug fixes since the 2.25.2 release. We recommend that you upgrade at the next available opportunity.

Highlighted features in TimescaleDB v2.26.0

The vectorized aggregation engine now evaluates PostgreSQL functions directly on columnar arguments and stores the results in a columnar format to preserve the high-speed execution pipeline. For analytical queries that leverage functions like time_bucket() in grouping or aggregation expressions, the function is evaluated natively without falling back to standard row-based processing. This enhancement ensures that the remainder of the query can seamlessly continue using the highly efficient columnar pipeline, yielding performance improvements of 3.5 times faster.
The query execution engine now supports composite bloom filters for SELECT and UPSERT operations, pushing down multi-column predicates directly to compressed table scans. This optimization bypasses costly batch decompression by automatically selecting the most restrictive bloom filter to quickly verify if target values are present. Showing over two times faster query performance when a composite bloom filter is used. Additionally, query profiling now includes detailed EXPLAIN statistics to monitor batch pruning and false-positive rates.
The custom node ColumnarIndexScan adjusts the query plan to fetch values from the sparse minmax indexes, improving query performance on the columnstore by up to 70x. For analytical queries that leverage functions like COUNT, MIN, MAX, FIRST (limited), and LAST (limited), the sparse index is being read instead of decompressing the batch.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.50 2026/03/05 10:38:19 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.26.3
@


1.50
log
@postgresql-timescaledb: updated to 2.25.2

2.25.2

This release contains performance improvements and bug fixes since the 2.25.1
release and a fix for a security vulnerability. You can check the security
advisory for more information on the vulnerability and the platforms that are
affected. We recommend that you upgrade as soon as possible.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.49 2026/02/18 07:29:06 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.25.2
@


1.49
log
@postgresql-timescaledb: updated to 2.25.1

2.25.1 (2026-02-17)

This release contains performance improvements and bug fixes since the 2.25.0 release. We recommend that you upgrade at the next available opportunity.

Bugfixes

* Add missing handling for em_parent to sort_transform
* Clean up orphaned entries in continuous aggregate invalidaton logs
* Fix invalidation and batching issues for variable bucket continuous aggregates.
* Error "record type has no extended hash function" on some queries using a sparse bloom filter index on a column of composite type.
* Handle type coercion for metadata column equivalence members
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.48 2026/02/13 11:51:53 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.25.1
@


1.48
log
@postgresql-timescaledb: updated to 2.25.0

2.25.0

This release contains performance improvements and bug fixes since the 2.24.0 release. We recommend that you upgrade at the next available opportunity.

Highlighted features in TimescaleDB v2.25.0

This release features multiple improvements for continuous aggregates on the columnstore:

Faster refreshes: You can now utilize direct compress during materialized view refreshes, resulting in higher throughput and reduced I/O usage.
Efficiency: The enablement of delete optimizations significantly lowers system resource requirements.
Smaller transactions: Adjusted defaults for buckets_per_batch to 10 reduces transaction sizes, requiring less WAL holding time.
Faster queries: Smarter defaults for segmentby and orderby yield improved query performance and better compression ratio on the columnstore.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.47 2025/12/26 09:21:02 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.25.0
@


1.47
log
@postgresql-timescaledb: updated to 2.24.0

Highlighted features in TimescaleDB v2.24.0

Direct Compress just got smarter and faster: it now works seamlessly with hypertables generating continuous aggregates. Invalidation ranges are computed directly in-memory based on the ingested batches and written efficiently at transaction commit. This change reduces the IO footprint drastically by removing the write amplification of the invalidation logs.
Continuous aggregates now speak UUIDv7: hypertables partitioned by UUIDv7 are fully supported through an enhanced time_bucket that accepts UUIDv7 values and returns precise, timezone-aware timestamps — unlocking powerful time-series analytics on modern UUID-driven table schemas.
Lightning-fast recompression: the new recompress := true option on the convert_to_columnstore API enables pure in-memory recompression, delivering a 4–5× speed boost over the previous disk-based process.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.46 2025/08/19 07:33:33 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.24.0
@


1.46
log
@postgresql-timescaledb: updated to 2.21.3

2.21.3 (2025-08-12)

This release contains performance improvements and bug fixes since the 2.21.2 release. We recommend that you upgrade at the next available opportunity.

**Bugfixes**
* Fix MERGE behaviour with updated values
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.45 2025/08/08 09:16:27 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.21.3
d19 1
a19 1
PGSQL_VERSIONS_ACCEPTED=	17 16 15
d30 1
a30 1
CMAKE_CONFIGURE_ARGS+=		-DAPACHE_ONLY=OFF
d38 1
a38 1
CMAKE_CONFIGURE_ARGS+=		-DAPACHE_ONLY=ON
@


1.45
log
@postgresql-timescaledb: updated to 2.21.2

2.21.2 (2025-08-05)

This release contains performance improvements and bug fixes since the 2.21.1 release. We recommend that you upgrade at the next available opportunity.

**Bugfixes**
* Fix duplicate constraints in JOIN queries
* Fix chunk skipping min/max calculation
* Allow `show_chunks` to process more than 65535 chunks

2.21.1 (2025-07-22)

This release contains one bug fix since the 2.21.0 release. We recommend that you upgrade at the next available opportunity.

**Bugfixes**
* Fix generic plans for foreign key checks and prepared statements

**Thanks**
* @@CodeTherapist for reporting the issue with foreign key checks not working after several `INSERT` statements

2.21.0 (2025-07-08)

This release contains performance improvements and bug fixes since the 2.20.3 release. We recommend that you upgrade at the next available opportunity.

**Highlighted features in TimescaleDB v2.21.0**
* The attach & detach chunks feature allows manually adding or removing chunks from a hypertable with uncompressed chunks, similar to PostgreSQL’s partition management.
* Continued improvement of backfilling into the columnstore, achieving up to 2.5x speedup for constrained tables, by introducing caching logic that boosts throughput for writes to compressed chunks, bringing `INSERT` performance close to that of uncompressed chunks.
* Optimized `DELETE` operations on the columstore through batch-level deletions of non-segmentby keys in the filter condition, greatly improving performance to up to 42x faster in some cases, as well as reducing bloat, and lowering resource usage.
* The heavy lock taken in Continuous Aggregate refresh was relaxed, enabling concurrent refreshes for non-overlapping ranges and eliminating the need for complex customer workarounds.
* [tech preview] Direct Compress is an innovative TimescaleDB feature that improves high-volume data ingestion by compressing data in memory and writing it directly to disk, reducing I/O overhead, eliminating dependency on background compression jobs, and significantly boosting insert performance.

**Sunsetting of the hypercore access method**
We made the decision to deprecate hypercore access method (TAM) with the 2.21.0 release. It was an experiment, which did not show the signals we hoped for and will be sunsetted in TimescaleDB 2.22.0, scheduled for September 2025. Upgrading to 2.22.0 and higher will be blocked if TAM is still in use. Since TAM’s inception in [2.18.0](https://github.com/timescale/timescaledb/releases/tag/2.18.0), we learned that btrees were not the right architecture. The recent advancements in the columnstore—such as more performant backfilling, SkipScan, adding check constraints, and faster point queries—put the [columnstore](https://www.timescale.com/blog/hypercore-a-hybrid-row-storage-engine-for-real-time-analytics) close to or on par with TAM without the storage from the additional index. We apologize for the inconvenience this action potentially causes and are here to assist you during the migration process.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.44 2025/06/11 12:41:24 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.21.2
@


1.44
log
@postgresql-timescaledb: updated to 2.20.3

2.20.3

Bugfixes

Adjust SkipScan cost for quals needing full scan of indexed data.
Fixed dump and restore when chunk skipping is enabled.
Fix for dropped quals bug in SkipScan.
Fix for inserting into compressed data when vectorised check is not available.
Fixed the snapshot handling in background workers.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.43 2025/06/02 15:57:39 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.20.3
@


1.43
log
@postgresql-timescaledb: updated to 2.20.2

2.20.2

This release contains bug fixes since the 2.20.1 release. We recommend that you upgrade at the next available opportunity.

Bugfixes

Fix NULL compression handling for vectorized constraint checking


2.20.1

This release contains performance improvements and bug fixes since the 2.20.0 release. We recommend that you upgrade at the next available opportunity.

Features

Log only if compression ratio warnings are enabled

Bugfixes

Intermittent "could not find pathkey item to sort" error when grouping or ordering by a time_bucket of an equality join variable.
Allow setting bgw_log_level to FATAL and ERROR
Treat null equal to null for merged Continous Aggregate refresh
Restoring a database having NULL compressed data
Fix setting compress_chunk_interval on continuous aggregates
Fix gapfill crash with locf NULL values treated as missing
Disable decompression limit during continuous aggregate refresh
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.42 2025/05/19 09:11:27 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.20.2
@


1.42
log
@postgresql-timescaledb: updated to 2.20.0

2.20.0

Highlighted features in TimescaleDB v2.20.0

The columnstore now leverages bloom filters to deliver up to 6x faster point queries on columns with high cardinality values, such as UUIDs.
Major improvements to the columnstores' backfill process enable UPSERTS with strict constraints to execute up to 10x faster.
SkipScan is now supported in the columnstore, including for DISTINCT queries. This enhancement leads to dramatic query performance improvements of 2000x to 2500x, especially for selective queries.
SIMD vectorization for the bool data type is now enabled by default. This change results in a 30–45% increase in performance for analytical queries with bool clauses on the columnstore.
Continuous aggregates now include experimental support for window functions and non-immutable functions, extending the analytics use cases they can solve.
Several quality-of-life improvements have been introduced: job names for continuous aggregates are now more descriptive, you can assign custom names to them, and it is now possible to add unique constraints along with ADD COLUMN operations in the columnstore.
Improved management and optimization of chunks with the ability to split large uncompressed chunks at a specified point in time using the split_chunk function. This new function complements the existing merge_chunk function that can be used to merge two small chunks into one larger chunk.
Enhancements to the default behavior of the columnstore now provide better automatic assessments of segment by and order by columns, reducing the need for manual configuration and simplifying initial setup.

PostgreSQL 14 support removal announcement

Following the deprecation announcement for PostgreSQL 14 in TimescaleDB v2.19.0, PostgreSQL 14 is no longer supported in TimescaleDB v2.20.0. The currently supported PostgreSQL major versions are 15, 16, and 17.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.41 2025/05/06 09:44:07 wiz Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.20.0
@


1.41
log
@postgreqsql-timescaledb: SOEXT -> SHLIB_EXT
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.40 2025/04/17 04:59:38 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.19.3
d19 1
a19 1
PGSQL_VERSIONS_ACCEPTED=	17 16 15 14
@


1.40
log
@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.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.39 2025/04/08 07:33:08 adam Exp $
a18 8
.include "../../mk/bsd.prefs.mk"

.if ${SHLIB_TYPE} == "dylib"
PLIST_SUBST+=	SOEXT=dylib
.else
PLIST_SUBST+=	SOEXT=so
.endif

@


1.39
log
@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.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.38 2025/02/19 19:28:04 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.19.2
@


1.38
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.37 2025/02/11 09:31:22 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.18.2
@


1.37
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.36 2025/01/25 12:07:48 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.18.1
@


1.36
log
@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.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.35 2024/11/08 13:46:49 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.18.0
@


1.35
log
@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).
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.34 2024/08/25 06:18:31 wiz Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.17.2
@


1.34
log
@*: replace CMAKE_ARGS with CMAKE_CONFIGURE_ARGS
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.33 2024/08/07 09:40:31 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.16.1
d27 1
a27 1
PGSQL_VERSIONS_ACCEPTED=	16 15 14
@


1.33
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.32 2024/08/04 07:26:04 adam Exp $
d16 2
a17 2
CMAKE_ARGS+=	-DUSE_OPENSSL=ON
CMAKE_ARGS+=	-DREGRESS_CHECKS=OFF
d38 1
a38 1
CMAKE_ARGS+=		-DAPACHE_ONLY=OFF
d46 1
a46 1
CMAKE_ARGS+=		-DAPACHE_ONLY=ON
@


1.32
log
@postgresql-timescaledb: updated to 2.16.0

2.16.0

This release contains significant performance improvements when working with compressed data, extended join
support in continuous aggregates, and the ability to define foreign keys from regular tables towards hypertables.
We recommend that you upgrade at the next available opportunity.

In TimescaleDB v2.16.0 we:

Introduce multiple performance focused optimizations for data manipulation operations (DML) over compressed chunks.
Improved upsert performance by more than 100x in some cases and more than 1000x in some update/delete scenarios.
Add the ability to define chunk skipping indexes on non-partitioning columns of compressed hypertables
TimescaleDB v2.16.0 extends chunk exclusion to use those skipping (sparse) indexes when queries filter on the relevant columns,
and prune chunks that do not include any relevant data for calculating the query response.
Offer new options for use cases that require foreign keys defined.
You can now add foreign keys from regular tables towards hypertables. We have also removed
some really annoying locks in the reverse direction that blocked access to referenced tables
while compression was running.
Extend Continuous Aggregates to support more types of analytical queries.
More types of joins are supported, additional equality operators on join clauses, and
support for joins between multiple regular tables.
Highlighted features in this release

Improved query performance through chunk exclusion on compressed hypertables.
You can now define chunk skipping indexes on compressed chunks for any column with one of the following
integer data types: smallint, int, bigint, serial, bigserial, date, timestamp, timestamptz.

After you call enable_chunk_skipping on a column, TimescaleDB tracks the min and max values for
that column. TimescaleDB uses that information to exclude chunks for queries that filter on that
column, and would not find any data in those chunks.

Improved upsert performance on compressed hypertables.
By using index scans to verify constraints during inserts on compressed chunks, TimescaleDB speeds
up some ON CONFLICT clauses by more than 100x.

Improved performance of updates, deletes, and inserts on compressed hypertables.
By filtering data while accessing the compressed data and before decompressing, TimescaleDB has
improved performance for updates and deletes on all types of compressed chunks, as well as inserts
into compressed chunks with unique constraints.

By signaling constraint violations without decompressing, or decompressing only when matching
records are found in the case of updates, deletes and upserts, TimescaleDB v2.16.0 speeds
up those operations more than 1000x in some update/delete scenarios, and 10x for upserts.

You can add foreign keys from regular tables to hypertables, with support for all types of cascading options.
This is useful for hypertables that partition using sequential IDs, and need to reference those IDs from other tables.

Lower locking requirements during compression for hypertables with foreign keys
Advanced foreign key handling removes the need for locking referenced tables when new chunks are compressed.
DML is no longer blocked on referenced tables while compression runs on a hypertable.

Improved support for queries on Continuous Aggregates
INNER/LEFT and LATERAL joins are now supported. Plus, you can now join with multiple regular tables,
and you can have more than one equality operator on join clauses.

PostgreSQL 13 support removal announcement

Following the deprecation announcement for PostgreSQL 13 in TimescaleDB v2.13,
PostgreSQL 13 is no longer supported in TimescaleDB v2.16.

The Currently supported PostgreSQL major versions are 14, 15 and 16.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.31 2024/07/13 05:22:59 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.16.0
@


1.31
log
@postgresql-timescaledb: updated to 2.15.3

2.15.3

Bugfixes

* Fix the handling of multiple unique indexes in a compressed INSERT.
* Fix the corresponding equivalence member not found error.
* Fix the leaks in the DML functions.
* Fix the error when acquiring a tuple lock on the OSM chunks on the replica.
* Fix ORDER BY/GROUP BY expression not found in targetlist on PG16
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.30 2024/06/07 20:38:05 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.15.3
d27 1
a27 1
PGSQL_VERSIONS_ACCEPTED=	16 15 14 13
@


1.30
log
@postgresql-timescaledb: updated to 2.15.2

Release 2.15.2

Bugfixes

Fix sort pushdown for partially compressed chunks.
Fix removal of metadata function and update script.
Fix segfault in compress_chunk with a primary space partition.
Disallow hash partitioning on primary column.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.29 2024/05/29 11:11:25 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.15.2
@


1.29
log
@postgresql-timescaledb: updated to 2.15.1

2.15.1 (2024-05-28)

This release contains performance improvements and bug fixes since
the 2.15.0 release. Best practice is to upgrade at the next
available opportunity.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.28 2024/05/11 05:22:54 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.15.1
@


1.28
log
@postgresql-timescaledb: updated to 2.15.0

2.15.0

This release contains the performance improvements and bug fixes introduced since
TimescaleDB v2.14.2. Best practice is to upgrade at the next available opportunity.

Highlighted features in this release

Continuous Aggregate now supports time_bucket with origin and/or offset.
The following improvements have been introduced for hypertable compression:
Added planner support to check more kinds of WHERE conditions before decompression.
This reduces the number of rows that have to be decompressed.
You can now use minmax sparse indexes when you compress columns with btree indexes.
Make compression uses the defaults functions.
Vectorize filters in the WHERE clause contain text equality operators and LIKE expressions.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.27 2024/02/20 19:46:50 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.15.0
@


1.27
log
@postgresql-timescaledb: updated to 2.14.2

2.14.2

This release contains bug fixes since the 2.14.1 release.
We recommend that you upgrade at the next available opportunity.

Bugfixes

* Fix segfault in cagg_validate_query
* Fix refresh on empty CAgg with variable bucket
* Don't try to compress osm chunks
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.26 2024/02/14 21:54:21 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.14.2
@


1.26
log
@postgresql-timescaledb: updated to 2.14.1

2.14.1 (2024-02-14)

This release contains bug fixes since the 2.14.0 release.
We recommend that you upgrade at the next available opportunity.

**Features**
* Add views for per chunk compression settings

**Bugfixes**
* Fixes extension update of compressed hypertables with dropped columns
* Reset sequence numbers on non-rollup compression
* Disable default indexscan for compression
* Fix DecompressChunk path generation with per chunk settings
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.25 2024/02/10 11:04:53 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.14.1
@


1.25
log
@postgresql-timescaledb: updated to 2.14.0

2.14.0

This release contains performance improvements and bug fixes since the 2.13.1 release. We recommend that you upgrade at the next
available opportunity.

In addition, it includes these noteworthy features:

Ability to change compression settings on existing compressed hypertables at any time.
New compression settings take effect on any new chunks that are compressed after the change.
Reduced locking requirements during chunk recompression
Limiting tuple decompression during DML operations to avoid decompressing a lot of tuples and causing storage issues (100k limit, configurable)
Helper functions for determining compression settings
Plan-time chunk exclusion for real-time Continuous Aggregate by constify the cagg_watermark function call, leading to faster queries using real-time continuous aggregates
For this release only, you will need to restart the database before running ALTER EXTENSION

Multi-node support removal announcement
Following the deprecation announcement for Multi-node in TimescaleDB 2.13,
Multi-node is no longer supported starting with TimescaleDB 2.14.

TimescaleDB 2.13 is the last version that includes multi-node support. Learn more about it here.

If you want to migrate from multi-node TimescaleDB to single-node TimescaleDB, read the
migration documentation.

Deprecation notice: recompress_chunk procedure
TimescaleDB 2.14 is the last version that will include the recompress_chunk procedure. Its
functionality will be replaced by the compress_chunk function, which, starting on TimescaleDB 2.14,
works on both uncompressed and partially compressed chunks.
The compress_chunk function should be used going forward to fully compress all types of chunks or even recompress
old fully compressed chunks using new compression settings (through the newly introduced recompress optional parameter).

Features

* Add plan-time chunk exclusion for real-time CAggs
* Remove support for creating Continuous Aggregates with old format
* Add functions for determining compression defaults
* Remove multinode public API
* Allow SQLValueFunction pushdown into compressed scan
* Support approximate hypertable size
* Make compression settings per chunk
* Remove reindex_relation from recompression
* Fix if_not_exists behavior for CAgg policy with NULL offsets
* Remove restrictions for changing compression settings
* Limit tuple decompression during DML operations
* Change compress_chunk and decompress_chunk to idempotent version by default
* Add LWLock for OSM usage in loader
* Deprecate recompress_chunk
* Add optional recompress argument to compress_chunk

Bugfixes

* Inefficient join plans on compressed hypertables.
* Enable now() plantime constification with BETWEEN
* Fix create_hypertable referenced by fk succeeds
* Suboptimal query plans when using time_bucket with query parameters
* time_bucket_gapfill with timezones doesn't handle daylight savings
* Make extension state available through function
* Log extension state changes
* Disallow triggers on CAggs
* Reduce locking level on compressed chunk index during segmentwise recompression
* Fix if_not_exists behavior for CAgg policy with NULL offsets
* Fix pathtarget adjustment for MergeAppend paths in aggregation pushdown code
* Fix compressed chunk not found during upserts
* Fix recompression policy ignoring partially compressed chunks
* Ensure qsort comparison function is transitive
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.24 2024/01/22 09:10:14 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.14.0
@


1.24
log
@postgresql-timescaledb: updated to 2.13.1

2.13.1 (2024-01-09)

This release contains bug fixes since the 2.13.0 release.
We recommend that you upgrade at the next available opportunity.

**Bugfixes**
* Use numrows_pre_compression in approximate row count
* Use processed group clauses in PG16
* Change bgw_log_level to use PGC_SUSET
* Disable vectorized sum for expressions.
* Read CAgg watermark from materialized data
* Fix groupby pathkeys for gapfill in PG16
* Fix index matching during DML decompression
* Fix compressed chunk permission handling on PG16
* Fix lost concurrent CAgg updates
* Fix unique expression indexes on compressed chunks
* Fix use of freed path in decompression sort logic

**Thanks**
* @@MA-MacDonald for reporting an issue with gapfill in PG16
* @@aarondglover for reporting an issue with unique expression indexes on compressed chunks
* @@adriangb for reporting an issue with security barrier views on pg16

2.13.0 (2023-11-28)

This release contains performance improvements, an improved hypertable DDL API
and bug fixes since the 2.12.2 release. We recommend that you upgrade at the next
available opportunity.

In addition, it includes these noteworthy features:

* Full PostgreSQL 16 support for all existing features
* Vectorized aggregation execution for sum()
* Track chunk creation time used in retention/compression policies

**Deprecation notice: Multi-node support**
TimescaleDB 2.13 is the last version that will include multi-node support. Multi-node
support in 2.13 is available for PostgreSQL 13, 14 and 15. Learn more about it
[here](docs/MultiNodeDeprecation.md).

If you want to migrate from multi-node TimescaleDB to single-node TimescaleDB read the
[migration documentation](https://docs.timescale.com/migrate/latest/multi-node-to-timescale-service/).

**PostgreSQL 13 deprecation announcement**
We will continue supporting PostgreSQL 13 until April 2024. Sooner to that time, we will announce the specific version of TimescaleDB in which PostgreSQL 13 support will not be included going forward.

**Starting from TimescaleDB 2.13.0**
* No Amazon Machine Images (AMI) are published. If you previously used AMI, please
use another [installation method](https://docs.timescale.com/self-hosted/latest/install/)
* Continuous Aggregates are materialized only (non-realtime) by default

**Features**
* Add chunk-wise sorted paths for compressed chunks
* Simplify hypertable DDL API
* Reduce WAL activity by freezing compressed tuples immediately
* Vectorized aggregation execution for sum()
* Add metadata for chunk creation time
* Make Continous Aggregates materialized only (non-realtime) by default
* Change show_chunks/drop_chunks using chunk creation time
* Show batches/tuples decompressed during DML operations in EXPLAIN output
* Keep track of catalog version
* Use creation time in retention/compression policy
* Add SQL function cagg_validate_query

**Bugfixes**
* Add GUC for setting background worker log level
* Allow enabling compression on hypertable with unique expression index
* Check if worker registration succeeded
* Fix exception detail passing in compression_policy_execute
* Fix missing bms_del_member result assignment
* Fix negative bitmapset member not allowed in compression
* Potential data loss when compressing a table with a partial index that matches compression order.
* Add support for startup chunk exclusion with aggs
* Repair relacl on upgrade
* Fix segfault when creating a cagg using a NULL width in time bucket function
* Make timescaledb_functions.makeaclitem strict
* Fix typmod and collation for segmentby columns
* Fix tablespace with constraints
* Enable segmentwise recompression in compression policy
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.23 2023/11/03 09:15:34 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.13.1
@


1.23
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.22 2023/08/23 15:40:13 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.12.1
d19 9
a27 1
PGSQL_VERSIONS_ACCEPTED=	15 14 13
@


1.22
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.21 2023/08/02 06:38:30 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.11.2
d19 1
a19 1
PGSQL_VERSIONS_ACCEPTED=	15 14 13 12
@


1.21
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.20 2023/04/28 07:34:42 adam Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.11.1
@


1.20
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.19 2023/02/10 11:09:47 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.10.3
a15 1
USE_CMAKE=	yes
d41 1
@


1.19
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.18 2023/01/03 13:23:21 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.9.3
@


1.18
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.17 2022/10/29 15:26:55 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.9.1
@


1.17
log
@postgresql-timescaledb: update to 2.8.1

bugfixes
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.16 2022/09/04 11:25:32 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.8.1
d20 1
a20 1
PGSQL_VERSIONS_ACCEPTED=	14 13 12
@


1.16
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.15 2022/07/18 15:50:03 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.8.0
@


1.15
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.14 2022/04/12 22:02:49 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.7.0
@


1.14
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.13 2022/03/11 18:35:32 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.6.1
@


1.13
log
@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.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.12 2021/12/10 11:20:03 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.6.0
@


1.12
log
@postgresql-timescaledb: update to 2.5.1

Continuous Aggregates for Distributed Hypertables
Support for PostgreSQL 14
Experimental: Support for timezones in time_bucket_ng()
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.11 2021/10/03 18:10:21 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.5.1
@


1.11
log
@postgresql-timescaledb: update to 2.4.2

Fixes the bug that broke background workers, and some other minor things.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.10 2021/08/24 18:23:22 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.4.2
d20 1
a20 1
PGSQL_VERSIONS_ACCEPTED=	13 12
@


1.10
log
@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.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.9 2021/07/25 16:45:55 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.4.1
@


1.9
log
@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.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.8 2021/06/23 19:11:01 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.3.1
d20 1
a20 1
PGSQL_VERSIONS_ACCEPTED=	13 12 11
@


1.8
log
@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.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.7 2021/04/25 10:07:42 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.3.0
@


1.7
log
@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
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.6 2021/04/03 17:15:42 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.2.0
d12 1
a12 7
LICENSE=	apache-2.0 AND timescale-license

RESTRICTED=		No clear permission granted to distribute
NO_SRC_ON_FTP=		${RESTRICTED}
NO_SRC_ON_CDROM=	${RESTRICTED}
NO_BIN_ON_FTP=		${RESTRICTED}
NO_BIN_ON_CDROM=	${RESTRICTED}
d22 20
@


1.6
log
@postgresql-timescaledb: update to 2.1.1

This release add support for PostgreSQL major version 13.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.5 2021/02/13 15:16:04 gdt Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.1.1
a27 5
## This transform can be removed in the next version update
# https://github.com/timescale/timescaledb/commit/63a66524dd8638516d382ed0efc60c75fb17250e
# https://github.com/timescale/timescaledb/commit/2bf69fd4ca2da6a66a8d18642029df4e217a6e99
BUILDLINK_TRANSFORM+=	rm:-Werror

@


1.5
log
@databases/teimscaledb: Set RESTRICTED

timescale-license is very hard to understand, but there is clearly no
grant of permission to distribute derived works.  Permission is
perhaps granted to distribute unmodified versions, but it's
conditioned on compliance with hard to understand terms and limited
based on purpose of use.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.4 2021/02/13 11:32:35 tnn Exp $
d3 1
a3 1
DISTNAME=	timescaledb-2.0.1
d26 1
a26 1
PGSQL_VERSIONS_ACCEPTED=	12 11
@


1.4
log
@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.
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.3 2020/10/27 12:12:09 adam Exp $
d14 6
@


1.3
log
@postgresql-timescaledb: switch to USE_CMAKE; limit supported PostgreSQL versions
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.2 2020/10/10 11:20:10 mef Exp $
d3 1
a3 1
DISTNAME=	timescaledb-1.7.4
d12 1
a12 1
LICENSE=	apache-2.0
d17 1
a17 1
CMAKE_ARGS+=	-DUSE_OPENSSL=OFF
d20 6
a25 1
PGSQL_VERSIONS_ACCEPTED=	12 11 10 96
@


1.2
log
@(databases/postgresql-timescaledb) USE_TOOLS+= bash
@
text
@d1 1
a1 1
# $NetBSD: Makefile,v 1.1 2020/10/09 08:28:05 otis Exp $
a2 1
GITHUB_PROJECT=	timescaledb
d7 1
d10 1
a10 1
HOMEPAGE=	https://github.com/timescale/timescaledb/
d16 3
a18 6
USE_TOOLS+=	cmake gmake bash

CONFIGURE_ARGS+=	-DUSE_OPENSSL=0
CONFIGURE_ARGS+=	-DREGRESS_CHECKS=OFF

.include "../../mk/bsd.prefs.mk"
d20 1
a20 13
do-configure:
	cd ${WRKSRC} && \
	   ${SETENV} ${CONFIGURE_ENV} ./bootstrap ${CONFIGURE_ARGS}

do-build:
	cd ${WRKSRC}/build && \
	   ${SETENV} ${MAKE_ENV} \
	   ${MAKE} DESTDIR=${DESTDIR} PREFIX=${PREFIX}

do-install:
	cd ${WRKSRC}/build && \
	   ${SETENV} ${INSTALL_ENV} \
	   ${MAKE} DESTDIR=${DESTDIR} PREFIX=${PREFIX} install
@


1.1
log
@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
@
text
@d1 1
a1 1
# $NetBSD$
d16 1
a16 1
USE_TOOLS+=	cmake gmake
@