AliPG kernel release notes (PostgreSQL 14–18)

更新时间:
复制 MD 格式

This topic provides the AliPG kernel release notes for RDS for PostgreSQL versions 14 through 18.

Important

PostgreSQL 18

Minor version

Description

20260530

Compatible with community version 18.3.

20260330

Compatible with community version 18.3.

20260228

Compatible with community version 18.3.

  • Bug fixes

20260215

Compatible with community version 18.2.

  • Bug fixes

20260130

Compatible with community version 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 1.6.0.

  • Bug fixes

20251130

Compatible with community version 18.1.

Initial release.

PostgreSQL 17

Minor version

Description

20260530

Compatible with community version 17.9.

20260330

Compatible with community version 17.9.

20260228

Compatible with community version 17.9.

  • Bug fixes

    Fixed known issues.

20260215

Compatible with community version 17.8.

  • Bug fixes

    Fixed known issues.

20260130

Compatible with community version 17.7.

  • New features

    • Upgraded the pg_proctab extension to 0.0.13.

    • Adds support for the h3 extension, version 4.2.3.

  • Bug fixes

    Fixed known issues.

20251130

Compatible with community version 17.6.

20250830

Compatible with community version 17.6.

20250630

Compatible with community version 17.5.

20250430

Compatible with community version 17.4.

20250228

Compatible with community version 17.4.

  • New features

    Upgraded the rds_ccl extension to 1.2. This version adds support for configuring the search_path parameter when performing rate limiting based on a query_id.

  • Bug fixes

    Fixed known issues.

20241230

Compatible with community version 17.0.

20241030

Compatible with community version 17.0.

20240930

Compatible with community version 17.0.

Initial release.

PostgreSQL 16

Version

Description

20260530

Compatible with community 16.13.

20260330

Compatible with community 16.13.

  • New features

  • Bug fixes

    Fixes known issues.

20260228

Compatible with community 16.13.

  • Bug fixes

    Fixes known issues.

20260215

Compatible with community 16.12.

  • Bug fixes

    Fixes known issues.

20260130

Compatible with community 16.11.

  • New features

    None.

  • Bug fixes

    Fixes known issues.

20251130

Compatible with community 16.10.

20250830

Compatible with community 16.10.

20250630

Compatible with community 16.9.

20250430

Compatible with community 16.8.

  • New features

    None.

  • Bug fixes

    • Fixes a security vulnerability in the scheduled tasks (pg_cron) extension. You can now create this extension.

    • Fixes other known issues.

20250228

Compatible with community 16.8.

  • New features

    • Adds support for the rds_encdb extension, version 1.0.

      Important

      When you enable the column encryption feature, the rds_encdb extension is automatically installed. Manual installation of this extension is not supported. If you need to perform a manual installation, contact us.

    • The rds_ccl extension is upgraded to 1.2, which allows you to configure the search_path parameter for rate limiting based on a query_id.

  • Bug fixes

    Fixes known issues.

20241230

Compatible with community 16.4.

  • New features

  • Bug fixes

    Fixes known issues.

20241030

Compatible with community 16.4.

20240830

Compatible with community 16.4.

  • New features

    • Adds support for the age extension, version 1.5.0.

    • Adds support for the rds_duckdb extension, version 1.0, in private preview.

    • Adds support for the rds_embedding extension, version 1.0.

    • Adds support for the wal2json extension, version 2.6.

    • Adds support for the hypopg extension, version 1.4.1.

    • Adds support for the pg_bigm extension, version 1.2.

    • Adds support for 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 16.3.

  • New features

    None.

  • Bug fixes

    Fixes known issues.

20240530

Compatible with community 16.2.

  • New features

    • Adds support for 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 16.2.

20231230

Compatible with community 16.1.

  • Bug fixes

    Fixes known issues.

20231030

Compatible with community 16.0.

Initial release.

PostgreSQL 15

Version

Description

20260530

Compatible with community version 15.17.

  • New features

    None.

  • Bug fixes

    Fixes known issues.

20260330

Compatible with community version 15.17.

  • New features

  • Bug fixes

    Fixes known issues.

