All Products
Search
Document Center

ApsaraDB RDS:Release notes for AliPG (PostgreSQL 14-17)

Last Updated:Jun 14, 2025

This topic describes the release notes for AliPG kernel versions for RDS PostgreSQL 14 to 17.

Important

PostgreSQL 17

Version

Description

20250430

PostgreSQL 17.4 is supported.

20250228

PostgreSQL 17.4 is supported.

  • New features

    The rds_ccl extension is updated to version 1.2. The search_path parameter can be configured when you perform SQL throttling based on the specified query_id value.

  • Bug fixes

    Known issues are fixed.

20241230

PostgreSQL 17.0 is supported.

  • New features

  • Bug fixes

    Known issues are fixed.

20241030

PostgreSQL 17.0 is supported.

20240930

PostgreSQL 17.0 is supported.

This is the initial release.

  • For more information about the supported features, see Features.

  • For more information about the supported extensions, see Supported extensions.

PostgreSQL 16

Version

Description

20250430

PostgreSQL 16.8 is supported.

  • New features

    None.

  • Bug fixes

    • The security vulnerability in the pg_cron extension is fixed, and the extension is now supported for new installations.

    • Other known issues are fixed.

20250228

PostgreSQL 16.8 is supported.

  • New features

    • Version 1.0 of rds_encdb is supported.

      Important

      When you enable the column encryption feature, the system automatically installs the rds_encdb extension in the target database. Currently, manual direct installation of this extension in the target database is not supported. If you need to perform self-installation, please contact us.

    • The rds_ccl extension is updated to version 1.2. The search_path parameter can be configured when you perform SQL throttling based on the specified query_id value.

  • Bug fixes

    Known issues are fixed.

20241230

PostgreSQL 16.4 is supported.

  • New features

    • Version 1.0.0 of AI (rds_ai) is supported.

    • Version 1.6 of pgsql-http is supported.

    • Version 1.0.0 of pgsql-gzip is supported.

    • The pgvector extension is updated to version 0.8.0.

    • The pg_hint_plan extension is updated to version 1.6.1.

    • The rds_duckdb extension is updated to version 1.2 and supports the incremental synchronization of DML operations.

    • The automatic time column update feature is supported. For more information, see Automatic time column update.

  • Bug fixes

    Known issues are fixed.

20241030

PostgreSQL 16.4 is supported.

20240830

PostgreSQL 16.4 is supported.

  • New features

    • Version 1.5.0 of age is supported.

    • (Public preview) Version 1.0 of rds_duckdb is supported.

    • Version 1.0 of rds_embedding is supported.

    • Version 2.6 of wal2json is supported.

    • Version 1.4.1 of hypopg is supported.

    • Version 1.2 of pg_bigm is supported.

    • Version 0.5.4 of roaringbitmap is supported.

    • The pg_repack extension is updated to version 1.5.0.

    • The pgvector extension is updated to version 0.7.4.

    • The pg_partman extension is updated to version 5.1.0.

    • The encdb extension is updated to version 1.1.14.

  • Bug fixes

    Other known issues are fixed.

20240730

PostgreSQL 16.3 is supported.

  • New features

    None.

  • Bug fixes

    Known issues are fixed.

20240530

PostgreSQL 16.2 is supported.

  • New features

    • Version 0.0.10 of pg_proctab is supported.

    • The pgvector extension is updated to version 0.7.0.

  • Bug fixes

    Known issues are fixed.

20240229

PostgreSQL 16.2 is supported.

20231230

PostgreSQL 16.1 is supported.

  • Bug fixes

    Known issues are fixed.

20231030

PostgreSQL 16.0 is supported.

This is the initial release.

  • For more information about the supported features, see Features.

  • For more information about the supported extensions, see Supported extensions.

PostgreSQL 15

Version

Description

20250430

PostgreSQL 15.12 is supported.

  • New features

    Version 1.0.0 of AI (rds_ai) is supported.

  • Bug fixes

    • The security vulnerability in the pg_cron extension is fixed, and the extension is now supported for new installations.

    • Other known issues are fixed.

20250228

PostgreSQL 15.12 is supported.

  • New features

    • The rds_ccl extension is updated to version 1.2. The search_path parameter can be configured when you perform SQL throttling based on the specified query_id value.

    • The rds_duckdb extension is updated to version 1.3 and supports the automatic incremental synchronization of columnar table data.

  • Bug fixes

    Known issues are fixed.

20241230

PostgreSQL 15.8 is supported.

  • New features

    • The pgvector extension is updated to version 0.8.0.

    • The pg_hint_plan extension is updated to version 1.5.2.

    • The rds_duckdb extension is updated to version 1.2 and supports the incremental synchronization of DML operations.

    • The automatic time column update feature is supported. For more information, see Automatic time column update.

  • Bug fixes

    Known issues are fixed.

20241030

PostgreSQL 15.8 is supported.

20240830

