TimescaleDB 2.28

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version() "Postgres Version", installed_version "TimescaleDB Version"
from pg_available_extensions
where name = 'timescaledb';

Postgres Version
TimescaleDB Version

PostgreSQL 18.4 (Debian 18.4-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit
2.28.3

SELECT 1

-- 2.28's columnstore (hypercore) compresses chunks in place
create table reading (t timestamptz not null, v double precision);
select create_hypertable('reading', by_range('t'));
alter table reading set (timescaledb.enable_columnstore = true);

CREATE TABLE

create_hypertable

(1,t)

SELECT 1

ALTER TABLE

insert into reading
select '2026-01-01'::timestamptz + (n || ' hour')::interval, n
from generate_series(1,48) n;

INSERT 0 48

-- to_uuidv7() is also new in 2.28: time-ordered UUIDs
select uuid_version(to_uuidv7('2026-01-01'::timestamptz))   as version
     , uuid_timestamp(to_uuidv7('2026-01-01'::timestamptz)) as extracted;

version
extracted

7
2026-01-01 00:00:00+00

SELECT 1