This topic describes the feature updates in 2024 for PolarDB for PostgreSQL, including updates to minor engine versions, the console, the spatio-temporal database, and extensions.
You can execute the following statement to view the minor engine version of a PolarDB for PostgreSQL cluster:
SHOW polardb_version;The minor engine version number format for PolarDB for PostgreSQL will be updated to a six-digit format on February 26, 2025. For more information, see Change details.
14.13.27.0
Minor Engine Version
Category | Description | References | Release date |
New features | Supports reading Write-Ahead Logging (WAL) logs from the WAL buffer for physical and logical replication. | Read WAL logs from the WAL buffer for physical and logical replication | December 2024 |
Supports transforming OR clauses into UNION ALL clauses for query optimization. | December 2024 | ||
Performance optimizations | Enables the adaptive function whitelist by default to improve load balancing for cluster endpoints. | None | December 2024 |
Optimizes performance in some common scenarios. | None | December 2024 | |
Bug fixes | Fixes an issue where Global Index Kill processed incorrect index tuples, which caused global index errors in extreme cases. | December 2024 | |
Fixes a null pointer bug in pg_hint_plan when processing virtual indexes. | December 2024 | ||
14.13.26.0
Minor Engine Version
Category | Description | References | Release date |
New feature | Adds the Time Series Database (TSDB) extension to support advanced time-series computing features. | 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 in the bitmap operator. | November 2024 | ||
Fixes some stability issues. | November 2024 | ||
14.13.25.0
Minor Engine Version
Category | Description | References | Release date |
New features | Supports Segmented Least Recently Used (SLRU) shard management. | None | September 2024 |
Supports the | None | September 2024 | |
Adds monitoring for the FullPage Snapshot feature. | None | September 2024 | |
Supports control over the default pushdown capability for Common Table Expressions (CTEs). | None | September 2024 | |
Adds the | September 2024 | ||
Supports setting the session isolation level using the | None | September 2024 | |
Upgrades the spatio-temporal database (GanosBase) to version 6.9. | September 2024 | ||
Performance optimization | Adjusts the default private cache size for GCC and GRC processes. This optimizes performance for transactions that involve many Data Definition Language (DDL) operations. | September 2024 | |
Bug fixes | Fixes an issue where streaming replication did not promptly wake up the | September 2024 | |
Fixes an issue where a stored procedure | September 2024 | ||
Fixes an issue where indexes not in the | September 2024 | ||
Fixes an issue where the cold data cache did not roll back correctly when a query was canceled. | September 2024 | ||
Fixes an issue where the compression ratio was calculated incorrectly in shared storage mode. | September 2024 | ||
Fixes an issue where | September 2024 | ||
Fixes an issue where the | September 2024 | ||
Fixed an issue with | September 2024 | ||
14.12.24.0
Minor Engine Version
Category | Description | References | Release date |
New features | PolarDB for PostgreSQL supports multitenancy resource control. | 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 during dirty page flushing on the primary node. | None | August 2024 | |
Performance optimizations | Optimizes index creation, increasing the speed by approximately 3 times. | None | August 2024 |
Optimizes temporary tables of the | None | August 2024 | |
Increases the batch pre-read limit for | August 2024 | ||
Optimizes the execution efficiency of | None | August 2024 | |
Optimizes the adaptive function whitelist. | None | August 2024 | |
Bug fixes | Fixes a vulnerability related to reading and writing local files in the spatio-temporal database (GanosBase). | August 2024 | |
Fixes an issue with a residual | August 2024 | ||
Fixes an error with | August 2024 | ||
Fixes an issue where pg_dump failed to export polar_advisor objects. | August 2024 | ||
Fixes a severe lock contention issue that occurred when the dirty page flushing process identified future pages. | August 2024 | ||
Fixes an | August 2024 | ||
14.12.23.1
Minor Engine Version
Category | Description | References | Release date |
New feature | PolarDB for PostgreSQL supports archiving timeline partitions to OSS. | Automatically archive partitioned tables to cold storage by timeline | August 2024 |
Performance optimization | PolarDB for PostgreSQL improves the replay speed of the Relation Size Cache (RSC) on replica nodes. | August 2024 | |
Bug fix | Fixes an issue where the pldebugger extension did not allow a | August 2024 | |
14.11.22.0
Minor Engine Version
Category | Description | References | Release date |
Bug fix | Fixes an error that occurred when executing an INSERT INTO SELECT statement on a table with a columnstore index. | July 2024 | |
14.10.21.0
Minor Engine Version
Category | Description | References | Release date |
New feature | PolarDB for PostgreSQL supports Tiered Storage of Hot and Cold Data. | June 2024 |
14.10.20.0
Minor Engine Version
Category | Description | References | Release date |
New features | Upgrades the PolarDB for PostgreSQL pgvector extension to include methods for improving recall rate and performance. | May 2024 | |
Bug fixes | Improves the stability of the trajectory module in GanosBase. | May 2024 | |
Fixes an issue where a reference count overflow in the shared memory of the Global Plan Cache (GPC) caused connection errors. | May 2024 | ||
14.10.19.0
Minor Engine Version
Category | Description | References | Release date |
New feature | PolarDB for PostgreSQL supports automatic index recommendation, providing basic recommendation capabilities. | April 2024 | |
Bug fixes | Fixes a bug in polar_dump when handling variable-length data types. | April 2024 | |
Fixes a bug in the postgres_fdw extension when referencing dblinks. | April 2024 | ||
14.10.18.0
Minor Engine Version
Category | Description | References | Release date |
New features | PolarDB for PostgreSQL adds the imgsmlr extension. This extension extracts feature values from images, such as PNG and GIF files, and retrieves similar images using an index. | March 2024 | |
PolarDB for PostgreSQL adds the pg_profile extension. This extension collects statistics on resource-intensive activities in a database for periodic collection and monitoring. | March 2024 | ||
PolarDB for PostgreSQL adds the pg_similarity extension to support similarity queries. | March 2024 | ||
PolarDB for PostgreSQL adds the prefix extension to support string prefix matching. | March 2024 | ||
Bug fix | Fixes issues such as errors when using PL/SQL and PL/pgSQL together, and the failure to create the ganos_utility extension. | March 2024 | |
14.10.17.0
Minor Engine Version
Category | Description | References | Release date |
New feature | PolarDB for PostgreSQL supports using any column as a primary key or foreign key reference in a partitioned table. | February 2024 | |
Bug fixes | Fixes bugs and performance degradation issues related to global indexes on partitioned tables. | February 2024 | |
Fixes an error that occurred when calling a constructor function for a type body with a specified schema. | February 2024 | ||