2023

Category

Feature

Description

References

New feature

REPLICATION permission granted by a privileged account in PolarDB for Oracle

PolarDB for Oracle allows a privileged account to grant the REPLICATION permission to other users.

N/A

Category

Feature

Description

References

New feature

Parallel writes and queries for OSS foreign tables supported in ePQ

Parallel writes and queries of Object Storage Service (OSS) foreign tables are supported in the multi-node elastic parallel query (ePQ) feature to improve performance of cold data archiving and cold data queries.

ePQ supports parallel writes and queries for OSS foreign tables

Global indexes created on multi-level partitions

Global indexes can be created on multi-level partitioned tables or partition keys in PolarDB for Oracle.

Create global indexes on multi-level partitioned tables

Global indexes used as primary or foreign keys

Any column in a partitioned table can be specified as the primary key or foreign key in PolarDB for Oracle.

Configure any column in a partitioned table as the primary key or foreign key

Category

Feature

Description

References

New feature

Channels available in PolarDB for Oracle

Various extensions such as dblink and foreign data wrapper (fdw) are available in the channels of PolarDB for Oracle. New channels can be used to connect to the external network address of a cluster.

CREATE SERVER

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 issue

ST_Intersection function

The following issue is fixed: ST_Intersection incorrectly determines the intersection of two overlapping segments.

ST_intersection

Category

Feature

Description

References

New feature

Fine-grained permission management of polar_superuser in the cloud

PolarDB for Oracle uses a role-based Resource Access Management (RAM) model to manage the permissions of standard accounts. This permission system is used to build database operation types, implement the RAM model, and ensure 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.

PartitionedTable Scan Node

Flashback log size limit

The polar_flashback_log_size_limit parameter is added to limit the storage space occupied by flashback logs.

Flashback table

SQL hint injection supported in ePQ

The ePQ Hint Injection feature can be used to inject PX hints into an SQL statement when the PX hints failed to be added to the SQL statement during database maintenance. You can determine whether to allow the SQL statement to run ePQ while keeping the SQL statement unchanged.

ePQ Hint Injection

Category

Feature

Description

References

New feature

ST_MosaicFrom function

The ST_MosaicFrom function is enhanced to support parallel operations.

ST_MosaicFrom

ST_MosaicFrom function

The ST_MosaicFrom function is enhanced to support mosaic operations on raster objects of different resolutions and projections.

ST_MosaicFrom

Fixed issue

ST_makeTrajectory function

The following issue is fixed: The system crashes if ST_makeTrajectory and the start time and end time are used to create a trajectory with only two points.

ST_makeTrajectory

Category

Feature

Description

References

New feature

GPC enabled by default

By default, the Global Plan Cache (GPC) feature is enabled for PolarDB for Oracle.

Global Plan Cache

Replay wait parameter defined for specified roles

The polar_px_enable_replay_wait parameter can be set to on for specified database roles.

Run analytical queries

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 V3.4.2.

pgRouting

Category

Feature

Description

References

New feature

pgTAP extension

The pgTAP extension is a unit testing framework written in PL/pgSQL and PL/SQL. As a TAP testing framework of PolarDB for Oracle, the extension includes a comprehensive collection of TAP-emitting assertion functions and can be integrated with other TAP-emitting testing framework.

pgtap

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 issue

The following issue is fixed: The ST_AsTable function fails when the value of x,y,t is NULL.