This topic describes the release notes for the minor engine versions, console, Ganos, and extensions of PolarDB for PostgreSQL.
You can execute one of the following statements to query the revision version of your PolarDB for PostgreSQL cluster:
select version();14.10.16.0
Minor engine version
Category | Description | References | Release date |
New | Supports tiered storage of hot data and cold data. You can use low-cost storage media such as Object Storage Service (OSS) to store cold data. You can transfer data that are not frequently accessed or updated to OSS to reduce storage costs. | January 2024 | |
You can use the pg_repack extension to deframent tablespaces. This prevents storage bloating due to frequent updates and deletes to tables. | January 2024 | ||
Supports generating original SQL statements based on modifications to tables that are performed by logical replications. | January 2024 | ||
Fixed issues | Optimizes the performance of concurrent access to large tables. | January 2024 | |
Optimizes RTO throttling. | January 2024 | ||
Logical replication issues caused by statement-level transactions are fixed. | January 2024 | ||
14.9.15.0
Minor version
Category | Description | References | Release date |
New | Supports the PartitionedTableScan operator to accelerate the generation of query plans for partitioned tables. This improves query performance and reduces memory consumption when the number of partitions is large. | December 2023 | |
Supports the Global Plan Cache (GPC) feature that allows plan cache to be shared across processes. GPC can significantly reduce memory usage and lower the risks of Out-of-Memory (OOM) issues | December 2023 | ||
Supports batch writes for the statements to create or refresh materialized views. This accelerates the creation and refreshing of materialized views. | Batch writes for the statements to create or refresh materialized views | December 2023 | |
Supports the drop flashback feature that allows you to quickly restore deleted tables and view and clear the recycle bin, which enables you to recover data. | December 2023 | ||
Supports using elastic parallel query (ePQ) or stand-alone execution based on table size or execution cost. | Specify whether to enable ePQ based on table size or execution cost | December 2023 | |
Fixed issue | Fixed stability issues such as dead RSC spin locks. Fixed incompatibility issues of some functions in the | December 2023 | |
14.9.14.0
Minor version
Category | Description | References | Release date |
New | The pg_cron extension is supported. You can execute SQL statements to create scheduled tasks and configure automatic execution for the tasks at a specified point in time or interval. | November 2023 | |
Fixed issue | The following issue is fixed: Parallel execution and Ganos are unstable. | November 2023 | |
14.9.13.0
Minor version
Category | Description | References | Release date |
New | The parallel writes and queries of Object Storage Service (OSS) foreign tables are supported by the multi-node elastic parallel query (ePQ) feature. This improves the performance of cold data archiving and cold data queries. | ePQ supports parallel writes and queries of OSS foreign tables | October 2023 |
The ZSTD compression algorithm is available for the oss_fdw extension to improve compression ratio and compression speed. | October 2023 | ||
Fixed issue | Stability issues related to auto VACUUM, storage management, and global indexes are fixed. | October 2023 | |
14.8.11.0
Minor version
Category | Description | References | Release date |
New | When an | August 2023 | |
When the data in base tables changes, the data in the materialized views can be automatically updated to ensure consistency. | August 2023 | ||
The RelCache or CatCache data can be shared among multiple processes. | August 2023 | ||
Fixed issue | The following issue is fixed: The checkpoints and global indexes are unstable. | August 2023 | |
14.8.10.0
Minor version
Category | Description | References | Release date |
New | The ePQ feature is supported for PolarDB for PostgreSQL. | July 2023 |
14.7.9.0
Minor version
Category | Description | References | Release date |
New | The PASE extension is added to retrieve high-dimensional vectors. | June 2023 |
Ganos V5.6
Category | Description | References | Release date |
New | The ST_AsMVT3D and ST_AsMVTGeom3D functions are added to support 3D vector slices of 3D geometries. | June 2023 | |
The ST_AsTableFormat function is added to obtain the definition of a trajectory to specify the column type for the ST_AsTable function. | June 2023 | ||
OSS-based glTF and glb files can be imported into databases as SFMesh objects. | June 2023 | ||
Fixed issue | The following issue is fixed: ST_Intersection incorrectly determines the intersection of two overlapping segments. | June 2023 |
14.7.8.0
Minor version
Category | Description | References | Release date |
New | The roaringbitmap extension is added to improve query performance. | May 2023 |
Ganos V5.5
Category | Description | References | Release date |
New | The ST_MosaicFrom function is enhanced to support parallel operations. | May 2023 | |
The ST_MosaicFrom function is enhanced to support mosaic operations on raster objects of different resolutions and projections. | May 2023 | ||
Fixed issue | The following issue is fixed: The system crashes if you use ST_makeTrajectory and the start time and end time to create a trajectory with only two points. | May 2023 |
14.7.7.0
Minor version
Category | Description | References | Release date |
New | Logical replication can be used to replicate data definition language (DDL) statements. | April 2023 | |
The pldebugger extension is added to debug stored procedures. | April 2023 | ||
The polar_sql_mapping extension is supported. If an incorrect SQL statement occurs in an application and cannot be modified immediately, you can use the SQL mapping feature to map the incorrect SQL statement to the correct SQL statement. | April 2023 |
Ganos V5.4
Category | Description | References | Release date |
New | The ST_ClusterDBSCAN function is added to support the density-based spatial clustering of applications with noise (DBSCAN) algorithm in a latitude and longitude coordinate. | April 2023 | |
The ST_CurveRecognize function is added to identify a curve of a trajectory and the curvature radius. | April 2023 | ||
The ST_AsGrid function is added to query degenerated grids in 2D. | April 2023 | ||
The pgRouting extension can be upgraded to 3.4.2. | April 2023 |
14.6.6.0
Minor version
Category | Description | References | Release date |
New | Cross-node parallel acceleration and batch writing for creating materialized views are supported. | ePQ supports parallel scans and batch writes for the statements to create materialized views | March 2023 |
Access control list (ACL) upgrade is supported. | March 2023 |
14.6.5.0
Minor version
Category | Description | References | Release date |
New | The | February 2023 | |
| N/A | February 2023 | |
The recovery bulk extend feature is supported. | N/A | February 2023 |
Ganos V5.3
Category | Description | References | Release date |
New | The ST_Angle function is added to return each rotation angle of a trajectory as an array. | February 2023 | |
The ST_CurvatureRadius function is added to return each curvature radius of a trajectory as an array. | February 2023 | ||
Ganos is compatible with PostGIS 3.3.2. | February 2023 | ||
Fixed issue | The following issue is fixed: The ST_AsTable function fails when | February 2023 | |
14.6.4.0
Minor version
Category | Description | References | Release date |
New | Global indexes are supported. Global indexing is an indexing technique for partitioned tables. You can create global indexes on partitioned tables by using non-partition keys. Global indexes can provide unique constraints. | January 2023 | |
The | N/A | January 2023 |