AliPG engine version update notes (PostgreSQL 14–17) - ApsaraDB RDS

This topic describes the AliPG engine updates for ApsaraDB RDS for PostgreSQL 14–17.

Important

To use the new features, upgrade the minor engine version of your instance. For more information, see View and upgrade the minor engine version.
For the release notes of other AliPG engine versions, see AliPG minor engine version release notes (PostgreSQL 9.4–13).

PostgreSQL 17

Minor version	Description
20250830	Compatible with Community 17.6. New features Adds support for the Online DDL (rds_online_ddl) extension, version 1.0. Adds support for the fuzzy query (pg_bigm) extension, version 1.2. Bug fixes Fixes known issues.
20250630	Compatible with the Community 17.5 version. New features Adds support for the snowflake extension, version 2.2. Adds support for the stored procedure debugger (pldebugger) extension, version 1.8. Bug fixes Fixes known issues.
20250430	Compatible with Community 17.4. New features Adds support for the AI (rds_ai) (1.0.0), high-speed full-text search (RUM) (1.3), scheduled task (pg_cron) (1.6), and pg_partman (5.2.4) extensions. For more information, see List of supported extensions. Bug fixes Fixes known issues.
20250228	Compatible with Community 17.4 version. New features The rds_ccl extension is upgraded to version 1.2. When you use the query_id to perform SQL throttling, you can configure the search_path parameter. Bug fixes Fixes known issues.
20241230	Compatible with Community 17.0 version. New features Adds support for the pgsql-gzip extension, version 1.0.0. The pgvector extension is upgraded to version 0.8.0. Adds the automatic time column update feature. Bug fixes Fixes known issues.
20241030	Compatible with the community 17.0 version. New features Supports the GanosBase plugin, version 7.0. For more information, see Spatiotemporal Engine Version Release Notes. Supports the rds_duckdb (1.1), smlar (1.0), pglogical (2.4.5), mysql_fdw (2.9.2), pgaudit (17.0), pg_repack (1.5.1), pg_wait_sampling (1.1), timescaledb (2.17.0), zhparser (1.0), pg_hint_plan (1.7.0), tds_fdw (2.0.4), ip4r (2.4), pg_squeeze (1.7), hypopg (1.4.1), roaringbitmap (0.5.4), rds_embedding (1.0), sequential-uuids (1.0.2), pg_jieba (1.2.0), pg_stat_kcache (2.3.0), postgresql_anonymizer (1.1.0), pg_proctab (0.0.10), postgis (3.3.7), address_standardizer (3.3.7), address_standardizer_data_us (3.3.7), postgis_sfcgal (3.3.7), postgis_tiger_geocoder (3.3.7), postgis_topology (3.3.7), pgrouting (3.4.2), and pgvector (0.7.4) extensions. For more information, see List of supported extensions. Bug fixes Fixes known issues.
20240930	Compatible with Community 17.0 version. Initial release. For information about supported features, see Feature overview. For information about supported extensions, see List of supported extensions.

PostgreSQL 16