20260228

Compatible with community version 15.17.

  • Bug fixes

    Fixes known issues.

20260215

Compatible with community version 15.16.

  • Bug fixes

    Fixes known issues.

20260130

Compatible with community version 15.15.

  • New features

    • Adds the age extension, version 1.6.0.

  • Bug fixes

    Fixes known issues.

20251130

Compatible with community version 15.14.

20250830

Compatible with community version 15.14.

20250630

Compatible with community version 15.13.

20250430

Compatible with community version 15.12.

  • New features

    Adds the AI (rds_ai) extension, version 1.0.0.

  • Bug fixes

    • Fixes a security vulnerability in the pg_cron (scheduled tasks) extension and restores the ability to create it.

    • Fixes known issues.

20250228

Compatible with community version 15.12.

  • New features

    • Upgrades the rds_ccl extension to version 1.2, adding support for configuring the search_path parameter for query_id-based throttling.

    • Upgrades the rds_duckdb extension to version 1.3 to support automatic incremental data synchronization for columnar tables.

  • Bug fixes

    Fixes known issues.

20241230

Compatible with community version 15.8.

20241030

Compatible with community version 15.8.

20240830

Compatible with community version 15.8.

  • New features

    • Adds the age extension, version 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

    Fixes known issues.

20240730

Compatible with community version 15.7.

  • New features

    None.

  • Bug fixes

    Fixes known issues.

20240530

Compatible with community version 15.6.

  • New features

  • Bug fixes

    Fixes known issues.

20240229

Compatible with community version 15.6.

20231230

Compatible with community version 15.5.

20231030

Compatible with community version 15.4.

  • New features

    • Adds the transparent page compression (TPC) feature. This feature compresses and decompresses page data in the buffer pool in real time to reduce storage costs and improve I/O throughput.

    • The transparent data encryption feature now supports global parameters for encrypting new tables and indexes by default.

  • Bug fixes

    The Ganos extension is upgraded to 5.9, which fixes known issues.

20230830

Compatible with community version 15.4.

20230730

Compatible with community version 15.1.

  • New features

    None.

  • Bug fixes

    Fixes known issues.

20230630

Compatible with community version 15.1.

  • New features

    The pg_jieba extension now supports specifying whether to use the default dictionary during searches.

  • Bug fixes

    None.

20230530

Compatible with community version 15.1.

20230430

Compatible with community version 15.1.

20230330

Compatible with community version 15.1.

  • New features

    Adds the rds_ccl extension for SQL throttling, version 1.0.

  • Bug fixes

    • Fixes an issue where an incorrect output location prevented the collection of audit logs and slow query logs.

    • Fixes known issues.

20230228

Compatible with community version 15.1.

20221230

Compatible with community version 15.1.

20221030

Compatible with community version 15.1.

Initial release.

PostgreSQL 14

Version

Description

20260530

Compatible with community PostgreSQL 14.22.

  • New features

    • Adds support for the pg_pathman extension, version V1.5.

    • The wal2json extension now supports polar-include-unchanged-toast.

  • Bug fixes

    Fixed known issues.

20260330

Compatible with community PostgreSQL 14.22.

  • New features

  • 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

    • Adds support for 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

    Adds support for the pldebugger extension for debugging stored procedures, version 1.8.

  • Bug fixes

    Fixed known issues.

20250430

Compatible with community PostgreSQL 14.17.

  • New features

    Adds support for the AI (rds_ai) extension, version 1.0.0.

  • Bug fixes

    • Fixed a security vulnerability in the pg_cron extension. The creation of this extension is now re-enabled.

    • Fixed other known issues.

20250228

Compatible with community PostgreSQL 14.17.

  • New features

    The rds_ccl extension is upgraded to version 1.2. This version supports configuring the search_path parameter for rate limiting based on a query_id.

  • Bug fixes

    Fixed known issues.

20241230

