This topic describes the feature updates for PolarDB for PostgreSQL (Compatible with Oracle), including the release notes for minor engine versions.
Execute the following statement to view the minor engine version of your PolarDB for PostgreSQL (Compatible with Oracle) cluster:
SHOW polardb_version;On February 26, 2025 (UTC+8), the minor engine version numbers for PolarDB for PostgreSQL (Compatible with Oracle) clusters will be updated to a six-digit format. For more information, see Update of the minor engine version number format for PolarDB.
2.0.14.27.0
Category | Description | References | Release date |
New features | Supports using associative arrays as function parameters and return values. | December 2024 | |
Supports the UTL_URL built-in package. | December 2024 | ||
Supports reading WAL logs from the WAL buffer for physical or logical replication. | Read WAL logs from the WAL buffer for physical or logical replication | December 2024 | |
Supports a query optimization feature that converts OR clauses to UNION ALL. | December 2024 | ||
Supports EDITIONABLE views. | None | December 2024 | |
Supports the UROWID type. | None | December 2024 | |
Supports declaring the RESULT_CACHE keyword when you create a function. | None | December 2024 | |
Optimizing performance | Enables the adaptive function whitelist by default to improve load balancing for cluster endpoints. | None | December 2024 |
Supports | None | December 2024 | |
Supports the unary operator | None | December 2024 | |
Optimizes performance in some common scenarios. | None | December 2024 | |
Bug fixes | For new clusters, preserves the precision of decimals in operations that involve INT8 and INT4 types. This does not affect existing clusters. | December 2024 | |
Fixes an issue where a global index kill operation causes incorrect index tuples. This prevents global index errors in extreme cases. | December 2024 | ||
Fixes an issue where users cannot query the SESSION_CONTEXT view due to incorrect default permissions. | December 2024 | ||
Fixes an issue where some keywords cannot be used as package variable names to improve package compatibility. | December 2024 | ||
Made | December 2024 | ||
2.0.14.26.0
Category | Description | References | Release date |
New features | Supports case-insensitive function calls. | November 2024 | |
Supports deduplication and sorting using | November 2024 | ||
Supports creating functions with the same name and the same | November 2024 | ||
Supports using package variables as the default values for function parameters. | November 2024 | ||
Performance optimization | Optimizes performance in some common scenarios. | None | November 2024 |
Bug fixes | Fixes incompatibility issues with some character sets. | November 2024 | |
Fixes a memory leak issue in the Bitmap operator. | November 2024 | ||
Fixes some stability issues. | November 2024 | ||
2.0.14.25.0
Category | Description | References | Release date |
New features | Automatically converts a UNIQUE constraint to a | None | September 2024 |
Supports the | None | September 2024 | |
Supports forward declarations for packages and the | September 2024 | ||
Supports the | None | September 2024 | |
Supports the | None | September 2024 | |
Supports deleting user-defined aggregate functions using the native | None | September 2024 | |
Supports SLRU shard management. | None | September 2024 | |
Supports | None | September 2024 | |
Adds monitoring for the FullPage Snapshot feature. | None | September 2024 | |
Supports controlling the default pushdown capability for common table expressions (CTEs). | None | September 2024 | |
Adds the | September 2024 | ||
Supports using the | September 2024 | ||
Upgrades the spatio-temporal database (GanosBase) to version 6.9. | September 2024 | ||
Performance optimization | Optimizes the performance of real-time data synchronization for In-Memory Column Indexes (IMCIs). | None | September 2024 |
Adjusts the default capacity of the private cache for GCC- and GRC-related processes. This optimizes performance in scenarios where many DDL operations exist within transactions. | September 2024 | ||
Bug fixes | Fixes an issue where a synonym used in a subquery cannot be found when you | September 2024 | |
Fixes a crash that occurs when an | September 2024 | ||
Fixes an issue to support the native | September 2024 | ||
Fixes an issue where | September 2024 | ||
Fixes an issue where the | September 2024 | ||
Fixes an issue where a stored procedure | September 2024 | ||
Fixes an issue where indexes that are not in the | September 2024 | ||
Fixes an issue where the cold data cache is not correctly rolled back when a query is canceled. | September 2024 | ||
Fixes an issue where the compression ratio is incorrectly calculated in shared storage mode. | September 2024 | ||
Fixes an issue where | September 2024 | ||
Fixes an issue where | September 2024 | ||
Fixes a memory allocation issue for | September 2024 | ||
2.0.14.24.0
Category | Description | References | Release date |
New features | PolarDB for PostgreSQL (Compatible with Oracle) supports the | August 2024 | |
Supports forward declarations for | None | August 2024 | |
The | August 2024 | ||
Supports transactional behavior in user-defined identities. | None | August 2024 | |
Supports ignoring case alternations when case-insensitivity is enabled. | None | August 2024 | |
Supports committing | None | August 2024 | |
PolarDB for PostgreSQL (Compatible with Oracle) supports resource control for multitenancy. | August 2024 | ||
Upgrades the spatio-temporal database (GanosBase) to version 6.8. | August 2024 | ||
Displays specific column names in error messages for data type mismatches. | None | August 2024 | |
Adds a feature to ignore the replay latency of read-only nodes when the primary node performs dirty page flushing. | None | August 2024 | |
Feature optimizations | Enhances the | August 2024 | |
Optimizes index creation to increase the speed by approximately 3 times. | None | August 2024 | |
Optimizes temporary tables of the | None | August 2024 | |
Increases the limit for batch pre-reading of | August 2024 | ||
Optimizes the execution efficiency of | None | August 2024 | |
Optimizes the adaptive function whitelist. | None | August 2024 | |
Bug fixes | Fixes an issue where | August 2024 | |
Fixes an issue with how the | August 2024 | ||
Fixes an issue with the property definitions of | August 2024 | ||
Fixes an issue with the display of the | August 2024 | ||
Fixes an issue where stored procedure definitions are incompletely displayed in the | August 2024 | ||
Fixes a database crash caused by unhandled syntax for partitioned tables. | August 2024 | ||
Fixes an issue with the display of default value parameters in | August 2024 | ||
Fixes a vulnerability in the spatio-temporal database (GanosBase) related to reading and writing local files. | August 2024 | ||
Fixes an issue where a residual | August 2024 | ||
Fixes an error that occurs with | August 2024 | ||
Fixes an issue with exporting polar_advisor objects using pg_dump. | August 2024 | ||
Fixes an issue of severe lock contention when the dirty page flushing process checks for future pages. | August 2024 | ||
Fixes an | August 2024 | ||
2.0.14.23.1
Category | Description | References | Release date |
New features | PolarDB for PostgreSQL (Compatible with Oracle) supports dumping data to OSS partitions based on a timeline. | Automatically store cold data of partitioned tables based on a timeline | August 2024 |
PolarDB for PostgreSQL (Compatible with Oracle) supports synonyms for package names. | August 2024 | ||
Performance optimization | Improves the replay speed of the relation size cache (RSC) on replica nodes for PolarDB for PostgreSQL (Compatible with Oracle). | August 2024 | |
Bug fixes | Fixes an issue where the pldebugger extension did not allow a | August 2024 | |
Fixes a string copy issue with | August 2024 | ||
Fixes an error that occurs when an | August 2024 | ||
Fixes an issue of permission loss caused by | August 2024 | ||
Fixes an issue where a synonym passes an incorrect object address to a trigger. | August 2024 | ||
Fixes an error that occurs when the | August 2024 | ||
Fixes an issue where the | August 2024 | ||
Fixes an exception that occurs when committing a transaction within a function. | August 2024 | ||
Fixes an incorrect error message for the | August 2024 | ||
2.0.14.22.0
Category | Description | References | Release date |
Bug fixes | Fixes a bug in REPLACE PACKAGE BODY. | July 2024 | |
Fixes an error that occurs when you execute an INSERT INTO SELECT statement on a table with a columnstore index. | July 2024 | ||
2.0.14.21.0
Category | Description | References | Release date |
New feature | PolarDB for PostgreSQL (Compatible with Oracle) supports tiered storage of hot and cold data. | June 2024 |
2.0.14.20.0
Category | Description | References | Release date |
New features | Upgrades the pgvector extension for PolarDB for PostgreSQL (Compatible with Oracle) to include usage methods for recall rate and performance. | May 2024 | |
Bug fixes | Improves the stability of the GanosBase trajectory module. | May 2024 | |
Fixes an error in creating new connections caused by a reference count overflow in the shared memory of the global plan cache. | May 2024 | ||
2.0.14.19.0
Category | Description | References | Release date |
New feature | PolarDB for PostgreSQL (Compatible with Oracle) supports automatic index recommendation with basic recommendation capabilities. | April 2024 | |
Bug fixes | Fixes a bug in polar_dump related to handling variable-length types. | April 2024 | |
Fixes a bug in the postgres_fdw extension that occurs when it references a dblink. | April 2024 | ||
2.0.14.18.0
Category | Description | References | Release date |
New features | Adds the imgsmlr extension to PolarDB for PostgreSQL (Compatible with Oracle). This extension lets you extract feature values from images such as PNG and GIF files and retrieve similar images using an index. | March 2024 | |
Adds the pg_profile extension to PolarDB for PostgreSQL (Compatible with Oracle). This extension collects statistics on resource-intensive activities in a target database for periodic collection and monitoring. | March 2024 | ||
Adds the pg_similarity extension to PolarDB for PostgreSQL (Compatible with Oracle) to support similarity query operations. | March 2024 | ||
Adds the prefix extension to PolarDB for PostgreSQL (Compatible with Oracle) to support string prefix matching. | March 2024 | ||
Bug fix | Fixes issues such as errors when PL/SQL and PL/pgSQL are used together and the failure to create the ganos_utility extension. | March 2024 | |
2.0.14.17.0
Category | Description | References | Release date |
New features | PolarDB for PostgreSQL (Compatible with Oracle) supports using any column of a partitioned table as a primary key or a foreign key reference. | February 2024 | |
PolarDB for PostgreSQL (Compatible with Oracle) supports rebuilding composite types using the | February 2024 | ||
PolarDB for PostgreSQL (Compatible with Oracle) supports Oracle-compatible views such as | February 2024 | ||
Bug fixes | Fixes bugs and performance degradation issues related to global indexes on partitioned tables. | February 2024 | |
Fixes an issue where the behavior of the decode function is inconsistent with that of Oracle. | February 2024 | ||
Fixes an error that occurs when a constructor is called if a schema is specified in the type body. | February 2024 | ||
2.0.14.16.0
Category | Description | References | Release date |
New features | PolarDB for PostgreSQL (Compatible with Oracle) supports tiered storage for hot and cold data. This feature stores data in separate tiers on cost-effective storage media, such as OSS. Transferring infrequently accessed data to OSS reduces storage costs. | January 2024 | |
PolarDB for PostgreSQL (Compatible with Oracle) supports generating original SQL statements from table modifications in logical replication. | January 2024 | ||
PolarDB for PostgreSQL (Compatible with Oracle) supports using | January 2024 | ||
PolarDB for PostgreSQL (Compatible with Oracle) supports declaring a collection type as the domain type of a record type. You can then use the domain of a record variable to perform all operations on the collection variable. | January 2024 | ||
Performance optimizations | Improves performance for concurrent access to large tables. | January 2024 | |
Improves RTO throttling. | January 2024 | ||
Bug fixes | Fixes logical replication bugs caused by statement-level transactions. | January 2024 | |