2020
This topic describes the product feature updates for PolarDB for PostgreSQL in 2020. Updates include minor engine versions, the console, the spatio-temporal database, and APIs.
You can run the following statement to view the minor engine version number of PolarDB for PostgreSQL:
SHOW polardb_version;On February 26, 2025 (UTC+8), PolarDB PostgreSQL Edition updated its minor engine version number format to a six-digit format. For details about this change and the mapping between minor engine version numbers before and after the update, see PolarDB Minor Engine Version Number Format Update.
The native PostgreSQL versions that correspond to PolarDB for PostgreSQL versions are listed in the following table.
PolarDB for PostgreSQL version | Native PostgreSQL version |
V1.1.7 | 11.9 |
V1.1.6 | 11.9 |
V1.1.5 | 11.8.15 |
V1.1.4 | 11.5.12 |
V1.1.3 | 11.5.12 |
V1.1.2 | 11.2 |
V1.1.1 | 11.2c |
V1.1.0 | 11.2 |
V1.1.7
Minor engine version
Category | Name | Description | References | Release date |
New feature | Compatibility | Compatible with PostgreSQL 11.9.20. | None | December 2020 |
Improvement | Maximum connections | Adjusted the maximum number of connections supported by some compute node specifications. | December 2020 |
Spatio-temporal database (V3.2)
Category | Name | Description | References | Release date |
Add | ST_AsPNG | Added the feature that allows vector pyramids to return images in a stream-based format. This feature is used for fast graphical display of vector data. | December 2020 | |
Raster data | Added the JPEG2000 compression algorithm for the raster data type. This algorithm supports compressed storage of 16 bit raster data. | None | December 2020 | |
Improvement | st_dwithin | Optimized st_dwithin distance queries to improve query performance. | None | December 2020 |
Bug fix | Fixed an issue where time intersections for trajectory data types were incorrect. | December 2020 | ||
Fixed a bug in the Ganos in-memory topology index. | December 2020 | |||
V1.1.6
Minor engine version
Category | Name | Description | References | Release date |
New feature | Compatibility | Compatible with PostgreSQL 11.9. | None | November 2020 |
Primary/standby switchover | The OnlinePromote feature is enabled by default to reduce the time required for high-availability (HA) switchovers and improve cluster availability. | November 2020 | ||
Bug fix | Fixed an issue where node restarts could cause stuttering in some scenarios. | November 2020 | ||
Fixed an issue where memory overflow caused instance crashes in some scenarios. | November 2020 | |||
Fixed an issue where read-only nodes crashed in some scenarios. | November 2020 | |||
V3.1
Spatio-temporal database (V3.1)
Category | Name | Description | References | Release date |
Add | Trajectory data type | Added GiST index support for trajectory types. Six operator families for different dimensions are provided to meet various analysis requirements. | None | October 2020 |
Added the BoxND spatio-temporal bounding box type. This type can be used to represent spatio-temporal ranges and store trajectories. | None | October 2020 | ||
Added intersection (&&), contains (@>), and contained by (<@) operators for different dimensions. | None | October 2020 | ||
Added four types of trajectory processing functions: ST_ndIntersects, ST_ndDWithin, ST_ndContains, and ST_ndWithin. | October 2020 | |||
Provided a statistics collection feature for trajectory types and a feature to estimate scan costs based on statistics. | None | October 2020 | ||
Provided a new indexing method, TrajGist, for better index selection. | None | October 2020 | ||
ganos_update function | Added the ganos_update function. Run the | None | October 2020 | |
Improvement | Spatio-temporal range query | Optimized spatio-temporal range queries. Optimized two-stage queries for GiST indexes to improve query performance. | None | October 2020 |
Vector pyramid feature | Supports source data with any spatial reference identifier (SRID) coordinate. Supports tile output in SRID 3857 and 4326. | None | October 2020 | |
Added the pixelSize parameter. This parameter is used to aggregate point data and reduce the number of tiles. | None | October 2020 | ||
Bug fix | Fixed an issue where Ganos Raster failed to be updated in some cases. | October 2020 | ||
Fixed an issue where updating Ganos binary files to a new version could cause a crash. | October 2020 | |||
Fixed an issue where the data volume of top-level tiles was excessively large after vector pyramid point data was built with default parameters. | October 2020 | |||
V1.1.4
Minor engine version
Category | Name | Description | References | Release date |
Add | ali_decoding plugin | Supports the ali_decoding plugin, which is used for incremental synchronization of DML statements between databases. | None | September 2020 |
View | Added a view for process status information. | None | September 2020 | |
Added time consumption statistics to the SQL information view. | None | September 2020 | ||
Audit Log | Audit logs now include SQL statements that cause errors. | None | September 2020 | |
Bug fix | Fixed an issue where data page prefetching could cause deadlocks in specific scenarios. | September 2020 | ||
Fixed an issue where JOIN queries could not find the correct partition during partitioned table pruning. | September 2020 | |||
Spatio-temporal database (V3.0)
Category | Name | Description | References | Release date |
New feature | Support for NetCDF data with subsets | Added support for NetCDF data that has subsets. You can import the data based on the specified layer name. | None | September 2020 |
Custom metadata and time series information for raster data | Added the ST_MetaItems function to get the names of all custom metadata items. | September 2020 | ||
Added the ST_MetaData function to get custom metadata items and return them in JSON format. | September 2020 | |||
Added the ST_SetMetaData function to set metadata items. | September 2020 | |||
Added the ST_BeginDateTime function to get the start time of raster data. | September 2020 | |||
Added the ST_EndDateTime function to get the end time of raster data. | September 2020 | |||
Added the ST_SetBeginDateTime function to set the start time of raster data. | September 2020 | |||
Added the ST_SetEndDateTime function to set the end time of raster data. | September 2020 | |||
Added the ST_SetDateTime function to set the start time, end time, and band acquisition time of raster data. | September 2020 | |||
Support for returning raster data as stream-based images | Added the ST_AsImage function to get images in a stream-based format. | September 2020 | ||
Added the ST_AsPng function to get PNG images in a stream-based format. | September 2020 | |||
Added the ST_AsJPEG function to get JPEG images in a stream-based format. | September 2020 | |||
Support for geometric grid data types and operations | Added the GeomGrid data type. | September 2020 | ||
Added the ST_AsText function to convert a grid data type to its text representation. | September 2020 | |||
Added the ST_AsGeometry function to convert a grid data type to a geometry data type. | September 2020 | |||
Added the ST_AsBinary function to convert a grid data type to a binary data type. | September 2020 | |||
Added the ST_AsBox function to convert a grid data type to a BOX data type. | September 2020 | |||
Added the ST_AsGrid function to calculate the geometric grid data that corresponds to a geometry data type. | September 2020 | |||
Added the ST_GridFromText function to convert a text-based grid representation to a geometric grid data type. | September 2020 | |||
Added the ST_GridFromBinary function to convert a binary-based grid representation to a geometric grid data type. | September 2020 | |||
Added the ST_Intersects function to determine whether a raster data type and a geometry data type intersect. | September 2020 | |||
Added the ST_Contains function to determine whether a raster data contains another raster data, or whether a raster data contains a geometry data. | September 2020 | |||
Added the ST_Within function to determine whether a grid data is within another grid data, or whether a grid data is within a geometry data. | September 2020 | |||
Fast display and storage for vector data types | Added the ST_BuildPyramid function to create a data table to support fast display. | September 2020 | ||
Added the ST_DeletePyramid function to delete a data table that supports fast display. | September 2020 | |||
Added the ST_Tile function to get vector data in Mapbox Vector Tile (MVT) format. | September 2020 | |||
Bug fix | Fixed an issue where an Out Of Memory error occurred when you created a pyramid in some cases. | September 2020 | ||
Fixed an issue where a moving object could not be created at the time point of 2000-01-01. | September 2020 | |||
Fixed an issue where ST_Intersection returned an incorrect sub-trajectory for a moving object in some scenarios. | September 2020 | |||
Fixed an issue where Ganos crashed during an upgrade. | September 2020 | |||
Upgraded PostGIS compatibility to version 2.5.4. | September 2020 | |||
V1.1.3
Minor engine version
Category | Name | Description | References | Release date |
New feature | View | Added a view for SQL execution statistics. | None | August 2020 |
Added a view for queries per second (QPS) statistics. | None | August 2020 | ||
Added a view for CGroup status information. | None | August 2020 | ||
Bug fix | Fixed an issue where the size of Simple LRU (SLRU) memory was calculated incorrectly. | August 2020 | ||
Fixed an issue where replay latency caused read-only node reconstruction. | August 2020 | |||
Spatio-temporal database (V2.9)
Category | Name | Description | References | Release date |
New feature | COG file format support | Added support for the Cloud Optimized GeoTIFF (COG) file format. You can read pyramid information stored in COG files. | None | August 2020 |
ST_AddZ function | Added the ST_AddZ function. This function lets you add a z-value to a geometry object based on the pixel value of raster data. | August 2020 | ||
Enhanced access to spatial extent information of raster objects | Added the ST_Extent function to get the spatial extent of a raster object and return it as a BOX. | August 2020 | ||
Added the ST_Envelope function to get the spatial extent of a raster object and return it as a geometry object. | August 2020 | |||
The new ST_ConvexHull function obtains the spatial extent of a raster object, returning it as a geometry object. | August 2020 | |||
Added the ST_Height function to get the pixel height of a raster object. | August 2020 | |||
Added the ST_Width function to get the pixel width of a raster object. | August 2020 | |||
Bug fix | Fixed a performance limitation issue where a 1×n tile was used for external raster data. You can now customize the tile size using storage options. | August 2020 | ||
Fixed an issue where the results of the ST_Values function were inconsistent with the coordinate sorting when you queried line objects in some directions. | August 2020 | |||
Fixed an issue where the ST_BestPyramidLevel function returned a negative number in some cases. | August 2020 | |||
Fixed an issue where the ST_BuildPyramid function repeatedly created pyramids in some cases. | August 2020 | |||
Fixed an issue where the corresponding chunk tables were not cleared when a raster table was truncated. | August 2020 | |||
Fixed an issue where the CreateOption for the ST_ExportTo function was invalid in some cases. | August 2020 | |||
Fixed an issue where an error occurred for the ST_ClearChunks function when a table name contained uppercase and lowercase letters. | August 2020 | |||
Fixed an issue where overviews could not be created for external pyramids in some cases. | August 2020 | |||
Fixed an issue where an internal pyramid could not be created for a raster object that had an external pyramid. | August 2020 | |||
Fixed an issue where incorrect results were returned when statistics were calculated for raster data that contained NaN values. | August 2020 | |||
V1.1.2
Minor engine version
Category | Name | Description | References | Release date |
New feature | Temporary table | Supports writing temporary table files to local storage, which significantly improves the performance of temporary table operations. | None | July 2020 |
Triggering event | Supports logical subscriptions to event triggers for polar_superusers. | None | July 2020 | |
Custom resource isolation | Supports sending requests from custom resource isolation groups. | None | July 2020 | |
Improvement | Crash recovery process | Optimized the crash recovery process to reduce the time required for recovery in extreme cases. | None | July 2020 |
Bug fix | Fixed an issue where polar_superusers could not use the index advisor. | July 2020 | ||
Spatio-temporal database (V2.8)
Category | Name | Description | References | Release date |
New feature | Enhanced access to raster data metadata | Added the ST_XMin function to get the minimum value of raster data on the X-axis. | July 2020 | |
Added the ST_YMin function to get the minimum value of raster data on the Y-axis. | July 2020 | |||
Added the ST_XMax function to get the maximum value of raster data on the X-axis. | July 2020 | |||
Added the ST_YMax function to get the maximum value of raster data on the Y-axis. | July 2020 | |||
Added the ST_ChunkHeight function to get the tile height of raster data. | July 2020 | |||
Added the ST_ChunkWidth function to get the tile width of raster data. | July 2020 | |||
Added the ST_ChunkBands function to get the number of bands in a raster data tile. | July 2020 | |||
ST_SrFromEsriWkt function | Added the ST_SrFromEsriWkt function to support converting Esri-format spatial reference strings to Open Geospatial Consortium (OGC) format spatial reference strings. | July 2020 | ||
Raster data type | Added support for Zstandard (Zstd) and Snappy compression for the raster data type. | None | July 2020 | |
Point cloud data type | Added the binary copy feature for the point cloud data type. | None | July 2020 | |
Environment variable | Added support for setting the PROJ_LIB and GDAL_DATA environment variables and deploying related data. | None | July 2020 | |
Bug fix | Fixed an issue where an invalid OSS path caused a database crash. | July 2020 | ||
Fixed an issue where the SRID of some imported raster data was inconsistent with the definition. | July 2020 | |||
V1.1.1
Minor engine version
Category | Name | Description | References | Release date |
New feature | polar_proxy_utils plugin | Added the polar_proxy_utils plugin to manage proxy-related features. This plugin mainly supports the configuration of read-only user-defined functions (UDFs) and read-only tables. It lets you route access to read-only UDFs and read-only tables to read-only nodes through the cluster endpoint. | None | June 2020 |
polar_resource_group plugin | Added the polar_resource_group plugin. This plugin supports custom resource isolation groups and performs resource isolation based on CPU and memory dimensions at the user, database, and session granularities. | None | June 2020 | |
Improvement | Reliability and availability | Decoupled database compute nodes from the file system. The file system can be independently managed for O&M, which significantly improves database reliability and availability. | None | June 2020 |
Transaction processing | Replaced the original active transaction list snapshot with a monotonically increasing version number to significantly improve database transaction processing performance. | None | June 2020 | |
Execution plan | Optimized execution plans to avoid using outdated statistics. | None | June 2020 | |
Bug fix | Fixed an issue where a process became abnormal when the timescaledb plugin failed to request memory. | June 2020 | ||
Fixed an issue where I/O monitoring did not summarize statistics after a process exited. | June 2020 | |||
Fixed an issue where a NullPointerException could occur after lock_debug was enabled. | June 2020 | |||
Fixed an issue where the pg_cron plugin became unavailable in specific situations. | June 2020 | |||
Fixed a known community issue related to dynamic shared memory (DSM) deadlocks. | June 2020 | |||
Fixed an issue where the number of user connections exceeded the limit. | June 2020 | |||
V1.1.0
Minor engine version
Category | Name | Description | References | Release date |
New feature | polar_concurrency_control plugin | Added the polar_concurrency_control plugin. This plugin can limit the concurrency of operations such as transaction execution, SQL queries, stored procedures, and DML statements. You can customize large queries and limit their concurrency to optimize execution performance in high-concurrency scenarios. | None | May 2020 |
oss_fdw plugin | Added the oss_fdw plugin to support foreign tables for Alibaba Cloud Object Storage Service (OSS). You can use OSS foreign tables to write database data to OSS or load OSS data into the database. OSS foreign tables support parallel processing and compression, which greatly improves data import and export performance. You can also use this feature to implement hot and cold data storage on multiple types of storage media. | May 2020 | ||
Improvement | polar_stat_activity view | Optimized the polar_stat_activity view. Added the wait_info and wait_time columns to monitor the wait duration of a process for a wait object (pid or fd). | None | May 2020 |
Index | Provided an index page pre-extension feature for index insertion. This feature improves the performance of inserting data into tables with indexes. | None | May 2020 |
Spatio-temporal database (V2.7)
Category | Name | Description | References | Release date |
New feature | MD5 operation functions | Added the ST_MD5Sum function to get the MD5 value of a raster object. | May 2020 | |
Added the ST_SetMD5Sum function to set the MD5 value of a raster object. | May 2020 | |||
OSS authentication for spatial raster objects | Added the ST_AKId function to get the AccessKey ID of a raster object stored in OSS. | May 2020 | ||
Added the ST_SetAccessKey function to set the AccessKey ID and AccessKey secret for a raster object stored in OSS. | May 2020 | |||
Added the ST_SetAKId function to set the AccessKey ID for a raster object stored in OSS. | May 2020 | |||
Added the ST_SetAKSecret function to set the AccessKey secret for a raster object stored in OSS. | May 2020 | |||
Spatial raster metadata operation functions | Added the ST_ScaleX function to get the pixel width of a raster object on the X-axis in a spatial reference system. | May 2020 | ||
Added the ST_ScaleY function to get the pixel width of a raster object on the Y-axis in a spatial reference system. | May 2020 | |||
Added the ST_SetScale function to set the pixel width of a raster object in a spatial reference system. | May 2020 | |||
Added the ST_SkewX function to get the rotation of a raster object on the X-axis in a spatial reference system. | May 2020 | |||
Added the ST_SkewY function to get the rotation of a raster object on the Y-axis in a spatial reference system. | May 2020 | |||
Added the ST_SetSkew function to set the rotation of a raster object in a spatial reference system. | May 2020 | |||
Added the ST_UpperLeftX function to get the X-coordinate of the upper-left point of a raster object in a spatial reference system. | May 2020 | |||
Added the ST_UpperLeftY function to get the Y-coordinate of the upper-left point of a raster object in a spatial reference system. | May 2020 | |||
Adds the ST_SetUpperLeft function to obtain the coordinates of the upper-left corner point of a raster object in the spatial reference system. | May 2020 | |||
Added the ST_PixelWidth function to get the pixel width of a raster object in a spatial reference system. | May 2020 | |||
Added the ST_PixelHeight function to get the pixel height of a raster object in a spatial reference system. | May 2020 | |||
Bug fix | Fixed an issue where an extension upgrade failed due to an aggregation function. | May 2020 | ||