This topic describes the release notes for the minor versions, console, Ganos, and API of PolarDB for PostgreSQL and provides links to the relevant references.
You can execute the following statement to view the minor version that is used by PolarDB for PostgreSQL:
show polardb_version;The database engine revision version numbers of PolarDB for PostgreSQL clusters have been changed to a 6-digit format starting from February 26, 2025 (UTC+8). For more information of this change, including the mapping between the old and new version numbers, see Revision version numbers of PolarDB for PostgreSQ clusters changed to a 6-digit format.
The following table describes the version mappings between PolarDB for PostgreSQL and open source PostgreSQL.
PolarDB for PostgreSQL version | Open source PostgreSQL version |
v1.1.19 | 11.9 |
v1.1.17 | 11.9 |
v1.1.16 | 11.9 |
v1.1.15 | 11.9 |
v1.1.14 | 11.9 |
v1.1.13 | 11.9 |
V1.1.12 | 11.9 |
V1.1.11 | 11.9 |
V1.1.10 | 11.9 |
V1.1.9 | 11.9 |
V1.1.8 | 11.9 |
1.1.19
Minor version
Category | Feature | Description | References | Release date |
New feature | Support for parallel update in cross-node parallel execution | Parallel update is supported in cross-node parallel execution, including UPDATE statements that contain subqueries. You can set the polar_px_enable_update parameter to enable or disable this feature. Default value: false.
You can set the polar_px_update_dop_num parameter to control the concurrency level for the parallel update feature. The default concurrency level is 6. Valid values: 1 to 128. You can set the polar_px_enable_remove_update_redundant_motion parameter to specify whether to remove excess motion operators when the number of read workers is the same as that of the write workers. Default value: false.
| December 2021 | |
Support for parallel delete in cross-node parallel execution | Parallel delete is supported in cross-node parallel execution, including DELETE statements that contain subqueries and parallel delete that does not contain subqueries. You can set the polar_px_enable_delete parameter to enable or disable this feature. Default value: false.
You can set the polar_px_delete_dop_num parameter to control the concurrency level for the parallel delete feature. The default concurrency level is 6. Valid values: 1 to 128. You can set the polar_px_enable_remove_delete_redundant_motion parameter to specify whether to remote excess motion operators when the number of read workers is the same as that of the write workers. Default value: false.
| December 2021 |
Ganos V4.3
Category | Feature | Description | References | Release date |
New feature | ST_PixelAsPolygon function | The ST_PixelAsPolygon function is supported. This function is used to return the polygon geometry that bounds the pixel for a particular row and column. | December 2021 | |
ST_PixelAsPolygons function | The ST_PixelAsPolygons function is supported. This function is used to return the polygon geometry that bounds every pixel of a raster band. | December 2021 | ||
ST_PixelAsPoint function | The ST_PixelAsPoint function is supported. This function is used to return a point geometry of the upper-left corner of the pixel. | December 2021 | ||
ST_PixelAsCentroid function | The ST_PixelAsCentroid function is supported. This function is used to return the centroid (point geometry) of the area represented by a pixel. | December 2021 | ||
ST_PixelAsPoints function | The ST_PixelAsPoints function is supported. This function is used to return a point geometry for each pixel of a raster band. | December 2021 | ||
ST_PixelAsCentroids function | The ST_PixelAsCentroids function is supported. This function is used to return the centroid (point geometry) for each pixel of a raster band. | December 2021 | ||
Optimized feature | Geometry model | Geometry is compatible with PostGIS 3.1.4. | None | December 2021 |
ST_AsDatasetFile function | The ST_AsDatasetFile function is supported. This function is used to return data in the GRIB2 format. | None | December 2021 | |
Fixed issue | The issue of obtained special reference being incorrect when NetCDF data is imported to a raster object is fixed. | December 2021 | ||
The issue that the bounding box update errors caused by incorrect equals results under multiple bounding boxes is fixed. | December 2021 | |||
1.1.17
Minor version
Category | Feature | Description | References | Release date |
New feature | Support for multiple read and multiple write to accelerate queries with INSERT INTO SELECT in cross-node parallel execution | In addition to multiple read and single write implemented by executing INSERT INTO SELECT, cross-node parallel execution also supports parallel write and parallel read to further improve the performance of INSERT INTO SELECT. You can set the polar_px_insert_dop_num parameter to control the write concurrency level. Default value: 6.
| October 2021 | |
Support for acceleration of tableless queries that use INSERT INTO SELECT in cross-node parallel execution | Cross-node parallel execution supports acceleration of tableless queries that use INSERT INTO SELECT, which further improves the performance of INSERT INTO SELECT. You can set the polar_px_enable_insert_from_tableless parameter to specify whether to enable the tableless query acceleration feature. Default value: 0.
| October 2021 | ||
Support for forced order in INSERT INTO SELECT for order-sensitive SQL queries in cross-node parallel execution | Cross-node parallel execution allows you to set
| October 2021 | ||
Interruption support for automatic interruption of cross-node parallel queries after a timeout for the continuity of conflicted DDL operations | To prevent DDL operations from undergoing sustained suspension due to lock conflicts with cross-node parallel queries, you can set the duration for which the operations have to wait. If the lockout duration ends, cross-node parallel queries are forced to interrupt and the operations continue. | October 2021 | ||
Optimized feature | Parallel playback for read-only nodes | Playback is accelerated for read-only nodes by using multithreading, which reduces the latency of synchronization between the primary node and read-only nodes. | None | October 2021 |
Ganos V4.0
Category | Feature | Description | References | Release date |
Optimized feature | ST_ImportFrom function | The ST_ImportFrom function is enhanced to allow Object Storage Service (OSS) objects to be mapped to files in memory and accelerate data import. | October 2021 | |
GiST and TrajGisT indexing | The trajgist_ops_multi operator family is supported for Generalized Search Tree (GiST) and TrajGisT indexing. You can create a GiST or TrajGisT index on multiple bounding boxes. | GiST indexing, TrajGiST indexing, and ganos.trajectory.index_split_config | October 2021 | |
Fixed issue | Vector pyramids are optimized to support queries of metadata. | October 2021 | ||
The bug that causes memory leaks when Ganos is used to evaluate whether two specified trajectories intersect is fixed. | October 2021 | |||
1.1.16
Minor version
Category | Feature | Description | References | Release date |
New feature | Support for the AssertOp operator in cross-node parallel execution | The AssertOp operator is supported by the cross-node parallel execution feature to check runtime constraints on the executor. | September 2021 | |
Dynamic partition pruning in cross-node parallel execution | Dynamic partition pruning is supported by the cross-node parallel execution feature to improve the performance of hash joins for partitioned tables. | September 2021 | ||
Optimized feature | Support for constant expressions in cross-node parallel execution | Constant expressions are supported by the cross-node parallel execution feature. | None | September 2021 |
Operator-level memory limits | Operator-level memory limits can be used to reduce out of memory (OOM) risks and improve PolarDB stability. | None | September 2021 |
Ganos V4.0
Category | Feature | Description | References | Release date |
Optimized feature | Functions that are used to compute raster surfaces | The functions that are used to compute raster surfaces are optimized. The optimized functions return raster objects instead of pixel matrices. | ST_Aspect, ST_Slope, and ST_Hillshade | September 2021 |
ST_Split function | The ST_Split function is optimized. The optimized function splits a trajectory object based on a specified rule and returns an array of sub-trajectories. | September 2021 | ||
Fixed issue | The following issue is fixed: The ST_SrEqual function fails to determine whether two spatial reference systems are the same in specific scenarios. | September 2021 | ||
1.1.14
Minor version
Category | Feature | Description | References | Release date |
New feature | Compatibility with GNU Compiler Collection (GCC) 9 | PolarDB for PostgreSQL is compatible with GCC 9.2.1. This can optimize compilation and improve performance. | None | July 2021 |
Ganos V3.9
Category | Feature | Description | References | Release date |
New feature | ST_RemoveDriftPoints function | The ST_RemoveDriftPoints function is supported. This function is used to delete drift points from a trajectory based on specified rules. | July 2021 | |
ST_Split function | The ST_Split function is supported. This function is used to split a trajectory based on a specified geometry object. | July 2021 | ||
ST_ExportTo function | The ST_ExportTo function is supported. This function is used to export a trajectory from a database to an external file for storage. Only metadata is retained in the database. | July 2021 | ||
ST_IsExternal function | The ST_IsExternal function is supported. This function is used to check whether a trajectory is stored in an external file. | July 2021 | ||
ST_ImportFrom function | The ST_ImportFrom function is supported. This function is used to import a trajectory from an external file back to a database. | July 2021 | ||
ST_StorageLocation function | The ST_StorageLocation function is supported. This function is used to return the external location of a trajectory. | July 2021 | ||
ST_AKID function | The ST_AKID function is supported. This function is used to return an AccessKey ID that is used to read a trajectory from OSS. | July 2021 | ||
ST_SetAccessKey function | The ST_SetAccessKey function is supported. This function is used to configure an AccessKey pair that is used to read a trajectory from OSS. An AccessKey pair consists of an AccessKey ID and an AccessKey secret. An AccessKey ID is similar to a logon username, and an AccessKey secret is similar to a password. | July 2021 | ||
ST_SetAKID function | The ST_SetAKID function is supported. This function is used to configure an AccessKey ID that is used to read a trajectory from OSS. | July 2021 | ||
ST_SetAKSecret function | The ST_SetAKSecret function is supported. This function is used to configure an AccessKey secret that is used to read a trajectory from OSS. | July 2021 | ||
ST_SetStorageLocation function | The ST_SetStorageLocation function is supported. This function is used to configure the external location from which a trajectory can be read. | July 2021 | ||
ST_DeleteGtf function | The ST_DeleteGtf function is supported. This function is used to delete all exported trajectory files in a specified folder. | July 2021 | ||
Fixed issue | The following issue is fixed: Data cannot be filtered by strings when you create a vector pyramid. | July 2021 | ||
The following issue is fixed: The layer list cannot be displayed when QGIS is connected. | July 2021 | |||
1.1.13
Minor version
Category | Feature | Description | References | Release date |
New feature | Display of I/O statistics in the polar_stat_sql and polar_stat_plan views |
| June 2021 | |
Cross-node parallel execution | The polar_bt_write_page_buffer_size parameter is supported. This parameter specifies the write I/O policy that is used while an index is being created. | June 2021 | ||
Cross-node parallel execution can be used to scan Block Range Indexes (BRIN indexes). This further improves query performance. | June 2021 | |||
Optimized feature | polar_crash_recovery_rto parameter | The polar_crash_recovery_rto parameter is supported. This parameter specifies an expected recovery time objective (RTO) for an instance. This ensures that databases on an instance can restart for recovery and become available within the expected RTO if the instance fails. | None | June 2021 |
Ganos V3.8
Category | Feature | Description | References | Release date |
New feature | ST_AsDatasetFile function | The ST_AsDatasetFile function is supported. This function is used to return a specified range of raster objects as a binary stream in the specified file format. | June 2021 | |
ST_RasterDrivers function | The ST_RasterDrivers function is supported. This function is used to query the status of all raster data drivers. | June 2021 | ||
Fixed issue | The following issue is fixed: A reprojection fails when you use the ST_Clip function to specify a spatial reference system for the reprojection. | June 2021 | ||
1.1.12
Minor version
Category | Feature | Description | References | Release date |
New feature | Parallel execution | Cross-node parallel execution is supported.
| May 2021 | |
Optimized feature | Performance monitoring | The max_slot_wal_keep_size parameter is supported. This parameter is used to limit the size of files that use replication slots. This can prevent Write-Ahead Logging (WAL) files from accumulating. | None | May 2021 |
polar_resource_group plug-in | Multiple parameters including total_mem_limit_remain_size, idle_mem_limit_rate, enable_terminate_active, policy_mem_release, and enable_log can be used to configure the polar_resource_group plug-in. This avoids excessive usage of memory and ensures the normal running of database processes. | None | May 2021 | |
Improved startup speed of read-only nodes | The startup of read-only nodes is sped up. This improves performance. | None | May 2021 | |
Failover | The parallel playback feature can be used to accelerate the recovery of database services after a failover. In most cases, the database services can be recovered within 15 seconds after a primary database fails. | None | May 2021 |
Ganos V3.7
Category | Feature | Description | References | Release date |
New feature | Spatio-temporal parallel query | Spatial indexes can be queried in parallel. This improves query efficiency. | May 2021 | |
Optimized feature | Raster image processing | The ST_SubRaster function can be used to convert the pixel types of raster objects and stretch the pixel values. Raster image processing can be used in AI recognition scenarios in which multi-band remote sensing images are converted to three-band images. | May 2021 | |
Fixed issue | The following issue is fixed: A database may unexpectedly exit when you perform a raster data analysis on invalid histogram information. | May 2021 | ||
The following issue is fixed: After a specified raster dataset is transformed into another projection, a failure may occur when you disconnect from your database. | May 2021 | |||
The following issue is fixed: A database may unexpectedly exit when you import raster data to the database. | May 2021 | |||
1.1.11
Minor version
Category | Feature | Description | References | Release date |
New feature | idle_session_timeout parameter | The idle_session_timeout parameter is supported. This parameter specifies the period during which sessions can remain idle before the sessions time out. Sessions are terminated after they time out.
| None | April 2021 |
Fixed issue | The following issue is fixed: The built-in DBMS_JOB package cannot be used across databases. | April 2021 | ||
The following issue is fixed: The CONNECT BY clause and the ROWNUM function cannot be used together. | April 2021 | |||
The following issue is fixed: The CONNECT BY clause cannot find parent objects. | April 2021 | |||
Ganos V3.6
Category | Feature | Description | References | Release date |
New feature | Raster data type | The ST_RPCGeoreference function is supported. This function is used to retrieve the information about rational polynomial coefficients (RPCs) of a raster object. | April 2021 | |
The ST_SetRPCGeoreference function is supported. This function is used to specify RPC parameters for a raster object. | April 2021 | |||
The ST_RPCRectify function is supported. This function is used to rectify a raster object based on the RPC parameters and return the rectified raster object. | April 2021 | |||
GiST indexing | GiST indexes can be created in parallel. | April 2021 | ||
Fixed issue | The following issue is fixed: When you use the pg_dump utility, custom spatial references cannot be exported. | April 2021 | ||
1.1.10
Minor version
Category | Feature | Description | References | Release date |
Optimized feature | Performance improvements: | The I/O performance of reading data files can be improved by caching information about table sizes into shared memory. | None | March 2021 |
Ganos V3.5
Category | Feature | Description | References | Release date |
New feature | Storage optimization for large spatio-temporal objects | The Simple storage policy is supported. This policy optimizes storage for large spatio-temporal objects. | March 2021 | |
Optimized feature | Raster object | The chunked data in a raster object can be automatically deleted when the raster object is updated by using a new raster object. | None | March 2021 |
Fixed issue | The following issue is fixed: The Ganos Trajectory extension fails to be upgraded. | March 2021 | ||
The following issue is fixed: In some cases, an error occurs when a raster object is resampled by using the average resampling method. | March 2021 | |||
The following issue is fixed: If the trajectory points for multiple timestamps are the same in a trajectory object, query results may be invalid. | March 2021 | |||
The following issue is fixed: The conversion process is terminated after a GEOS object fails to be converted. After this issue is fixed, the system also prompts the causes of the conversion failure. | March 2021 | |||
Minor version 1.1.9
Category | Feature | Description | References | Release date |
New feature | Automatic Workload Repository (AWR) for performance monitoring | AWR is supported. AWR collects and analyzes performance statistics. You can use AWR to generate an analytical report for a specified period based on statistics such as dynamic views of a database. This allows you to analyze the database performance within the specified period. | None | March 2021 |
Optimized feature | WAL | The pipeline technology is supported. This technology is used to reduce the proportion of WAL overhead. This can improve overall system performance. | None | March 2021 |
Fixed issue | Invalid SIGHUP signals are deleted. | March 2021 | ||
The following issue is fixed: The return values of functions are truncated because the functions are not declared in the Transparent Data Encryption (TDE) feature. | March 2021 | |||
The following issue is fixed: The roaringbitmap plug-in encounters an "illegal memory access" error when invalid parameters are specified. | March 2021 | |||
The following issue is fixed: If the synchronization latency is high when logs are synchronized from a primary node to read-only nodes, the read-only nodes may not immediately provide feedback on streaming replication to the primary node. As a result, the streaming replication is interrupted. | March 2021 | |||
Ganos V3.4
Category | Feature | Description | References | Release date |
New feature | Storage optimization for large spatio-temporal objects | The feature signatures of large spatio-temporal objects are used. This accelerates the process of creating indexes on spatio-temporal data, makes spatial queries more efficient, and optimizes the storage modes of spatio-temporal objects. The polar_enable_storage_partial parameter is also supported. You can specify this parameter to enable the metadata of spatio-temporal objects to be stored in-row and the entity data of spatio-temporal objects to be stored off-row. | Feature signature-based storage optimization for large spatio-temporal objects | March 2021 |
Parallel execution of functions supported by the raster module | The ST_ImportFrom function is supported. This function is used to import raster data in parallel. | March 2021 | ||
The ST_BuildPyramid function is supported. This function is used to create pyramids in parallel based on raster data. | March 2021 | |||
Trajectory Empty | The Trajectory Empty object is supported. This allows null objects to be returned if requirements are not met in some scenarios. | None | March 2021 | |
Fixed issue | The following issue is fixed: When the input parameter is a 16-bit signed integer (16BSI), the ST_AddZ function may return an invalid result. | March 2021 | ||
The following issue is fixed: In some cases, the trajectory module fails to be upgraded. | March 2021 | |||
The following issue is fixed: Some functions cannot use indexes in the trajectory module. | March 2021 | |||
The following issue is fixed: An error instead of the value false is returned by some nd functions. This issue may occur if these nd functions fail to resolve the problem that two time periods do not intersect. | March 2021 | |||
1.1.8
Minor version
Category | Feature | Description | References | Release date |
Optimized feature | PBP | By default, the persistent buffer pool for a primary node is enabled. | None | January 2021 |
Fixed issue | The following issue is fixed: When logical replication is used to synchronize DBMS_JOB tables that do not have primary keys, tasks fail to be deleted. | January 2021 | ||
The following issue is fixed: A memory leak occurs in the processes of resource groups if the memory usage exceeds the upper limit. | January 2021 | |||
Ganos V3.3
Category | Feature | Description | References | Release date |
New feature | ST_JaccardSimilarity function | The ST_JaccardSimilarity function is supported. This function is used to calculate the similarity between trajectory objects. | January 2021 | |
ST_Transform function | The ST_Transform function is supported. This function is used to transform the coordinate of a trajectory between spatial reference systems. | January 2021 | ||
Optimized feature | Vector pyramid | The spatial extent can be specified when you create a vector pyramid. This fixes the issue that the spatial extent of a vector pyramid cannot be automatically calculated in some scenarios. | None | January 2021 |
Fixed issue | The following issue is fixed: Ganos data catalogs are misconfigured in some environments. | January 2021 | ||