---
- branch: MAIN
  date: Wed Aug  2 06:38:30 UTC 2023
  files:
  - new: '1.21'
    old: '1.20'
    path: pkgsrc/databases/postgresql-timescaledb/Makefile
    pathrev: pkgsrc/databases/postgresql-timescaledb/Makefile@1.21
    type: modified
  - new: '1.18'
    old: '1.17'
    path: pkgsrc/databases/postgresql-timescaledb/PLIST
    pathrev: pkgsrc/databases/postgresql-timescaledb/PLIST@1.18
    type: modified
  - new: '1.20'
    old: '1.19'
    path: pkgsrc/databases/postgresql-timescaledb/distinfo
    pathrev: pkgsrc/databases/postgresql-timescaledb/distinfo@1.20
    type: modified
  id: 20230802T063830Z.8d115d0fdedb635f1cf78891a32e47366cd5779a
  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
  module: pkgsrc
  subject: 'CVS commit: pkgsrc/databases/postgresql-timescaledb'
  unixtime: '1690958310'
  user: adam