Minor version	Description
20250830	Compatible with Community 16.10. New features Adds support for the Online DDL (rds_online_ddl) extension, version 1.0. Bug fixes Fixes known issues.
20250630	Compatible with the Community 16.9 version. New features Adds support for the snowflake extension, version 2.2. Adds support for the stored procedure debugger (pldebugger) extension, version 1.8. Bug fixes Fixes known issues.
20250430	Compatible with Community 16.8. New features None. Bug fixes Fixed a security vulnerability in the scheduled task (pg_cron) extension and re-enabled the creation of the extension. Fixes other known issues.
20250228	Compatible with Community 16.8 version. 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 installed in the destination database by default. You cannot manually install this extension in the destination database. To install it, contact us. The rds_ccl extension is upgraded to version 1.2. When you use the query_id to perform SQL throttling, you can configure the search_path parameter. Bug fixes Fixes known issues.
20241230	Compatible with the Community 16.4 version. New features Adds support for the AI (rds_ai) extension, version 1.0.0. Adds support for the pgsql-http extension, version 1.6. Adds support for the pgsql-gzip extension, version 1.0.0. The pgvector extension is upgraded to version 0.8.0. The pg_hint_plan extension is upgraded to version 1.6.1. The rds_duckdb extension is upgraded to version 1.2 to support DML incremental synchronization. Adds the automatic time column update feature. Bug fixes Fixes known issues.
20241030	Compatible with the Community 16.4 release. New features The rds_duckdb extension is upgraded to version 1.1. The GanosBase plugin is upgraded to 6.9. For more information, see Spatio-temporal Engine Release Notes. Bug fixes Fixes known issues.
20240830	Compatible with the community 16.4 version. New features Adds support for the age extension, version 1.5.0. (Invitational preview) Adds support for the rds_duckdb extension, version 1.0. 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 version 1.5.0. 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 Fixes other known issues.
20240730	Compatible with community version 16.3. New features None. Bug fixes Fixes known issues.
20240530	Compatible with Community 16.2 version. 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 Fixes known issues.
20240229	Compatible with the Community 16.2 version. New features Adds support for the pg_squeeze extension, version 1.6. The timescaledb extension is upgraded to version 2.14.2. The pgvector extension is upgraded to version 0.6.0. The orafce extension is upgraded to version 4.9.2. The pg_stat_kcache extension is upgraded to version 2.2.3. The pg_profile extension is upgraded to version 4.4. The pg_partman extension is upgraded to version 5.0.1. GanosBase plugin is upgraded to 6.3. For more information, see Spatio-temporal Engine Release Notes. Bug fixes Fixes known issues.
20231230	Compatible with the community 16.1 version. Bug fixes Fixes known issues.
20231030	Compatible with the Community 16.0 version. Initial release. For information about supported features, see Feature overview. For information about supported extensions, see List of supported extensions.

PostgreSQL 15