PostgreSQL 15.8 is supported.

  • New features

    • Version 1.5.0 of age is supported.

    • The wal2json extension is updated to version 2.6.

    • The hll extension is updated to version 2.18.

    • The pg_repack extension is updated to version 1.5.0.

    • The hypopg extension is updated to version 1.4.1.

    • The pgvector extension is updated to version 0.7.4.

    • The pg_partman extension is updated to version 5.1.0.

    • The encdb extension is updated to version 1.1.14.

  • Bug fixes

    Other known issues are fixed.

20240730

PostgreSQL 15.7 is supported.

  • New features

    None.

  • Bug fixes

    Known issues are fixed.

20240530

PostgreSQL 15.6 is supported.

  • New features

    • Version 0.0.10 of pg_proctab is supported.

    • The pgvector extension is updated to version 0.7.0.

  • Bug fixes

    Known issues are fixed.

20240229

PostgreSQL 15.6 is supported.

20231230

PostgreSQL 15.5 is supported.

20231030

PostgreSQL 15.4 is supported.

  • New features

    • The TPC feature is supported to compress and decompress page data in a buffer pool in real time. This reduces storage costs and improves I/O throughput.

    • Global parameters can be configured for the TDE feature. After you configure global parameters, new tables and indexes are encrypted by default.

  • Bug fixes

    The GanosBase extensions are updated to version 5.9 to fix known issues.

20230830

PostgreSQL 15.4 is supported.

  • New features

    • The cache eviction feature is supported.

    • Version 1.1.0 of postgresql_anonymizer is supported.

    • The pgvector extension is updated to version 0.5.0 and supports HNSW indexes, construction of IVFFlat parallel indexes, element-by-element multiplication of vectors, L1 distance functions, and sum aggregation.

    • The GanosBase extensions are updated to version 5.8. For more information, see Release notes for GanosBase.

  • Bug fixes

    Known issues are fixed.

20230730

PostgreSQL 15.1 is supported.

  • New features

    None.

  • Bug fixes

    Known issues are fixed.

20230630

PostgreSQL 15.1 is supported.

  • New features

    A new feature that allows you to specify whether to use default dictionaries during searches is supported for the pg_jieba extension.

  • Bug fixes

    None.

20230530

PostgreSQL 15.1 is supported.

  • New features

  • Bug fixes

    The bug due to which the profile database fails to connect to the server database when the pg_profile extension is used is fixed.

20230430

PostgreSQL 15.1 is supported.

20230330

PostgreSQL 15.1 is supported.

  • New features

    Version 1.0 of the rds_ccl self-developed extension is supported. You can use this extension for SQL throttling.

  • Bug fixes

    • The bug that audit logs and slow query logs cannot be collected due to abnormal output locations is fixed.

    • Other known issues are fixed.

20230228

PostgreSQL 15.1 is supported.

20221230

PostgreSQL 15.1 is supported.

20221030

PostgreSQL 15.1 is supported.

This is the initial release.

  • For more information about the supported features, see Features.

  • For more information about the supported extensions, see Supported extensions.

PostgreSQL 14

Version

Description

20250430

PostgreSQL 14.17 is supported.

  • New features

    Version 1.0.0 of AI (rds_ai) is supported.

  • Bug fixes

    • The security vulnerability in the pg_cron extension is fixed, and the extension is now supported for new installations.

    • Other known issues are fixed.

20250228

PostgreSQL 14.17 is supported.

  • New features

    The rds_ccl extension is updated to version 1.2. The search_path parameter can be configured when you perform SQL throttling based on the specified query_id value.

  • Bug fixes

    Known issues are fixed.

20241230

PostgreSQL 14.13 is supported.

  • New features

    • The pgvector extension is updated to version 0.8.0.

    • The pg_hint_plan extension is updated to version 1.4.3.

  • Bug fixes

    Known issues are fixed.

20241030

PostgreSQL 14.13 is supported.

20240830

PostgreSQL 14.13 is supported.

  • New features

    • Version 1.5.0 of age is supported.

    • The wal2json extension is updated to version 2.6.

    • The hll extension is updated to version 2.18.

    • The pg_repack extension is updated to version 1.5.0.

    • The hypopg extension is updated to version 1.4.1.

    • The pgvector extension is updated to version 0.7.4.

    • The pg_partman extension is updated to version 5.1.0.

    • The encdb extension is updated to version 1.1.14.

  • Bug fixes

    Known issues are fixed.

20240730

PostgreSQL 14.12 is supported.

  • New features

    None.

  • Bug fixes

    Known issues are fixed.

20240530

PostgreSQL 14.11 is supported.

  • New features

    • Version 0.0.10 of pg_proctab is supported.

    • The pgvector extension is updated to version 0.7.0.

  • Bug fixes

    Known issues are fixed.

20240229

PostgreSQL 14.11 is supported.

20231230

PostgreSQL 14.10 is supported.

20231030

PostgreSQL 14.9 is supported.

  • New features

    • The TPC feature is supported to compress and decompress page data in a buffer pool in real time. This reduces storage costs and improves I/O throughput.

    • Global parameters can be configured for the TDE feature. After you configure global parameters, new tables and indexes are encrypted by default.

  • Bug fixes

    The GanosBase extensions are updated to version 5.9 to fix known issues.

20230830

