What are the release notes of PolarDB for PostgreSQL - PolarDB

This topic describes the release notes for the minor versions, console, Ganos, and API of PolarDB for PostgreSQL.

Note

You can execute the following statement to view the database engine revision version of your PolarDB for PostgreSQL cluster:
```
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.

December 2023

Minor version 1.1.36

Category	Feature	Description	References
New feature	PolarDB for PostgreSQL allows privileged users to grant the REPLICATION permission to other users.	PolarDB for PostgreSQL allows privileged users to grant the REPLICATION permission to other users based on business requirements.	N/A

Minor version 1.1.35

Category	Feature	Description	References
New feature	Parallel writes and queries of OSS foreign tables	The multi-node elastic parallel query (ePQ) feature supports parallel writes and queries of OSS foreign tables to improve performance of cold data archiving and cold data queries.	EPQ supports parallel writing and querying OSS foreign tables

Minor version 1.1.34

Category	Feature	Description	References
New feature	PolarDB for PostgreSQL channels	PolarDB for PostgreSQL channels support multiple extensions such as DBlink and fdw. You can create channels and use them to connect to external endpoints of PolarDB for PostgreSQL clusters.	DBLink and foreign tables

Ganos V5.6

Category	Feature	Description	References
New feature	ST_AsMVT3D function and ST_AsMVTGeom3D function	The ST_AsMVT3D and ST_AsMVTGeom3D functions are added to support 3D vector slices of 3D geometries.	ST_AsMVT3D and ST_AsMeom3D
	ST_AsTableFormat function	The ST_AsTableFormat function is added to obtain the definition of a trajectory to specify the column type for the ST_AsTable function.	ST_AsTableFormat
	ST_ImportGLTF function and ST_ImportGLB function	OSS-based glTF and glb files can be imported into databases as SFMesh objects.	ST_ImportGLTF and ST_ImportGLB
Fixed issues	ST_Intersection function	The following issue is fixed: ST_Intersection incorrectly determines the intersection of two overlapping segments.	ST_intersection

Minor version 1.1.32

Category	Feature	Description	References
New feature	Fine-grained permission management of polar_superuser on the cloud	PolarDB for PostgreSQL adopts a role-based RAM model to manage account permissions, and uses this permission system to build database operation types, implement the RAM model, and protect permission security.	Account permissions
	PartitionedTable scan	The PartitionedTable scan feature is used to solve the issue of low query performance when a large number of partitions exist in a partitioned table.	N/A
	Flashback log size limit	Added the polar_flashback_log_size_limit parameter to limit the storage space occupied by flashback logs.	Table flashback

Ganos V5.5

Category	Feature	Description	References
New feature	ST_MosaicFrom function	The S T_MosaicFrom function is enhanced to support parallel operations.	ST_MosaicFrom
New feature	ST_MosaicFrom function	The ST_MosaicFrom function is enhanced to support mosaic operations on raster objects of different resolutions and projections.	ST_MosaicFrom
Fixed issues	ST_makeTrajectory function	The following issue is fixed: The system crashes when ST_makeTrajectory uses the start time and end time to create a trajectory with only two points.	ST_makeTrajectory

Minor version 1.1.31

Category	Feature	Description	References
New feature	GPC enabled by default	By default, the Global Plan Cache (GPC) feature is enabled for PolarDB for PostgreSQL clusters.	Global plan cache
New feature	Replay wait parameter defined for specified roles	You can set the `polar_px_enable_replay_wait` parameter to on for specified database roles.	Use the cross-node parallel execution feature to run analytical queries

Ganos V5.4

Category	Feature	Description	References
New feature	ST_ClusterDBSCAN function	The ST_ClusterDBSCAN function supports the density-based spatial clustering of applications with noise (DBSCAN) algorithm in a latitude and longitude coordinate.	ST_ClusterDBSCAN
	ST_CurveRecognize function	The ST_CurveRecognize function identifies a curve of a trajectory and the curvature radius.	ST_CurveRecognize
	ST_AsGrid function	The ST_AsGrid function queries degenerated grids in 2D.	ST_AsGrid
	pgRouting extension	The pgRouting extension can be upgraded to 3.4.2.	pgRouting

Minor version 1.1.30

Category	Feature	Description	References
New feature	pgTAP extension	The pgTAP extension is a unit testing framework for PostgreSQL written in PL/pgSQL and PL/SQL. As a TAP testing framework of PolarDB for PostgreSQL, it includes a comprehensive collection of TAP-emitting assertion functions, and the ability to integrate with other TAP-emitting test frameworks.	pgtap

Ganos V5.3

Category	Feature	Description	References
New feature	ST_Angle function	The ST_Angle function is added to return each rotation angle of a trajectory as an array.	ST_Angle
	ST_CurvatureRadius function	The ST_CurvatureRadius function is added to return each curvature radius of a trajectory as an array.	ST_CurvatureRadius
	PostGIS extension	Ganos is compatible with PostGIS 3.3.2.	PostGIS
Fixed issues	The following issue is fixed: The ST_AsTable function fails when `x,y,t` is NULL.