This release contains performance improvements, bug and security fixes since the 2.32.0 release. We recommend that you upgrade at the next available opportunity.
This release is compatible with the latest PostgreSQL minor releases, 18.7, 17.12 and 16.16 (announcement) and above, and is fully backward compatible with older Postgres minor versions. Previous TimescaleDB patch versions are affected by a background worker issue on these newer PostgreSQL minor releases: every job run by the scheduler fails. We strongly recommend that, before upgrading PostgreSQL, you first upgrade TimescaleDB to this version.
Bugfixes
- #10971, #11086 Keep the wait after a job crash when the scheduler reloads jobs
- #11015 Fix background jobs failing on new PostgreSQL minor releases
- #11019 Fix internal error when a job commits inside run_job
- #11028 Create chunk indexes without switching to the catalog owner
- #11029 Analyze expressions of columns added to continuous aggregates as the calling user
- #11031 Create indexes on continuous aggregates as the calling user
- #11032 Add foreign keys to chunks as the chunk owner
- #11035 Do not switch to catalog owner for constraint drops and view updates
- #11037 Only switch to catalog owner to create tables in the internal schema
- #11042 Check ownership before validating a unique index on a compressed chunk
- #11036 Do not switch to catalog owner when setting chunk replica identity
- #11094 Fix update to 2.28.0 failing with leftover materialization ranges of dropped continuous aggregates
Thanks
- @erikdarlingdata for reporting crashed jobs being delayed by job list reloads