PostgreSQL 14.9 is supported.

  • New features

    • The cache eviction feature is supported.

    • Version 1.1.0 of postgresql_anonymizer is supported.

    • The pgvector extension is updated to version 0.5.0 and supports HNSW indexes, construction of IVFFlat parallel indexes, element-by-element multiplication of vectors, L1 distance functions, and sum aggregation.

    • The GanosBase extensions are updated to version 5.8. For more information, see Release notes for GanosBase.

  • Bug fixes

    Known issues are fixed.

20230630

PostgreSQL 14.6 is supported.

  • New features

    A new feature that allows you to specify whether to use default dictionaries during searches is supported for the pg_jieba extension.

  • Bug fixes

    None.

20230530

PostgreSQL 14.6 is supported.

  • New features

  • Bug fixes

    The bug due to which the profile database fails to connect to the server database when the pg_profile extension is used is fixed.

20230430

PostgreSQL 14.6 is supported.

  • New features

  • Bug fixes

    The performance of the pg_jieba extension is optimized to fix the out of memory (OOM) issue when loading super-large dictionaries.

20230330

PostgreSQL 14.6 is supported.

  • New features

    • Version 1.0 of the rds_ccl self-developed extension is supported. You can use this extension for SQL throttling.

    • The timescaledb extension is updated to version 2.9.2.

  • Bug fixes

    Some known issues are fixed.

20230228

PostgreSQL 14.6 is supported.

20221230

PostgreSQL 14.6 is supported.

  • New features

  • Bug fixes

    None.

20221030

PostgreSQL 14.5 is supported.

  • New features

    • The GanosBase extensions are updated to version 5.1. For more information, see Release notes for GanosBase.

    • The TDE feature is supported to achieve table-level transparent data encryption.

    • Version 1.0 of the rds_tde_utils extension is supported.

    • Version 4.1 of the pg_profile extension is supported.

    • Version 2.2.1 of the pg_stat_kcache extension is supported.

    • Version 1.1 of the mysql_fdw extension is supported.

    • Version 1.4.7 of the pg_repack extension is supported.

    • Version 1.0 of the zhparser extension is supported.

    • Version 1.3 of the rum extension is supported.

    • Version 2.3.15 of the plv8 extension is supported.

    • Version 1.4.0 of the pg_hint_plan extension is supported.

    • Version 2.0.3 of the tds_fdw extension is supported.

  • Bug fixes

    None.

20220830

PostgreSQL 14.4 is supported.

  • New features

    • The encdb extension is updated to version 1.1.1.

    • Version 1.1 of the oss_fdw extension is supported.

    • Version 2.5.0 of the timescaledb extension is supported.

    • The memory usage of the index_adviser extension is optimized.

  • Bug fixes

    The bug due to which the index_adviser extension accesses memory out of bounds in complex queries is fixed.

20220730

PostgreSQL 14.4 is supported.

  • New features

    • The GanosBase extensions are updated to version 4.9. For more information, see Release notes for GanosBase.

      • The ST_Intersection aggregate function is added to aggregate an array of geometry objects.

      • The ST_AddZ function is added to accept z-axis values as the value of an input parameter and convert a 2D or 3DM geometry to a 3D or 4D geometry.

      • The ST_SetValue function is enhanced to set pixel values based on the spatial range of a geometry object.

      • The ST_ExportTo function is enhanced to export raster objects as COG files.

      • The ST_CreateRast function is enhanced to convert multiple raster records or arrays into raster objects.

      • The ST_Split function is enhanced to support the settings of start time when you want to split a trajectory by time. The enhanced function also supports the splitting of a trajectory by trajectory point index.

      • The ST_Union function is enhanced to support batch execution based on memory usage to prevent OOM errors caused by large data volumes.

      • Hadoop Distributed File System (HDFS)-based operations on raster data are supported.

    • The pg_jieba extension that is used to segment Chinese text is supported. The extension supports custom dictionaries and allows you to switch between dictionaries. The extension displays segmentation results based on the offset of each field.

  • Bug fixes

    The bug due to which the index_adviser extension fails to respond when all recommended indexes already exist is fixed.

20220630

PostgreSQL 14.4 is supported.

20220228

PostgreSQL 14.1 is supported.

  • New features

    • Version 1.0.2 of the sequential-uuids extension is supported.

    • The encdb extension is updated to version 1.1.9.

    • The GanosBase extensions are updated to version 4.6. For more information, see Release notes for GanosBase.

      • Raster data stored in self-managed MinIO buckets can be accessed. For more information, see Object storage paths.

      • The ST_PointValues function is added to return the pixel values of all bands.

    • Standard accounts are granted the permissions to execute the LOAD statement to load the index_adviser and pg_hint_plan extensions.

    • Privileged accounts are granted the permissions to configure the BYPASSRLS parameter in the CREATE ROLE statement.

  • Bug fixes

    The bug that causes missing parameter values in slow SQL logs is fixed.

20220130

PostgreSQL 14.1 is supported.

New features:

20211130

PostgreSQL 14.1 is supported.

This is the initial release.

  • For more information about the supported features, see Features.

  • For more information about the supported extensions, see Supported extensions.