2021
This topic describes the feature updates for PolarDB PostgreSQL Edition, including updates to the minor engine version, console, spatio-temporal database, and APIs.
You can retrieve the minor engine version number for PolarDB for PostgreSQL by running the following statement:
show polardb_version;The minor engine version number for PolarDB for PostgreSQL will change to a six-digit format on February 26, 2025 (UTC+8). For details about this change and the mapping between old and new minor engine version numbers, see PolarDB Minor Engine Version Number Format Update.
The native PostgreSQL versions supported by PolarDB PostgreSQL Edition are listed below.
PolarDB PostgreSQLVersion | Native 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 |
V1.1.19
Minor Engine Version
Category | Name | Description | References | Release Time |
New | PX supports parallel Update | Cross-node parallel execution supports parallel UPDATE statements, including those with subqueries. Set the polar_px_enable_update parameter to enable or disable this feature. The default value is false.
Set the polar_px_update_dop_num parameter to control the concurrency of parallel UPDATE. The default value is 6, and the range is 1 to 128. Set the polar_px_enable_remove_update_redundant_motion parameter to control whether to remove redundant motion operators when the number of read and write workers is the same. The default value is false.
| December 2021 | |
PX supports parallel Delete | Cross-node parallel execution supports parallel DELETE statements, including those with and without subqueries. Set the polar_px_enable_delete parameter to enable or disable this feature. The default value is false.
Set the polar_px_delete_dop_num parameter to control the concurrency of parallel DELETE. The default value is 6, and the range is 1 to 128. Set the polar_px_enable_remove_delete_redundant_motion parameter to control whether to remove redundant motion operators when the number of read and write workers is the same. The default value is false.
| December 2021 |
Spatio-Temporal Database (V4.3)
Category | Name | Description | References | Release Time |
New | ST_PixelAsPolygon function | Adds the ST_PixelAsPolygon function, which converts raster pixels into Polygon objects. | December 2021 | |
ST_PixelAsPolygons function | Adds the ST_PixelAsPolygons function, which converts raster pixels into a collection of Polygon objects. | December 2021 | ||
ST_PixelAsPoint function | Adds the ST_PixelAsPoint function, which converts raster pixels into point-based geometric objects. | December 2021 | ||
ST_PixelAsCentroid function | Adds the ST_PixelAsCentroid function, which converts raster pixels into centroid-based geometric objects. | December 2021 | ||
ST_PixelAsPoints function | Adds the ST_PixelAsPoints function, which converts raster pixels into a collection of point objects. | December 2021 | ||
ST_PixelAsCentroids function | Adds the ST_PixelAsCentroids function, which converts raster pixels into a collection of centroid objects. | December 2021 | ||
Optimization | Geometric model | Geometry is compatible with PostGIS 3.1.4 interfaces. | None | December 2021 |
ST_AsDatasetFile function | The ST_AsDatasetFile function supports outputting data in Grib2 data format. | None | December 2021 | |
Bug Fix | Fixes an issue where spatial references were incorrectly obtained during raster NetCDF import. | December 2021 | ||
Fixes an issue where incorrect equals results in multiple bounding boxes could lead to bounding box update errors. | December 2021 | |||
V1.1.17
Minor Engine Version
Category | Name | Description | References | Release Time |
New | PX supports parallel write and parallel read for Insert...Select... acceleration | Cross-node parallel execution improves upon single-write, multi-read Insert...Select... by implementing parallel write and parallel read, further enhancing the performance of parallel Insert...Select... operations. Set the polar_px_insert_dop_num parameter to control the write degree of parallelism. The default value is 6.
| October 2021 | |
PX supports acceleration for Insert...Select from tableless | Cross-node parallel execution supports acceleration for Insert...Select from tableless (tableless queries), further enhancing the performance of parallel Insert...Select... operations. Set the polar_px_enable_insert_from_tableless parameter to enable or disable tableless query acceleration. The default value is 0.
| October 2021 | ||
PX supports forced ordering for order-sensitive SQL in Insert...Select | Cross-node parallel execution ensures forced ordering of write results by setting the
| October 2021 | ||
PX blocks DDL timeout cancellation | When a DDL operation waits due to a lock conflict with a PX query, set the DDL lock wait time. If the wait times out, the PX query is forcibly interrupted, allowing the DDL to acquire the lock and complete execution first. | October 2021 | ||
Optimization | Standby parallel replay | Standby nodes accelerate replay using multiple processes, reducing latency between standby and primary nodes. | None | October 2021 |
Spatio-Temporal Database (V4.1)
Category | Name | Description | References | Release Time |
Optimization | ST_ImportFrom function | Enhances the ST_ImportFrom function by adding the capability to map OSS files to in-memory files, improving data import speed. | October 2021 | |
Gist/TrajGist indexes | GisT and TrajGisT indexes add the operator family trajgist_ops_multi for multi-bounding box index key values. | GisT indexes, TrajGisT indexes, ganos.trajectory.index_split_config | October 2021 | |
Bug Fix | Adds support for querying metadata information in vector pyramids. | October 2021 | ||
Fixes a memory leak issue when trajectory objects perform intersection checks. | October 2021 | |||
V1.1.16
Minor Engine Version
Category | Name | Description | References | Release Time |
New | PX supports AssertOp operator | PX supports runtime constraint checks for the executor. | September 2021 | |
PX supports dynamic partition pruning | PX supports dynamic partition pruning, improving performance during hash joins on partitioned tables. | September 2021 | ||
Optimization | PX supports Const expressions | Cross-node parallel execution supports Const expressions. | None | September 2021 |
Operator-level memory limits | Operator-level memory limits reduce OOM risks and improve PolarDB stability. | None | September 2021 |
Spatio-Temporal Database (V4.0)
Category | Name | Description | References | Release Time |
Optimization | Raster surface calculation functions | Enhances raster surface calculation functions to return Raster objects instead of pixel matrices. | September 2021 | |
ST_Split function | Enhances ST_Split to chunk trajectory objects into sub-trajectory arrays based on specified rules. | September 2021 | ||
Bug Fix | Fixes an issue where ST_SrEqual failed under certain conditions. | September 2021 | ||
V1.1.14
Minor Engine Version
Category | Name | Description | References | Release Time |
New | GCC9 compilation adaptation | Upgrades GCC to GCC9.2.1, supporting more compilation optimizations and improving performance. | None | July 2021 |
Spatio-Temporal Database (V3.9)
Category | Name | Description | References | Release Time |
New | ST_RemoveDriftPoints function | Adds the ST_RemoveDriftPoints function, which removes drift points from trajectories using specified rules. | July 2021 | |
ST_Split function | Adds the ST_Split function, which chunks trajectories using specified geometric objects. | July 2021 | ||
ST_ExportTo function | Adds the ST_ExportTo function, which exports trajectories to external file storage, retaining only metadata within the database. | July 2021 | ||
ST_IsExternal function | Adds the ST_IsExternal function, which checks if a trajectory is stored in an external file. | July 2021 | ||
ST_ImportFrom function | Adds the ST_ImportFrom function, which converts externally stored trajectories back into trajectories stored within the database. | July 2021 | ||
ST_StorageLocation function | Adds the ST_StorageLocation function, which returns the external storage location of a trajectory. | July 2021 | ||
ST_AKID function | Adds the ST_AKID function, which returns the AccessKeyID used for OSS interaction when reading trajectories. | July 2021 | ||
ST_SetAccessKey function | Adds the ST_SetAccessKey function, which sets the AccessKey (including AccessKeyID and AccessKeySecret, similar to username and password) used for OSS interaction when reading trajectories. | July 2021 | ||
ST_SetAKID function | Adds the ST_SetAKID function, which sets the AccessKeyID used for OSS interaction when reading trajectories. | July 2021 | ||
ST_SetAKSecret function | Adds the ST_SetAKSecret function, which sets the AccessKeySecret used for OSS interaction when reading trajectories. | July 2021 | ||
ST_SetStorageLocation function | Adds the ST_SetStorageLocation function, which sets the external file storage location when reading trajectories. | July 2021 | ||
ST_DeleteGtf function | Adds the ST_DeleteGtf function, which deletes all exported trajectory files under a specified folder. | July 2021 | ||
Bug Fix | Fixes an issue where creating vector pyramids failed when filtering by string. | July 2021 | ||
Fixes an issue where the layer list could not be displayed when connecting to QGIS. | July 2021 | |||
V1.1.13
Minor Engine Version
Category | Name | Description | References | Release Time |
New | polar_stat_sql/polar_stat_plan adds I/O statistics display |
| June 2021 | |
Cross-node parallel execution | Adds the polar_bt_write_page_buffer_size parameter, which specifies the write I/O strategy during index building. | June 2021 | ||
Cross-node parallel execution can be used for BRIN index scans, further improving query performance. | Accelerate index creation using cross-node parallel execution | June 2021 | ||
Optimization | RTO-based crash recovery time improvement | Configure the polar_crash_recovery_rto parameter to specify the desired RTO for an instance. This ensures that during a crash recovery, the database can complete crash recovery and restart within the expected RTO, returning to an available state. | None | June 2021 |
Spatio-Temporal Database (V3.8)
Category | Name | Description | References | Release Time |
New | ST_AsDatasetFile function | Adds the ST_AsDatasetFile function, which supports returning raster objects within a specified range as a binary stream in a specified file format. | June 2021 | |
ST_RasterDrivers function | Adds the ST_RasterDrivers function, which supports querying the status of all raster data drivers. | June 2021 | ||
Bug Fix | Fixes an issue where the ST_Clip function failed to reproject using a specified spatial reference. | June 2021 | ||
V1.1.12
Minor Engine Version
Category | Name | Description | References | Release Time |
New | Parallel execution | Supports cross-node parallel execution:
| May 2021 | |
Optimization | Performance monitoring | Adds the max_slot_wal_keep_size parameter, which limits the file size of replication slots to prevent WAL file accumulation. | None | May 2021 |
polar_resource_group plugin | The polar_resource_group plug-in added new parameters, including total_mem_limit_remain_size, idle_mem_limit_rate, enable_terminate_active, and policy_mem_release, enable_log, to prevent excessive memory usage from affecting database processes. | None | May 2021 | |
Increases read-only node startup speed | Increases the startup speed of read-only nodes, improving performance. | None | May 2021 | |
Primary/standby switchover | Parallel replay accelerates database service recovery after a primary/standby switchover. Typically, service can be restored within 15 seconds if the primary database becomes abnormal. | None | May 2021 |
Spatio-Temporal Database (V3.7)
Category | Name | Description | References | Release Time |
New | Spatio-temporal parallel query | Supports parallel queries for spatial indexes, improving query efficiency. | May 2021 | |
Optimization | Raster image processing | The ST_SubRaster function supports raster pixel type conversion and pixel value stretching. It supports AI recognition scenarios for converting multi-band remote sensing images to three-band images. | May 2021 | |
Bug Fix | Fixes an issue where parsing invalid histogram information in rasters could cause database crashes. | May 2021 | ||
Fixes an issue where the database might crash upon exit after performing projection transformation operations. | May 2021 | |||
Fixes an issue where raster data import might cause crashes. | May 2021 | |||
V1.1.11
Minor Engine Version
Category | Name | Description | References | Release Time |
New | idle_session_timeout parameter | Adds the idle_session_timeout parameter to control the retention period of idle sessions. Sessions exceeding the retention period are released.
| None | April 2021 |
Bug Fix | Fixes an issue with cross-database usage of the DBMS_JOB built-in package. | April 2021 | ||
Fixes an issue with the combined use of CONNECT BY and ROWNUM functions. | April 2021 | |||
Fixes an issue where CONNECT BY could not find the parent object. | April 2021 | |||
Spatio-Temporal Database (V3.6)
Category | Name | Description | References | Release Time |
New | Raster data types | Adds the ST_RPCGeoreference function to obtain Rational Polynomial Coefficients (RPC) information for raster data. | April 2021 | |
Adds the ST_SetRPCGeoreference function to set RPC information for raster data. | April 2021 | |||
Adds the ST_RPCRectify function to rectify rasters based on RPC parameters of raster images, returning the rectified raster object. | April 2021 | |||
GisT indexes | Adds the ability to create GisT indexes in parallel. | April 2021 | ||
Bug Fix | Fixes an issue where custom spatial references could not be exported using pg_dump. | April 2021 | ||
V1.1.10
Minor Engine Version
Category | Name | Description | References | Release Time |
Optimization | Performance optimization | Optimizes data file I/O read performance by caching table database block size information in shared memory. | None | March 2021 |
Spatio-Temporal Database (V3.5)
Category | Name | Description | References | Release Time |
New | Large object storage optimization | Adds the Simple storage policy to optimize large object storage. | March 2021 | |
Optimization | Raster objects | When updating a raster object with chunked data using a raster object, the system automatically deletes the chunked data of the original raster object. | None | March 2021 |
Bug Fix | Fixes an issue where the Trajectory extension could not be upgraded. | March 2021 | ||
Fixes an issue where raster objects encountered errors during Average resampling in some cases. | March 2021 | |||
Fixes an issue where query results might be incorrect if multiple trajectory points have the same timestamp in a trajectory object. | March 2021 | |||
Fixes an issue where Geos objects exited directly after conversion failure, and provides hints for the reasons behind the conversion failure. | March 2021 | |||
V1.1.9
Minor Engine Version
Category | Name | Description | References | Release Time |
New | AWR monitoring | Automatic Workload Repository (AWR) is a performance collection and analysis tool. Use the AWR tool to generate a statistical analysis report for a specific period from statistical information records, such as dynamic views of the database, to analyze database performance during that period. | None | March 2021 |
Optimization | WAL | Uses pipelining technology to optimize WAL overhead and improve overall system performance. | None | March 2021 |
Bug Fix | Fixes unused SIGHUP signals. | March 2021 | ||
Fixes an issue where the TDE feature did not declare, causing the function return value address to be truncated. | March 2021 | |||
Fixes an issue where the roaringbitmap plugin accessed invalid memory when abnormal parameters were input. | March 2021 | |||
Fixes an issue where the read-only node might not promptly provide streaming replication feedback to the primary node when log synchronization latency is high, leading to streaming replication link interruptions. | March 2021 | |||
Spatio-Temporal Database (V3.4)
Category | Name | Description | References | Release Time |
New | Large object storage optimization | To accelerate spatio-temporal data index building and improve spatial query efficiency, the storage mode of spatio-temporal objects is optimized. It supports using spatio-temporal large object feature signatures and adds the polar_enable_storage_partial parameter, which supports combined in-row and out-of-row storage for spatio-temporal objects. | March 2021 | |
Raster module supports parallel function execution | The ST_ImportFrom function supports parallel import of raster data. | March 2021 | ||
The ST_BuildPyramid function supports parallel creation of pyramids for raster data. | March 2021 | |||
Trajectory Empty | Adds the Trajectory Empty object, which supports returning null objects in scenarios where requirements are not met. | None | March 2021 | |
Bug Fix | Fixes an issue where the ST_AddZ function might return incorrect results in 16BSI scenarios. | March 2021 | ||
Fixes an issue where the Trajectory module could not be upgraded in some cases. | March 2021 | |||
Fixes an issue where some functions in the Trajectory module could not utilize indexes. | March 2021 | |||
Fixes an issue where some ND functions did not correctly handle non-overlapping time periods, returning an error instead of false. | March 2021 | |||
V1.1.8
Minor Engine Version
Category | Name | Description | References | Release Time |
Optimization | PBP | Persisted Buffer Pool (PBP) is enabled by default for the primary node. | None | January 2021 |
Bug Fix | Fixes an issue where deleting tasks for tables without primary keys in DBMS_JOB caused errors during logical replication. | January 2021 | ||
Fixes a memory leak issue in Resource Group processes when memory resources are exceeded. | January 2021 | |||
Spatio-Temporal Database (V3.3)
Category | Name | Description | References | Release Time |
New | ST_JaccardSimilarity function | Adds the ST_JaccardSimilarity function to calculate the similarity of trajectory objects. | January 2021 | |
ST_Transform function | Adds the ST_Transform function to transform trajectories from one spatial reference system to another. | January 2021 | ||
Optimization | Vector pyramids | When creating vector pyramids, specify the creation range. This resolves issues where spatial ranges could not be automatically calculated in some scenarios. | None | January 2021 |
Bug Fix | Fixes an issue where the Ganos data catalog was incorrectly configured in some environments. | January 2021 | ||