Minor version	Description
20250830	Compatible with community 15.14 version. New features Adds support for the Online DDL (rds_online_ddl) extension, version 1.0. Bug fixes Fixes known issues.
20250630	Compatible with community 15.13 version. New features Adds support for the snowflake extension, version 2.2. Adds support for the stored procedure debugger (pldebugger) extension, version 1.8. Bug fixes Fixes known issues.
20250430	Compatible with community 15.12. New features Adds support for the AI (rds_ai) extension, version 1.0.0. Bug fixes Fixes a security vulnerability in the scheduled task (pg_cron) extension and re-enables the creation of this extension. Fixes other known issues.
20250228	Compatible with the Community 15.12 version. New features The rds_ccl extension is upgraded to version 1.2. When you use the query_id to perform SQL throttling, you can configure the search_path parameter. The rds_duckdb extension is upgraded to version 1.3 to support automatic incremental synchronization of data in column-oriented tables. Bug fixes Fixes known issues.
20241230	Compatible with the Community 15.8 release. New features The pgvector extension is upgraded to version 0.8.0. The pg_hint_plan extension is upgraded to version 1.5.2. The rds_duckdb extension is upgraded to version 1.2 to support DML incremental synchronization. Adds the automatic time column update feature. Bug fixes Fixes known issues.
20241030	Compatible with Community 15.8 version. New features Supports the rds_duckdb extension, version 1.1. The GanosBase plugin is upgraded to 6.9. For more information, see Spatiotemporal Engine Release Notes. Bug fixes Fixes known issues.
20240830	Compatible with the Community 15.8 release. 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 Fixes other known issues.
20240730	Compatible with Community 15.7 version. New features None. Bug fixes Fixes known issues.
20240530	Compatible with the Community 15.6 version. 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 Fixes known issues.
20240229	Compatible with the community 15.6 version. New features Adds support for the pg_squeeze extension, version 1.6. The timescaledb extension is upgraded to version 2.14.2. The pgvector extension is upgraded to version 0.6.0. The pglogical extension is upgraded to version 2.4.4. The mysql_fdw extension is upgraded to version 1.2. The orafce extension is upgraded to version 4.9.2. The pg_cron extension is upgraded to version 1.6. The pg_stat_kcache extension is upgraded to version 2.2.3. The pg_profile extension is upgraded to version 4.4. The pgl_ddl_deploy extension is upgraded to version 2.2. The pg_partman extension is upgraded to version 5.0.1. The postgis, postgis_sfcgal, postgis_tiger_geocoder, and postgis_topology extensions are upgraded to version 3.3.4. The /GanosBase plugin is upgraded to 6.3. For more information, see Spatio-temporal Engine release history. Bug fixes Fixes known issues.
20231230	Compatible with community version 15.5. New features Adds support for the rds_embedding extension, version 1.0. The GanosBase plugin is upgraded to 6.0. For more information, see Spatiotemporal Engine Release Notes. Bug fixes Fixes known issues.
20231030	Compatible with the community 15.4 version. 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. Transparent Data Encryption (TDE) supports global parameters. This lets you encrypt tables and indexes by default when you create them. Bug fixes The GanosBase plugin is upgraded to 5.9, and known issues are fixed.
20230830	Compatible with community 15.4 version. New features Adds support for the cache eviction feature. Adds the postgresql_anonymizer extension, version 1.1.0. The pgvector extension is upgraded to version 0.5.0. This version supports HNSW indexes, parallel index building for IVFFlat, element-wise multiplication of vectors, the L1 distance function, and sum aggregation. The GanosBase plugin has been upgraded to 5.8. For more information, see Spatiotemporal Engine Release Notes. Bug fixes Fixes known issues.
20230730	Compatible with Community 15.1 version. New features None. Bug fixes Fixes known issues.
20230630	Compatible with community 15.1. New features The pg_jieba extension supports setting whether to use the default dictionary during retrieval. Bug fixes None.
20230530	Compatible with the community 15.1 release. New features Adds support for the pg_partman extension, version 4.7.3. The pg_cron extension is upgraded to version 1.5. The GanosBase plugin is upgraded to 5.6. For more information, see Spatio-temporal Engine Release Notes. Bug fixes Fixes an issue where the profile database fails to connect to the server database when you use the pg_profile extension.
20230430	Compatible with the community 15.1 release. New features Adds support for ICU Collations. Adds support for the pgvector extension, version 0.4.1. The rds_ccl extension is upgraded to version 1.1. The GanosBase plugin has been upgraded to 5.5. For more information, see Spatiotemporal Engine Version Release Record. Bug fixes Fixes an issue where the DROP DATABASE command fails when you use the pg_cron and pglogical extensions.
20230330	Compatible with the Community 15.1 release. New features Adds the proprietary rds_ccl extension, version 1.0, which supports SQL throttling. Bug fixes Fixes an issue where audit logs and slow query logs cannot be collected due to an abnormal output location. Fixes other known issues.
20230228	Compatible with the Community 15.1 release. New features Adds support for the timescaledb extension, version 2.9.2. Adds support for the pg_hint_plan extension, version 1.5. Adds support for the ip4r extension, version 2.4. Adds support for the pgl_ddl_deploy extension, version 2.1. The GanosBase plugin has been upgraded to 5.4. For more information, see Spatiotemporal Engine Release Notes. The pgrouting extension is upgraded to version 3.4.2. Bug fixes None.
20221230	Compatible with community 15.1 version. New features Adds support for the pase extension, version 0.0.1. The GanosBase plugin is upgraded to 5.3. For more information, see Spatio-temporal Engine Version Release Notes. Bug fixes None.
20221030	Compatible with Community 15.1. Initial release. For information about supported features, see Feature overview. For information about supported extensions, see List of supported extensions.

PostgreSQL 14

