Product feature updates for PolarDB for PostgreSQL-PolarDB(PolarDB)-阿里云帮助中心

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

Note

You can run the following statement to view the minor version number of your cluster:
```
SHOW polardb_version;
```
Starting February 26, 2025 (UTC+8), the format for minor version numbers will change to a six-digit format. For details about this change and the mapping from old to new version numbers, see PolarDB minor version number format update.

December 2023

Minor version V1.1.36

Category	Feature	Description	References
New Feature	high-privilege accounts require the REPLICATION privilege.	now allows privileged users to grant the REPLICATION permission to other users.	N/A

Minor version V1.1.35

Category	Feature	Description	References
New Feature	ePQ support for parallel writes and queries on OSS foreign tables	The elastic parallel query (ePQ) feature now supports parallel writes to and queries on OSS foreign tables, improving performance for archiving and querying cold data.	ePQ support for parallel write and query operations on OSS foreign tables

Minor version V1.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 a channel and use it to connect to the external endpoint of a cluster.	DBLink and foreign tables

Ganos V5.6

Category	Feature	Description	References
New Feature	ST_AsMVT3D and ST_AsMVTGeom3D functions	Ganos now includes the ST_AsMVT3D and ST_AsMVTGeom3D functions, which support 3D vector slices of Geometry3D data.	ST_AsMVT3D, ST_AsMVTGeom3D
	ST_AsTableFormat function	The new ST_AsTableFormat function returns the value type that the ST_AsTable function generates for a trajectory.	ST_AsTableFormat
	ST_ImportGLTF and ST_ImportGLB functions	Ganos now supports importing OSS-based glTF and glb files as SFMesh objects.	ST_ImportGLTF, ST_ImportGLB
Fixed Issue	ST_Intersection function	The ST_Intersection function now correctly determines the intersection of two overlapping trajectory segments.	ST_intersection

Minor version V1.1.32

Category	Feature	Description	References
New Feature	Fine-grained permission management for polar_superuser	adopts a role-based access control model to manage permissions for standard users. This system defines types of database operations, implements a robust access control model, and enhances cloud database security.	Account permissions
	Partitioned table scan	The partitioned table scan feature improves query performance on partitioned tables with a large number of partitions.	N/A
	Space limit for flashback logs	You can now use the polar_flashback_log_size_limit parameter to limit the storage space that flashback logs consume.	Table flashback

Ganos V5.5

Category	Feature	Description	References
New Feature	ST_MosaicFrom function	The ST_MosaicFrom function now supports parallel operations.	ST_MosaicFrom
New Feature	ST_MosaicFrom function	The ST_MosaicFrom function now supports mosaicking images with different resolutions or projections.	ST_MosaicFrom
Fixed Issue	ST_makeTrajectory function	The ST_makeTrajectory function no longer crashes when creating a two-point trajectory using only a start and end time.	ST_makeTrajectory

Minor version V1.1.31

Category	Feature	Description	References
New Feature	GPC enabled by default	The Global Plan Cache (GPC) feature is enabled by default on clusters.	Global Plan Cache (GPC)
New Feature	Replay wait parameter can be set per role	You can now enable the `polar_px_enable_replay_wait` parameter for a specific database role.	Use elastic parallel queries for analytical queries

Ganos V5.4

Category	Feature	Description	References
New Feature	ST_ClusterDBSCAN function	Performs DBSCAN clustering based on latitude and longitude coordinates.	ST_ClusterDBSCAN
	ST_CurveRecognize function	Recognizes curves and turning radii in a trajectory.	ST_CurveRecognize
	ST_AsGrid function	Performs 2D degenerated grid calculations.	ST_AsGrid
	pgRouting extension	The pgRouting extension has been upgraded to version 3.4.2.	pgRouting

Minor version V1.1.30

Category	Feature	Description	References
New Feature	pgtap extension	pgtap is a unit testing framework written in PL/pgSQL and PL/SQL, and a TAP testing framework for that includes a comprehensive set of TAP assertion functions and can integrate with other TAP testing frameworks.	pgtap (unit testing)

Ganos V5.3

Category	Feature	Description	References
New Feature	ST_Angle function	Outputs the angle of each turn in a trajectory as an array.	ST_Angle
	ST_CurvatureRadius function	Outputs the turning radius of each turn in a trajectory as an array.	ST_CurvatureRadius
	PostGIS extension	The PostGIS extension has been upgraded to version 3.3.2.	PostGIS
Fixed Issue	The ST_AsTable function no longer crashes when the `x,y,t` dimension is NULL.