AliPG kernel minor version releases (PostgreSQL 14-18)

更新时间:
复制 MD 格式

This topic contains the AliPG kernel release notes for RDS PostgreSQL 14-18.

Important

PostgreSQL 18

Minor version

Description

20260330

Compatible with community PostgreSQL 18.3.

  • New features

    • The pgvector extension now supports the ivf-rabitq index.

    • Upgraded the pg_proctab extension to v0.0.13.

    • Now supports the pg_textsearch extension (v1.0.0).

  • Bug fixes

20260228

Compatible with community PostgreSQL 18.3.

  • Bug fixes

20260215

Compatible with community PostgreSQL 18.2.

  • Bug fixes

20260130

Compatible with community PostgreSQL 18.1.

  • New features

    • Now supports the rum extension (v1.3.15).

    • Now supports the pgroonga extension (v4.0.5).

    • Upgraded the rds_tde_utils extension to v1.1.

    • Now supports the age extension (v1.6.0).

  • Bug fixes

20251130

Compatible with community PostgreSQL 18.1.

Initial release.

PostgreSQL 17

Minor version

Description

20260330

Compatible with community PostgreSQL 17.9.

20260228

Compatible with community PostgreSQL 17.9.

  • Bug fixes

    Fixed known issues.

20260215

Compatible with community PostgreSQL 17.8.

  • Bug fixes

    Fixed known issues.

20260130

Compatible with community PostgreSQL 17.7.

  • New features

    • The pg_proctab plugin is upgraded to 0.0.13.

    • Adds support for the h3 plugin (4.2.3).

  • Bug fixes

    Fixed known issues.

20251130

Compatible with community PostgreSQL 17.6.

20250830

Compatible with community PostgreSQL 17.6.

20250630

Compatible with community PostgreSQL 17.5.

  • New features

    • Adds support for the snowflake plugin (2.2).

    • Adds support for the pldebugger plugin (1.8) for debugging stored procedures.

  • Bug fixes

    Fixed known issues.

20250430

Compatible with community PostgreSQL 17.4.

20250228

Compatible with community PostgreSQL 17.4.

  • New features

    The rds_ccl plugin is upgraded to 1.2. You can now configure the search_path parameter for query_id-based throttling.

  • Bug fixes

    Fixed known issues.

20241230

Compatible with community PostgreSQL 17.0.

20241030

Compatible with community PostgreSQL 17.0.

20240930

Compatible with community PostgreSQL 17.0.

Initial release.

PostgreSQL 16

Version

Description

20260330

Compatible with community PostgreSQL 16.13.

  • New features

  • Bug fixes

    Fixes known issues.

20260228

Compatible with community PostgreSQL 16.13.

  • Bug fixes

    Fixes known issues.

20260215

Compatible with community PostgreSQL 16.12.

  • Bug fixes

    Fixes known issues.

20260130

Compatible with community PostgreSQL 16.11.

  • New features

    None.

  • Bug fixes

    Fixes known issues.

20251130

Compatible with community PostgreSQL 16.10.

20250830

Compatible with community PostgreSQL 16.10.

20250630

Compatible with community PostgreSQL 16.9.

20250430

Compatible with community PostgreSQL 16.8.

  • New features

    None.

  • Bug fixes

    • Fixes a security vulnerability in the Scheduled Tasks (pg_cron) extension and re-enables its creation.

    • Fixes other known issues.

20250228

Compatible with community PostgreSQL 16.8.

  • New features

    • Adds the rds_encdb extension, version 1.0.

      Important

      When you enable the column encryption feature, the system installs the rds_encdb extension in the target database by default. Manually installing this extension is not currently supported. If you need to install it manually, please contact us.

    • The rds_ccl extension is upgraded to 1.2. You can now configure the search_path parameter when applying throttling based on a query_id.

  • Bug fixes

    Fixes known issues.

20241230

Compatible with community PostgreSQL 16.4.

20241030

Compatible with community PostgreSQL 16.4.

20240830

Compatible with community PostgreSQL 16.4.

  • New features

    • Adds the age extension, version 1.5.0.

    • Adds the rds_duckdb extension, version 1.0, in public preview.

    • Adds the rds_embedding extension, version 1.0.

    • Adds the wal2json extension, version 2.6.

    • Adds the hypopg extension, version 1.4.1.

    • Adds the pg_bigm extension, version 1.2.

    • Adds the roaringbitmap extension, version 0.5.4.

    • The pg_repack extension is upgraded to 1.5.0.

    • The pgvector extension is upgraded to 0.7.4.

    • The pg_partman extension is upgraded to 5.1.0.

    • The encdb extension is upgraded to 1.1.14.

  • Bug fixes

    Fixes other known issues.

20240730

Compatible with community PostgreSQL 16.3.

  • New features

    None.

  • Bug fixes

    Fixes known issues.