Minor version	Description
20250830	Compatible with community 14.19 version. New features Adds support for the Online DDL (rds_online_ddl) extension, version 1.0. Bug fixes Fixes known issues.
20250630	Compatible with the community's 14.18 version. New features Adds support for the stored procedure debugger (pldebugger) extension, version 1.8. Bug fixes Fixes known issues.
20250430	Compatible with Community 14.17 version. New features Adds support for the AI (rds_ai) extension, version 1.0.0. Bug fixes Fixed a security vulnerability in the scheduled task (pg_cron) plugin and re-enabled the creation of this plugin. Fixes other known issues.
20250228	Compatible with Community 14.17 version. New features The rds_ccl extension is upgraded to version 1.2. When you use the query_id to perform SQL throttling, you can configure the search_path parameter. Bug fixes Fixes known issues.
20241230	Compatible with Community 14.13 version. 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 Fixes known issues.
20241030	Compatible with Community 14.13 version. New features Supports the rds_duckdb extension, version 1.1. The GanosBase extension is upgraded to 6.9. For more information, see the Spatio-temporal Engine Release Notes. Bug fixes Fixes known issues.
20240830	Compatible with Community 14.13 version. 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. pg_repack extension is upgraded to 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 Fixes known issues.
20240730	Compatible with community 14.12 version. New features None. Bug fixes Fixes known issues.
20240530	Compatible with Community 14.11 version. 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 Fixes known issues.
20240229	Compatible with community 14.11 version. New features Adds support for the pg_squeeze extension, version 1.6. The timescaledb extension is upgraded to version 2.14.2. The pgvector extension is upgraded to version 0.6.0. The pglogical extension is upgraded to version 2.4.4. The mysql_fdw extension is upgraded to version 1.2. The orafce extension is upgraded to version 4.9.2. The pg_cron extension is upgraded to version 1.6. The pg_stat_kcache extension is upgraded to version 2.2.3. The pg_profile extension is upgraded to version 4.4. The pgl_ddl_deploy extension is upgraded to version 2.2. The pg_partman extension is upgraded to version 5.0.1. The postgis, postgis_sfcgal, postgis_tiger_geocoder, and postgis_topology extensions are upgraded to version 3.3.4. GanosBase plugin is upgraded to 6.3. For more information, see Spatio-temporal Engine Release Notes. Bug fixes Fixes known issues.
20231230	Compatible with Community 14.10 version. New features Adds support for the rds_embedding extension, version 1.0. The GanosBase plugin is upgraded to 6.0. For more information, see Spatio-temporal Engine Version Release Notes. Bug fixes Fixes known issues.
20231030	Compatible with the community 14.9 version. 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. Transparent Data Encryption (TDE) supports global parameters. This lets you encrypt tables and indexes by default when you create them. Bug fixes The GanosBase plugin is upgraded to 5.9, fixing known issues.
20230830	Compatible with the community 14.9 version. New features Adds support for the cache eviction feature. Adds the postgresql_anonymizer extension, version 1.1.0. The pgvector extension is upgraded to version 0.5.0. This version supports HNSW indexes, parallel index building for IVFFlat, element-wise multiplication of vectors, the L1 distance function, and sum aggregation. GanosBase plugin is upgraded to 5.8. For more information, see Spatio-temporal Engine release notes. Bug fixes Fixes known issues.
20230630	Compatible with the Community 14.6 version. New features The pg_jieba extension supports setting whether to use the default dictionary during retrieval. Bug fixes None.
20230530	Compatible with Community 14.6. New features Adds support for the pg_partman extension, version 4.7.3. The pg_cron extension is upgraded to version 1.5. The GanosBase plugin has been upgraded to 5.6. For more information, see Spatiotemporal Engine Version Release Notes. Bug fixes Fixes an issue where the profile database fails to connect to the server database when you use the pg_profile extension.
20230430	Compatible with Community 14.6 version. New features Adds support for ICU Collations. Adds support for the pgvector extension, version 0.4.1. The rds_ccl extension is upgraded to version 1.1. The GanosBase plugin is upgraded to 5.5. For more information, see Spatio-temporal Engine Release Notes. Bug fixes Optimizes the performance of the pg_jieba extension. Fixes an out-of-memory (OOM) issue that occurs when you load an oversized dictionary.
20230330	Compatible with Community 14.6. New features Adds the proprietary rds_ccl extension, version 1.0, which supports SQL throttling. The timescaledb extension is upgraded to version 2.9.2. Bug fixes Fixes some known issues.
20230228	Compatible with Community 14.6 version. New features The /GanosBase plugin is upgraded to 5.4. For more information, see Spatio-temporal Engine Release Notes. Adds support for the ip4r extension, version 2.4. Adds support for the pgl_ddl_deploy extension, version 2.1. The pgrouting extension is upgraded to version 3.4.2. The pglogical extension is upgraded to version 2.4.2. Bug fixes None.
20221230	Compatible with the Community 14.6 version. New features The GanosBase plugin has been upgraded to 5.3. For more information, see the Spatio-temporal engine release notes. Adds support for the pase extension, version 0.0.1. The postgis extension is upgraded to version 3.3.2. The encdb extension is upgraded to version 1.1.12. Bug fixes None.
20221030	Compatible with community 14.5 version. New features The GanosBase plugin is upgraded to version 5.1. For more information, see Spatio-temporal Engine Version Release Notes. Adds support for setting up Transparent Data Encryption (TDE) to implement table-level transparent data encryption. Adds support for the rds_tde_utils extension, version 1.0. Adds support for the pg_profile extension, version 4.1. Adds support for the pg_stat_kcache extension, version 2.2.1. Adds support for the mysql_fdw extension, version 1.1. Adds support for the pg_repack extension, version 1.4.7. Adds support for the zhparser extension, version 1.0. Adds support for the rum extension, version 1.3. Adds support for the plv8 extension, version 2.3.15. Adds support for the pg_hint_plan extension, version 1.4.0. Adds support for the tds_fdw extension, version 2.0.3. Bug fixes None.
20220830	Compatible with community 14.4 version. New features The encdb extension is upgraded to version 1.1.1. Adds support for the oss_fdw extension, version 1.1. Adds support for the timescaledb extension, version 2.5.0. Optimizes the memory usage of the index_adviser extension. Bug fixes Fixes a memory access violation issue of the index_adviser extension that occurs during complex queries.
20220730	Compatible with the community 14.4 release. New features The GanosBase plugin is upgraded to version 4.9. For more information, see Spatio-temporal Engine Version Release Notes. Adds the ST_Intersection aggregate function to support aggregate operations on arrays of Geometry objects. Adds the ST_AddZ function. This function accepts an array of Z coordinates as a parameter to transform a Geometry 2D/3DM object into a Geometry 3D/4D object. Enhances the ST_SetValue function to support setting pixel values based on the spatial extent of a specified geometry object. Enhances the ST_ExportTo function to support exporting a Raster object to a COG file. 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. When you chunk data by time, you can specify a start time. You can also chunk data by the ordinal number of trajectory points. Enhances the ST_Union function to support batch execution based on memory usage. This prevents out-of-memory (OOM) errors caused by large data volumes. Adds support for raster data on Hadoop Distributed File System (HDFS). Adds the pg_jieba Chinese tokenization extension. This extension supports custom dictionaries, dictionary switching, and displaying tokenization results based on the offset of each field. Bug fixes Fixes an issue where the index_adviser extension crashes if all recommended indexes already exist.
20220630	Compatible with Community 14.4. New features The GanosBase plugin has been upgraded to version 4.7. For more information, see Spatio-temporal Engine Version Release Record. Enhances the ST_makeTrajectory function to support converting rows in a table into a trajectory. Adds the ST_AsTable function to support converting a trajectory into a table. Bug fixes Fixes the silent corruption of indexes caused by "CREATE INDEX CONCURRENTLY" / "REINDEX CONCURRENTLY".
20220228	Compatible with the Community 14.1 version. New features Adds support for the sequential-uuids extension, version 1.0.2. The encdb extension is upgraded to version 1.1.9. The /GanosBase plugin has been upgraded to version 4.6. For more information, see Spatiotemporal Engine Release Notes. Adds support for accessing user-created MinIO servers for raster data. For more information, see Object Storage Service paths. Adds the raster ST_PointValues function to return the pixel values of all bands. Allows standard accounts to run the LOAD command to load the index_adviser and pg_hint_plan extensions. Allows privileged accounts to configure the BYPASSRLS parameter when they run the CREATE ROLE command. Bug fixes Fixes an issue where parameter values are missing in slow SQL statement logs.
20220130	Compatible with Community 14.1 version. New features Adds support for the index_adviser extension, version 2.0. Adds support for the hypopg extension, version 1.3.1. The /GanosBase plugin has been upgraded to version 4.5. For more information, see Spatiotemporal Engine Release Notes. The encdb extension is upgraded to version 1.1.7. The pg_cron extension is upgraded to version 1.1. The roaringbitmap extension is upgraded to version 0.5.
20211130	Compatible with Community 14.1 version. Initial release. For information about supported features, see Feature overview. For information about supported extensions, see List of supported extensions.