Compatible with community PostgreSQL 14.13.

  • New features

    • The pgvector extension is upgraded to version 0.8.0.

    • The pg_hint_plan extension is 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

    • Adds support for the age extension, version 1.5.0.

    • The wal2json extension is upgraded to version 2.6.

    • The hll extension is upgraded to version 2.18.

    • The pg_repack extension is upgraded to version 1.5.0.

    • The hypopg extension is upgraded to version 1.4.1.

    • The pgvector extension is upgraded to version 0.7.4.

    • The pg_partman extension is upgraded to version 5.1.0.

    • The EncDB extension is 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

    • Adds support for the pg_proctab extension, version 0.0.10.

    • The pgvector extension is 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

    • Adds support for the Transparent Page Compression (TPC) feature, which performs real-time compression and decompression of page data in the buffer pool to reduce storage costs and improve I/O throughput.

    • Transparent Data Encryption (TDE) now supports global parameters. After you configure the global parameters, tables and indexes are encrypted by default when created.

  • Bug fixes

    The Ganos extension is upgraded to version 5.9 to fix known issues.

20230830

Compatible with community PostgreSQL 14.9.

  • New features

    • Adds support for the cache eviction feature.

    • Adds support for the postgresql_anonymizer extension, version 1.1.0.

    • The pgvector extension is upgraded to version 0.5.0. It now supports HNSW indexes, parallel index builds for IVFFlat, element-wise multiplication of vectors, the L1 distance function, and sum aggregation.

    • The Ganos extension is upgraded to version 5.8. For more information, see Spatio-temporal Engine Release Notes.

  • Bug fixes

    Fixed known issues.

20230630

Compatible with community PostgreSQL 14.6.

  • New features

    The pg_jieba extension now lets you specify whether to use the default dictionary during searches.

  • Bug fixes

    None.

20230530

Compatible with community PostgreSQL 14.6.

  • New features

  • Bug fixes

    Fixed a connection failure between the profile and server databases when using the pg_profile extension.

20230430

Compatible with community PostgreSQL 14.6.

20230330

Compatible with community PostgreSQL 14.6.

  • New features

    • Adds support for the rds_ccl extension for SQL rate limiting, version 1.0.

    • The timescaledb extension is 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.

  • New features

  • Bug fixes

    None.

20221030

Compatible with community PostgreSQL 14.5.

20220830

Compatible with community PostgreSQL 14.4.

  • New features

    • The EncDB extension is upgraded to version 1.1.1.

    • Adds support for the encdb_btree extension, version 1.0.0, to accelerate ciphertext queries on fully encrypted databases.

    • Adds support for the oss_fdw extension, version 1.1.

    • Adds support for 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 during complex queries.

20220730

Compatible with community PostgreSQL 14.4.

  • New features

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

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

      • Adds the ST_AddZ function. It accepts an array of Z-coordinates as a parameter to convert a 2D or 3DM geometry to a 3D or 4D geometry.

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

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

      • Enhances the ST_CreateRast function to support converting multiple records or an array of regular grid points into a raster object.

      • Enhances the ST_Split function to support splitting by trajectory point index and specifying a start time when splitting by time.

      • Enhances the ST_Union function to support batch execution based on memory usage to prevent OOM errors with large data volumes.

      • Adds support for raster data on HDFS file systems.

    • Adds support for the pg_jieba Chinese word segmentation extension. This extension supports custom dictionaries, dictionary switching, and displaying segmentation results based on the offset of each field.

  • Bug fixes

    Fixed a crash in the index_adviser extension that occurred when all recommended indexes already existed.

20220630

Compatible with community PostgreSQL 14.4.

20220228

Compatible with community PostgreSQL 14.1.

  • New features

    • Adds support for the sequential-uuids extension, version 1.0.2.

    • The EncDB extension is upgraded to version 1.1.9.

    • The Ganos extension is upgraded to version 4.6. For more information, see Spatio-temporal Engine Release Notes.

      • Raster data can now be accessed from user-created MinIO servers. For more information, see object storage path.

      • Adds the raster ST_PointValues function, which returns the pixel values of all bands.

    • Standard accounts can now use the LOAD command to load the index_adviser and pg_hint_plan extensions.

    • Privileged accounts can now specify the BYPASSRLS parameter when executing the CREATE ROLE command.

  • 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.