20240530

Compatible with community PostgreSQL 16.2.

  • New features

    • Adds the pg_proctab extension, version 0.0.10.

    • The pgvector extension is upgraded to 0.7.0.

  • Bug fixes

    Fixes known issues.

20240229

Compatible with community PostgreSQL 16.2.

20231230

Compatible with community PostgreSQL 16.1.

  • Bug fixes

    Fixes known issues.

20231030

Compatible with community PostgreSQL 16.0.

Initial release.

PostgreSQL 15

Minor version

Description

20260330

Based on community version 15.17.

  • New features

  • Bug fixes

    Resolves known issues.

20260228

Based on community version 15.17.

  • Bug fixes

    Resolves known issues.

20260215

Based on community version 15.16.

  • Bug fixes

    Resolves known issues.

20260130

Based on community version 15.15.

  • New features

    • Adds the age extension 1.6.0.

  • Bug fixes

    Resolves known issues.

20251130

Based on community version 15.14.

20250830

Based on community version 15.14.

20250630

Based on community version 15.13.

20250430

Based on community version 15.12.

  • New features

    Adds the AI (rds_ai) extension 1.0.0.

  • Bug fixes

    • Fixes a security vulnerability in the scheduled task (pg_cron) extension and re-enables its creation.

    • Resolves other known issues.

20250228

Based on community version 15.12.

  • New features

    • Upgrades the rds_ccl extension to 1.2, enabling configuration of the search_path parameter for query_id-based throttling.

    • Upgrades the rds_duckdb extension to 1.3, adding support for automatic incremental synchronization of columnar table data.

  • Bug fixes

    Resolves known issues.

20241230

Based on community version 15.8.

20241030

Based on community version 15.8.

20240830

Based on community version 15.8.

  • New features

    • Adds the age extension 1.5.0.

    • Upgrades the wal2json extension to 2.6.

    • Upgrades the hll extension to 2.18.

    • Upgrades the pg_repack extension to 1.5.0.

    • Upgrades the hypopg extension to 1.4.1.

    • Upgrades the pgvector extension to 0.7.4.

    • Upgrades the pg_partman extension to 5.1.0.

    • Upgrades the encdb extension to 1.1.14.

  • Bug fixes

    Resolves other known issues.

20240730

Based on community version 15.7.

  • New features

    None.

  • Bug fixes

    Resolves known issues.

20240530

Based on community version 15.6.

  • New features

  • Bug fixes

    Resolves known issues.

20240229

Based on community version 15.6.

20231230

Based on community version 15.5.

20231030

Based on community version 15.4.

  • New features

  • Bug fixes

    Upgrades the GanosBase extension to 5.9, which resolves known issues.

20230830

Based on community version 15.4.

  • New features

  • Bug fixes

    Resolves known issues.

20230730

Based on community version 15.1.

  • New features

    None.

  • Bug fixes

    Resolves known issues.

20230630

Based on community version 15.1.

  • New features

    The pg_jieba extension now allows you to configure the use of the default dictionary during searches.

  • Bug fixes

    None.

20230530

Based on community version 15.1.

20230430

Based on community version 15.1.

20230330

Based on community version 15.1.

  • New features

    Adds the rds_ccl extension 1.0 for SQL throttling.

  • Bug fixes

20230228

Based on community version 15.1.

20221230

Based on community version 15.1.

20221030

Based on community version 15.1.

Initial release.

PostgreSQL 14

Minor version

Description

20260330

Compatible with community PostgreSQL 14.22.

  • New features

    • The pgvector extension now supports ivf-rabitq indexes.

  • Bug fixes

    Fixed known issues.

20260228

Compatible with community PostgreSQL 14.22.

  • Bug fixes

    Fixed known issues.

20260215

Compatible with community PostgreSQL 14.21.

  • Bug fixes

    Fixed known issues.

20260130

Compatible with community PostgreSQL 14.20.

  • New features

    • Added the age extension, version 1.6.0.

  • Bug fixes

    Fixed known issues.

20251130

Compatible with community PostgreSQL 14.19.

20250830

Compatible with community PostgreSQL 14.19.

20250630

Compatible with community PostgreSQL 14.18.

  • New features

    Added the pldebugger extension for debugging stored procedures, version 1.8.

  • Bug fixes

    Fixed known issues.

20250430

Compatible with community PostgreSQL 14.17.

  • New features

    Added the AI (rds_ai) extension, version 1.0.0.

  • Bug fixes

    • Fixed a security vulnerability in the pg_cron extension and re-enabled its creation.

    • Fixed other known issues.

20250228

Compatible with community PostgreSQL 14.17.

  • New features

    The rds_ccl extension has been upgraded to version 1.2, which allows you to configure the search_path parameter when using query_id-based SQL throttling.

  • Bug fixes

    Fixed known issues.

20241230

Compatible with community PostgreSQL 14.13.

  • New features

    • The pgvector extension has been upgraded to version 0.8.0.

    • The pg_hint_plan extension has been upgraded to version 1.4.3.

  • Bug fixes

    Fixed known issues.

20241030

Compatible with community PostgreSQL 14.13.

20240830

Compatible with community PostgreSQL 14.13.

  • New features

    • Added the age extension, version 1.5.0.

    • The wal2json extension has been upgraded to version 2.6.

    • The hll extension has been upgraded to version 2.18.

    • The pg_repack extension has been upgraded to version 1.5.0.

    • The hypopg extension has been upgraded to version 1.4.1.

    • The pgvector extension has been upgraded to version 0.7.4.

    • The pg_partman extension has been upgraded to version 5.1.0.

    • The encdb extension has been upgraded to version 1.1.14.

  • Bug fixes

    Fixed known issues.

20240730

Compatible with community PostgreSQL 14.12.

  • New features

    None.

  • Bug fixes

    Fixed known issues.

20240530

Compatible with community PostgreSQL 14.11.

  • New features

    • Added the pg_proctab extension, version 0.0.10.

    • The pgvector extension has been upgraded to version 0.7.0.

  • Bug fixes

    Fixed known issues.

20240229

Compatible with community PostgreSQL 14.11.

20231230

Compatible with community PostgreSQL 14.10.

20231030

Compatible with community PostgreSQL 14.9.

  • New features

    • Added the Transparent Page Compression (TPC) feature, which compresses and decompresses page data in the buffer pool in real time. This feature reduces storage costs and improves I/O throughput.

    • TDE now supports global parameter settings, which enable you to encrypt new tables and indexes by default.

  • Bug fixes

    The Ganos extension has been upgraded to version 5.9, fixing known issues.

20230830

Compatible with community PostgreSQL 14.9.

  • New features

  • Bug fixes

    Fixed known issues.

20230630

Compatible with community PostgreSQL 14.6.

  • New features

    The pg_jieba extension now allows you to configure whether to use the default dictionary during searches.

  • Bug fixes

    None.

20230530

Compatible with community PostgreSQL 14.6.

20230430

Compatible with community PostgreSQL 14.6.

20230330

Compatible with community PostgreSQL 14.6.

  • New features

    • Added the rds_ccl extension, version 1.0, for SQL throttling.

    • The TimescaleDB extension has been upgraded to version 2.9.2.

  • Bug fixes

    Fixed known issues.

20230228

Compatible with community PostgreSQL 14.6.

20221230

Compatible with community PostgreSQL 14.6.

20221030

Compatible with community PostgreSQL 14.5.

20220830

Compatible with community PostgreSQL 14.4.

  • New features

    • The encdb extension has been upgraded to version 1.1.1.

    • Added the encdb_btree extension, version 1.0.0, to accelerate ciphertext queries in fully encrypted databases.

    • Added the oss_fdw extension, version 1.1.

    • Added the TimescaleDB extension, version 2.5.0.

    • Optimized the memory usage of the index_adviser extension.

  • Bug fixes

    Fixed an out-of-bounds memory access issue in the index_adviser extension that occurred during complex queries.

20220730

Compatible with community PostgreSQL 14.4.

  • New features

    • The Ganos extension has been upgraded to version 4.9. For more information, see Release Notes for the Spatio-temporal Engine.

      • Added the ST_Intersection aggregate function to support aggregating arrays of Geometry objects.

      • Added the ST_AddZ function. This function supports an array of Z coordinates as a parameter to convert 2D/3DM Geometry objects into 3D/4D Geometry objects.

      • Enhanced the ST_SetValue function to support setting pixel values based on the spatial range of a specified geometry object.

      • Enhanced the ST_ExportTo function to support exporting Raster objects to COG files.

      • Enhanced the ST_CreateRast function to support converting multiple records or arrays of regular grid points into raster objects.

      • Enhanced the ST_Split function to support splitting by time (with a specified start time) or by the sequence number of trajectory points.

      • Enhanced the ST_Union function to support batch execution based on memory usage, which prevents OOM errors when large volumes of data are processed.

      • Added HDFS support for raster data.

    • Added the pg_jieba Chinese word segmentation extension. It supports custom dictionaries, dictionary switching, and displaying segmentation results based on the offset of each field.

  • Bug fixes

    Fixed an issue where the index_adviser extension crashed if all recommended indexes already existed.

20220630

Compatible with community PostgreSQL 14.4.

20220228

Compatible with community PostgreSQL 14.1.

  • New features

  • Bug fixes

    Fixed an issue where parameter values were missing from slow query logs.

20220130

Compatible with community PostgreSQL 14.1.

New features

20211130

Compatible with community PostgreSQL 14.1.

Initial release.