All Products
Search

This Product

    :Release notes

    Document Center

    :Release notes

    Last Updated:Jun 20, 2026

    This topic covers updates to the minor version, console, Ganos, and API of PolarDB for PostgreSQL (Compatible with Oracle).

    Note To view the minor version of PolarDB for PostgreSQL (Compatible with Oracle), execute the following statement: 
    show polar_version;

    September 2022

    Minor version V1.1.26

    Category

    Feature

    Description

    References

    New features

    Support for DBMS_METADATA

    Use the methods in DBMS_METADATA to retrieve object definitions for reconstruction.

    DBMS_METADATA

    Support for nls_timestamp(_tz)_format

    Supports the nls_timestamp(_tz)_format time format.

    nls_timestamp(_tz)_format

    Support for logon and logoff triggers

    A logon and logoff trigger is an event trigger that executes a specified function or stored procedure when a user logs on or off.

    Logon and logoff triggers

    Full caching for batch writes

    The new polar_enable_strat_bulkwrite parameter controls how much cache space data from a session can occupy. The default value is true. Valid values:

    • true: Matches native PostgreSQL behavior. Data from each session is restricted to a portion of the cache.

    • false: Data written by a session can use the entire cache space.

    Note

    • Typically, the default value of true is recommended. This ensures each session has a dedicated portion of the cache and prevents it from evicting cached data from other sessions.

    • Set this parameter to false when all data from a batch write needs to be cached. This strategy maximizes the cache hit ratio for subsequent reads of this data, reducing disk I/O.

      For best results, use this parameter with the polar_enable_strat_scan parameter. Setting both parameters to false allows data to be written to and read from the entire cache space.

      set polar_enable_strat_bulkwrite = false; -- Allows writing to the entire cache space.
set polar_enable_strat_scan = false; -- Allows reading from or loading into the entire cache space.

    None

    Support for ORDER BY clauses with aggregate functions

    You can now use an ORDER BY clause with an aggregate function, even without a GROUP BY clause.

    • Syntax

      SELECT aggfunc(xx) FROM yy ORDER BY any target;

    • How to enable

      In the console, set the polar_enable_aggfunc_allowed_sort_target parameter to on.

    ORDER BY clause

    Support for expressions on DISTINCT columns in the ORDER BY clause

    The ORDER BY clause can now use expressions based on columns from the SELECT DISTINCT list.

    • Syntax

      SELECT distinct xx, yy FROM zz ORDER BY expr(xx, yy);

    • How to enable

      In the console, set the polar_enable_distinct_order_by_expr parameter to on.

    Support for aliased expressions in the ORDER BY clause

    You can now use expressions with aliases in an ORDER BY clause.

    • Syntax

      SELECT xx yy, mm nn FROM zz ORDER BY expr(yy,nn);

    • How to enable

      In the console, set the polar_enable_order_by_use_alias_expr parameter to on.

    Note

    When this feature is enabled, if an object alias in the SELECT list has the same name as a column in the FROM clause, the ORDER BY clause prioritizes resolving the name to the object in the SELECT list.

    All legacy compatibility features enabled by default

    The following parameters are enabled by default for new PolarDB for Oracle clusters:

    • polar_comp_redwood_greatest_least

    • polar_comp_redwood_strings

    • polar_enable_rownum_connectby_operator

    • polar_enable_rownum_rewrite_for_write

    • polar_plsql_auto_unpin_failed_portal

    • polar_plsql_auto_unpin_failed_portal_stmt_tx

    • polar_enable_inline_cte

    • polar_enable_comp_numeric_format

    The following parameters must be enabled manually in the console:

    • polar_handle_substrb_utf8_truncation

    • polar_enable_base64_decode

    None

    GanosBase V4.9

    Category

    Feature

    Description

    References

    New features

    ST_Intersection aggregate function

    Calculates the intersection of a set of geometry objects.

    ST_Intersection

    ST_AddZ function

    Converts a 2D or 3DM geometry object to a 3D or 4D object by using an array of Z-coordinates.

    ST_AddZ

    ST_SetValue function

    Sets pixel values at specified positions or within the spatial extent of a given geometry object.

    ST_SetValue

    Improvements

    ST_ExportTo function

    You can now export raster objects as COG files.

    ST_ExportTo

    ST_CreateRast function

    Converts multiple records or an array of regular grid points into a raster object.

    ST_CreateRast

    ST_Split function

    When you split a trajectory by time, you can now specify a start time. You can also split a trajectory by the sequence number of its points.

    ST_Split

    ST_Union function

    Now executes in batches based on memory usage to prevent out-of-memory (OOM) errors when processing large datasets.

    ST_Union

    ST_CreateRast function

    You can now create raster objects from raster data stored in HDFS.

    ST_CreateRast

    ST_ImportFrom function

    You can now import raster data from HDFS.

    ST_ImportFrom

    ST_ExportTo function

    You can now export raster data to the HDFS file system.

    ST_ExportTo

    Bug fixes

    Fixed an issue where the ST_makeTrajectory function could cause a crash.

    Fixed an issue where the ST_lcsSimilarity function did not recognize time intervals specified in days.

    Fixed an issue where the ST_AsEWKB function failed to convert trajectories built from data tables.

    Fixed an issue where the ST_BuildPyramid function consumed excessive memory when building a vector pyramid from a very large dataset.

    August 2022

    Minor version V1.1.25

    Category

    Feature

    Description

    References

    New feature

    pgAudit plugin

    Supports the pgAudit plugin for generating audit logs.

    pgAudit

    Support for DBMS_UTILITY.FORMAT_ERROR_BACKTRACE

    The DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function returns the formatted content of the call stack from where an exception was thrown.

    DBMS_UTILITY

    Support for modifying data types of a base table with a view

    You can directly modify the column data types of a base table if a simple view is built on it.

    ALTER TABLE

    Support for DML from subquery

    Supports using subqueries in DML statements, such as INSERT, UPDATE, and DELETE.

    You can use the polar_enable_dml_from_subquery parameter to enable or disable this feature. The default value is true. Valid values:

    • true: Enables the feature.

    • false: Disables the feature.

    DML support for global partitioned index scan

    Supports GLOBAL PARTITIONED INDEX SCAN in DML operations.

    DML support for GLOBAL PARTITIONED INDEX SCAN

    Case insensitivity

    Adds a case insensitivity feature. When enabled, the system treats unquoted, all-uppercase, and all-lowercase identifiers for database objects as equivalent.

    Case insensitivity

    New Oracle built-in functions

    PolarDB for PostgreSQL (Oracle Compatible) adds the following Oracle built-in functions:

    • to_timestamp/to_char/to_date(.., nlsparam)

    • wm_concat

    • bitand/bitor

    • to_dsinterval/to_yminterval

    None

    Plugins installed by default

    PolarDB for PostgreSQL (Oracle Compatible) installs the following plugins by default:

    • polar_from_tz

    • polar_nlssort

    • polar_regexp_like

    • polar_utility

    • sys_guid

    • polar_constraint

    • polar_parameter_check

    • polar_worker

    • roaringbitmap

    • polar_csn

    Note

    The first six plugins ensure compatibility.

    None

    July 2022

    Minor version V1.1.24

    Category

    Parameter

    Description

    References

    New feature

    plan_cache_mode

    Adds the plan_cache_mode parameter, which allows you to set the plan cache mode. The default value is auto. Valid values:

    • auto: Automatically selects between the custom and generic modes.

    • force_custom_plan: Forces the optimizer to use a custom plan.

    • force_generic_plan: Forces the optimizer to use a generic plan from the plan cache.

    None

    GanosBase V4.7

    Category

    Parameter

    Description

    References

    New feature

    ST_makeTrajectory function

    Converts table rows to a trajectory.

    ST_makeTrajectory

    ST_AsTable function

    Converts a trajectory to a table.

    ST_AsTable

    Fixed issue

    Fixed an issue that prevented the automatic deletion of anonymous temporary tables during raster data operations.

    June 2022

    Minor version V1.1.23

    Category

    Feature

    Description

    References

    New

    Support for DBMS_SQL.define_array

    The DBMS_SQL package now includes the DEFINE_ARRAY stored procedure.

    DBMS_SQL

    Support for using both %TYPE and := to specify default values

    You can now specify default values in a stored procedure by using both %TYPE and the := assignment operator.

    Use %TYPE in variable declarations

    Global Partitioned Index

    You can now create a Global Partitioned Index on a partitioned table.

    Create a GLOBAL INDEX

    pg_hint_plan

    Adjusts execution plans using hints in special comment statements.

    pg_hint_plan

    Optimization

    Optimization of the resource manager's memory release process

    • Adds the mem_release_policy parameter, which specifies the memory release policy. Default: default. Valid values:

      • default: If a database's resource usage exceeds its limit, the resource manager activates an adaptive policy to release memory. The system first releases memory from idle processes, and then from active processes. This value cannot be combined with other values.

      • cancel_query: Cancels queries only for active processes.

      • terminate_idle_backend: Terminates idle user processes.

      • terminate_any_backend: Terminates any user process.

      • none: Takes no action.

    • Adds the total_memcontext_dump_rate parameter, which specifies the output threshold for memory context information. Default: 75. Range: 20 to 95. The change takes effect after a restart or configuration reload.

    • Adds the max_proc_mcxtdump_num parameter, which specifies the number of processes for which to output memory context information. Default: 1. Range: 1 to 100. The change takes effect after a restart or configuration reload.

    • Adds the interval_max_num parameter, which specifies the number of intervals for outputting memory context information. Default: 0. Range: 0 to INT32_MAX. The change takes effect after a restart or configuration reload.

    N/A

    March 2022

    Minor kernel version 1.1.22

    Category Feature Description References
    New feature Implicit type conversion Supports implicit type conversion compatible with the Oracle implicit conversion matrix and allows the conversion of numeric types from high to low precision. None
    PX Analyze
    • In parallel queries, you can now use the explain analyze command to display the execution details for each worker, including the number of tuples processed and time consumed.
    • In parallel queries, you can now use the explain analyze command to display the memory usage of each worker. Valid values:
      • summary: Displays a summary of worker memory usage.
      • detail: Displays the detailed memory usage for each worker.
    		 None
    Support for modifying column types in global temporary tables Global temporary tables now support ALTER statements. None
    Support for Clang Supports compilation with Clang. None

    Ganos (V4.6)

    Category Feature Description References
    New feature object storage path Supports accessing raster data on user-created MinIO servers. object storage path
    ST_PointValues function Adds the ST_PointValues raster function to return the pixel values of all bands. ST_PointValues
    Bug fix Fixed an issue where the band order was incorrect when using the ST_Clip raster function.
    Fixed a performance issue caused by a missing primary key index during raster data updates.
    Fixed an issue where failures to read trajectory data from OSS were not retried.

    Ganos 4.5

    Category Feature Description References
    New feature Ganos now supports PostgreSQL 14. None
    Improvement Added caching for trajectory objects in external storage to improve access performance. None
    Bug fix Fixed an issue where the file extension was missing when exporting raster data to OSS.
    Fixed an issue where statistics collection failed for some raster data.

    January 2022

    minor kernel version (V1.1.20)

    Category Feature Description References
    New flashback drop You can now use flashback drop to quickly restore dropped tables, view the recycle bin, and purge items from the recycle bin. Flashback Drop
    OPT_PARAM hint enhancement You can now use the OPT_PARAM hint to specify parameter values at the SQL level. OPT_PARAM Hints
    Parallel query for multi-level partitioned tables You can now use parallel query for multi-level partitioned tables. Use Parallel Query on Partitioned Tables
    DML support for global index scan You can now use global index scan in Data Manipulation Language (DML) operations. Use Global Index Scan in DML Operations

    Ganos (V4.4)

    Category Feature Description References
    New ST_LinearStretch function The new ST_LinearStretch function performs a linear stretch on a raster, returning the result as a new raster. ST_LinearStretch
    ST_BuildPercentiles function The new ST_BuildPercentiles function computes the pixel value percentiles of a raster. ST_BuildPercentiles
    ST_ComputeStatistics function The new ST_ComputeStatistics function computes statistics, histograms, and percentiles for raster data in a single operation. ST_ComputeStatistics
    ST_Percentile function The new ST_Percentile function retrieves the pixel percentile of a raster. ST_Percentile
    Improved Parallel computing The ST_SummaryStats and ST_BuildHistogram functions now support parallel computing. None
    ST_ExportTo function The ST_ExportTo function now returns false instead of an error if the destination file already exists. None
    ST_ImportFrom function The ST_ImportFrom function now returns detailed error information to aid troubleshooting when a data import fails. ST_ImportFrom
    Fixed Fixed an issue where half a pixel could be lost due to rounding during raster clipping.
    Fixed an issue where importing or calculating statistics for raster data would fail if the data contained values such as NAN and INF.

    December 2021

    Minor version 1.1.19

    Category Feature Description References
    New feature SQL mapping PolarDB for PostgreSQL (Compatible with Oracle) supports SQL mapping. This feature lets you map incorrect SQL statements to valid ones to prevent SQL errors. polar_sql_mapping
    Support for parallel UPDATE in cross-node parallel execution Cross-node parallel execution supports parallel UPDATE, including UPDATE statements with a subquery.
    Set the polar_px_enable_update parameter to enable or disable this feature. The default value is false.
    • Set this parameter to true to enable this feature.
    • Set this parameter to false to disable this feature.

    Set the polar_px_update_dop_num parameter to control the degree of parallelism (DOP) for parallel updates. The default value is 6. Valid values: 1 to 128.

    Set the polar_px_enable_remove_update_redundant_motion parameter to specify whether to remove redundant motion operators when the read and write worker counts are equal. The default value is false.
    • Set this parameter to true to remove redundant motion operators.
    • Set this parameter to false to not remove redundant motion operators.
    		 cross-node parallel execution
    Support for parallel DELETE in cross-node parallel execution Cross-node parallel execution supports parallel DELETE, including DELETE statements with or without a subquery.
    Set the polar_px_enable_delete parameter to enable or disable this feature. The default value is false.
    • Set this parameter to true to enable this feature.
    • Set this parameter to false to disable this feature.

    Set the polar_px_delete_dop_num parameter to control the degree of parallelism (DOP) for parallel deletes. The default value is 6. Valid values: 1 to 128.

    Set the polar_px_enable_remove_delete_redundant_motion parameter to specify whether to remove redundant motion operators when the read and write worker counts are equal. The default value is false.
    • Set this parameter to true to remove redundant motion operators.
    • Set this parameter to false to not remove redundant motion operators.
    Support for partition-wise join in cross-node parallel execution Cross-node parallel execution supports partition-wise join for partitioned tables. Use cross-node parallel execution for partitioned tables
    Compatibility with Oracle views PolarDB for PostgreSQL (Compatible with Oracle) is now compatible with the Oracle ALL_TAB_COLUMNS and ALL_TAB_COMMENTS views, and some columns of the ALL_OBJECTS view. ALL_TAB_COLUMNS, ALL_OBJECTS
    Optimized feature Support for DBMS_SQL.TO_CURSOR_NUMBER and DBMS_SQL.TO_REFCURSOR Supports the DBMS_SQL.TO_CURSOR_NUMBER and DBMS_SQL.TO_REFCURSOR stored procedures.
    Example:
       -- Convert local dynamic SQL to DBMS_SQL
  curid := dbms_sql.to_cursor_number(cursrc);
    		 None

    Ganos (V4.3)

    Category Feature Description References
    New feature ST_PixelAsPolygon function Adds the ST_PixelAsPolygon function, which converts a raster pixel into a Polygon object. ST_PixelAsPolygon
    ST_PixelAsPolygons function Adds the ST_PixelAsPolygons function, which converts the pixels of a raster into a set of Polygon objects. ST_PixelAsPolygons
    ST_PixelAsPoint function Adds the ST_PixelAsPoint function, which converts a raster pixel into a point-based geometry object. ST_PixelAsPoint
    ST_PixelAsCentroid function Adds the ST_PixelAsCentroid function, which converts a raster pixel into a centroid-based geometry object. ST_PixelAsCentroid
    ST_PixelAsPoints function Adds the ST_PixelAsPoints function, which converts the pixels of a raster into a set of Point objects. ST_PixelAsPoints
    ST_PixelAsCentroids function Adds the ST_PixelAsCentroids function, which converts the pixels of a raster into a set of centroid objects. ST_PixelAsCentroids
    Optimized feature Geometry model The geometry model is now compatible with the PostGIS 3.1.4 interface. None
    ST_AsDatasetFile function The ST_AsDatasetFile function now supports output in GRIB2 data format. None
    Fixed issue Fixed an issue with incorrect spatial reference identifier (SRID) retrieval when importing raster data in NetCDF format.
    Fixed an issue where incorrect equals comparison results for multiple bounding boxes caused update failures.

    October 2021

    Minor kernel version (V1.1.17)

    Category Parameter Description References
    New feature Runtime partition pruning for DML Partitioned tables now support runtime partition pruning for UPDATE and DELETE operations. partition pruning
    Support for ORDER BY in aggregate functions Aggregate functions now support simple queries that include an ORDER BY clause. aggregate function
    Schema specification for triggers You can now specify a schema for a trigger by prefixing the trigger name. trigger
    Support for two-dimensional associative arrays Now supports two-dimensional associative arrays. associative array
    Accelerated INSERT...SELECT with parallel read and write Cross-node parallel execution enhances INSERT...SELECT performance by upgrading from a single-write, parallel-read model to a parallel-write, parallel-read model.
    You can set the polar_px_insert_dop_num parameter to control the degree of parallelism for writes. The default value is 6.
    • If this parameter is set to 1, a single-write, parallel-read plan is used.
    • If this parameter is set to a value greater than 1, a parallel-write, parallel-read plan is used.
    		 cross-node parallel execution
    Accelerated INSERT...SELECT from tableless queries Cross-node parallel execution now accelerates INSERT...SELECT from tableless queries, which further improves performance.
    You can set the polar_px_enable_insert_from_tableless parameter to enable or disable acceleration for tableless queries. The default value is 0.
    • 1: Enables the feature.
    • 0: Disables the feature.
    Enforced ordering for sensitive INSERT...SELECT queries In cross-node parallel execution, you can set the polar_px_enable_insert_order_sensitive parameter to enforce ordered results for write operations. The default value is true.
    • If polar_px_enable_insert_order_sensitive is set to true, write operations are forced to be ordered for SQL statements that contain an ORDER BY clause or involve a tableless query.
    • If polar_px_enable_insert_order_sensitive is set to false, parallel INSERT operations do not guarantee order.
    Support for ROWNUM in PX Cross-node parallel execution now supports the Oracle-compatible ROWNUM expression.
    DDL operations can cancel blocking PX queries If a DDL operation is blocked by a PX query lock, you can set a timeout. When the timeout expires, the PX query is canceled, allowing the DDL operation to proceed.
    Support for LEADING hint Supports the LEADING hint, a multi-table hint that specifies the join order for multiple tables. LEADING hint
    DELETE FROM subquery Supports DELETE FROM subquery. None
    SELECT UNIQUE syntax Supports the SELECT UNIQUE syntax, where UNIQUE is an alias for DISTINCT. None
    Support for UPDATING in DML triggers The UPDATING('colname') conditional expression is now supported in DML triggers. None
    Support for WHERE clause in MERGE statements The MERGE statement now supports using a WHERE clause in its UPDATE and DELETE branches. None
    Support for aliases in INSERT...SELECT The INSERT statement now supports aliases in the SELECT list. None
    Support for multi-character delimiters in COPY The COPY command now supports multi-character delimiters. None
    Optimized feature Support for polar_row_id in PX Cross-node parallel execution now supports polar_row_id. None
    Parallel replay on read-only nodes Read-only nodes now use multiple processes to accelerate WAL replay, reducing replication delay between the primary node and read-only nodes. None

    Ganos (V4.1)

    Category Parameter Description References
    Optimized feature ST_ImportFrom function The ST_ImportFrom function now maps Object Storage Service (OSS) files to in-memory files to accelerate data import. ST_ImportFrom and ganos.raster.memory_oss_file_max_size
    GiST/TrajGiST indexing The new trajgist_ops_multi operator family for GiST and TrajGiST indexes supports indexing keys with multiple bounding boxes. GiST indexing, TrajGiST indexing, and ganos.trajectory.index_split_config
    Fixed issue Fixed an issue that prevented metadata queries on vector pyramids.
    Fixed a memory leak during intersection checks on trajectory objects.

    September 2021

    Minor version 1.1.16

    Category Feature Description Related documentation
    New features Manual query rewrite with outlines Use outlines to rewrite SQL queries when the PolarDB query rewrite feature does not yield the desired result. Adjust execution plan
    Support for the AssertOp operator in cross-node parallel execution Cross-node parallel execution supports runtime constraint checks on the executor. Cross-node parallel execution
    Support for Oracle DECODE expressions in cross-node parallel execution Cross-node parallel execution supports Oracle DECODE expressions.
    Support for dynamic partition pruning in cross-node parallel execution Cross-node parallel execution supports dynamic partition pruning, improving the performance of hash joins on partitioned tables.
    Support for holdable portals in Bind messages Allows SQL statements to be accessed across transactions. To enable this, add the polar_holdable_hint hint to your SQL statement. For example: SELECT /*+ polar_holdable_hint */;. None
    Oracle-compatible SELECT FOR UPDATE The SELECT FOR UPDATE OF statement is fully compatible with Oracle syntax. None
    Enhancements Support for constant expressions in cross-node parallel execution Cross-node parallel execution supports constant expressions. None
    Operator-level memory limits Operator-level memory limits reduce the risk of OOM errors and improve PolarDB stability. None

    Ganos V4.0

    Category Feature Description Related documentation
    Enhancements Raster surface computation functions Raster surface computation functions now return raster objects instead of a pixel matrix. ST_Aspect, ST_Slope, and ST_Hillshade
    ST_Split function The ST_Split function now splits a trajectory object based on a specified rule and returns an array of sub-trajectories. ST_Split
    Fixed issues Resolved an issue that caused the ST_SrEqual function to incorrectly evaluate spatial reference systems under certain conditions.

    August 2021

    Minor version 1.1.15

    Category Feature Description References
    New feature Index Advisor logs execution costs before and after indexing The index_advisor_log table now includes two new columns that show the execution costs before and after creating an index. These columns help upper-layer applications, such as Database Autonomy Service (DAS), evaluate the benefits of creating an index. None
    Elastic Parallel Query support for accelerated global index creation Elastic Parallel Query (PX) now accelerates the creation of global B-Tree indexes. Elastic Parallel Query, Use Elastic Parallel Query to accelerate index creation, and Create a global index

    July 2021

    Minor version (V1.1.14)

    Category Feature Description References
    New feature Compatibility with GNU Compiler Collection (GCC) 9 This release adds support for the GNU Compiler Collection (GCC) 9.2.1. This update provides more compilation optimizations and improves performance. None
    Hints in statement outlines You can now specify hints in statement outlines to control which execution plans are captured by the outline feature. Adjust execution plans
    cross-node parallel execution on hash partitions This release adds support for parallel execution on hash partitions. This feature balances I/O loads and improves system performance. Use cross-node parallel execution for partitioned tables
    GLOBAL INDEX supports DDL operations on partitioned tables You can now manage all GLOBAL INDEX instances on a partitioned table when you perform DDL operations (such as DROP, SPLIT, and MERGE) on that table. Supported DDL operations on partitioned tables
    Improvement ORA_HASH function compatibility For compatibility, calls to the ORA_HASH function are now handled by DBMS_UTILITY.GET_HASH_VALUE to compute the hash value of a given string. None

    Ganos (V3.9)

    Category Feature Description References
    New feature ST_RemoveDriftPoints function The ST_RemoveDriftPoints function removes drift points from a trajectory based on specified rules. ST_removeDriftPoints
    ST_Split function The ST_Split function splits a trajectory using a specified geometry object. ST_Split
    ST_ExportTo function The ST_ExportTo function exports a trajectory to external storage, leaving only its metadata in the database. ST_ExportTo
    ST_IsExternal function The ST_IsExternal function checks whether a trajectory is stored in an external file. ST_IsExternal
    ST_ImportFrom function The ST_ImportFrom function imports a trajectory from external storage into the database. ST_importFrom
    ST_StorageLocation function The ST_StorageLocation function returns the external storage location of a trajectory. ST_StorageLocation
    ST_AKID function The ST_AKID function returns the AccessKey ID used to interact with OSS when reading a trajectory. ST_AKID
    ST_SetAccessKey function The ST_SetAccessKey function sets the AccessKey ID and AccessKey secret used to interact with OSS when reading a trajectory. ST_SetAccessKey
    ST_SetAKID function The ST_SetAKID function sets the AccessKey ID used to interact with OSS when reading a trajectory. ST_SetAkId
    ST_SetAKSecret function The ST_SetAKSecret function sets the AccessKey secret used to interact with OSS when reading a trajectory. ST_SetAkSecret
    ST_SetStorageLocation function The ST_SetStorageLocation function sets the storage location of the external file for a trajectory. ST_SetStorageLocation
    ST_DeleteGtf function The ST_DeleteGtf function deletes all exported trajectory files in a specified folder. ST_DeleteGTF
    Bug fixes Fixed an issue where string-based filtering failed when creating a vector pyramid.
    Fixed an issue that prevented QGIS from listing layers on connection.

    June 2021

    Minor version (V1.1.13)

    Category Feature Description References
    New feature I/O statistics in the polar_stat_sql and polar_stat_plan views
    • You can query different views to obtain resource information, which helps you locate performance issues.
    • This release introduces performance diagnostics for PolarDB for PostgreSQL (Compatible with Oracle), which includes instance-level and SQL performance analysis.
    • The polar_stat_sql and polar_stat_plan views are enhanced to include parameters for displaying I/O statistics.
    		 Performance views and performance diagnostics
    Elastic Parallel Query Elastic Parallel Query can now scan Block Range Indexes (BRIN), further improving query performance. Overview of Elastic Parallel Query
    This release adds the polar_bt_write_page_buffer_size parameter, which allows you to specify the write I/O policy for the index creation process. Use Elastic Parallel Query to accelerate index creation
    You can now specify the scope for Elastic Parallel Query at three levels:
    • System: Applies to all queries in all sessions.
    • Session: Applies to all queries in the current session.
    • Query: Applies to a specific query.
    		 Use Elastic Parallel Query for analytical queries
    Elastic Parallel Query now supports partitioned tables to improve database performance. Query data from partitioned tables
    Optimization Improved crash recovery based on RTO You can now configure the polar_crash_recovery_rto parameter to specify the desired Recovery Time Objective (RTO) for an instance. This ensures that in the event of a failure, the database can complete crash recovery and restore service within the specified RTO. N/A

    Ganos (V3.8)

    Category Feature Description References
    New feature ST_AsDatasetFile function Adds the ST_AsDatasetFile function, which returns a specified range of raster objects as a binary stream in a specified file format. ST_AsDatasetFile
    ST_RasterDrivers function Adds the ST_RasterDrivers function, which allows you to query the status of all raster data drivers. ST_RasterDrivers
    Fixed issue Fixed an issue where reprojection would fail when using the ST_Clip function to specify a spatial reference system.

    May 2021

    Minor kernel version (V1.1.12)

    Category Feature Description Related documentation
    New feature cross-node parallel execution Supports the cross-node parallel execution engine.
    • You can run SQL queries across multiple read-only nodes in a distributed manner to improve query performance for PolarDB for PostgreSQL (Compatible with Oracle).
    • You can use cross-node parallel execution to accelerate index creation and build indexes on large tables more efficiently.
    		 Cross-node parallel execution
    global indexes for partitioned tables Supports global indexes for partitioned tables. You can also build indexes concurrently, which means DML operations on the table are not blocked during index creation. Create a global index
    Improvement Performance monitoring Adds the max_slot_wal_keep_size parameter to limit the size of files that use a replication slot. This prevents Write-Ahead Logging (WAL) files from accumulating. None
    DBLink Unsafe Collate pushdown and ALL/ANY pushdown are now enabled by default to significantly improve query performance. You can disable these features by using the polar_enable_pushable_unsafe_collate_remote and polar_enable_pushable_all_any_remote parameters. Use DBLink to query data across databases
    Rownum Optimized Rownum to treat varchar2/text values as numeric types in comparisons. None
    polar_resource_group plug-in Adds parameters such as total_mem_limit_remain_size, idle_mem_limit_rate, enable_terminate_active, policy_mem_release, and enable_log to the polar_resource_group plug-in to prevent excessive memory usage from affecting database processes. None
    Faster startup for read-only nodes Improves the startup speed of read-only nodes. None
    failover Parallel replay accelerates database service recovery after a failover. In most cases, service is restored within 15 seconds of a primary node failure. None

    Ganos (V3.7)

    Category Feature Description Related documentation
    New feature spatiotemporal parallel query Supports parallel queries on a spatial index to improve query efficiency. Enable spatiotemporal parallel execution
    Improvement Raster image processing The ST_SubRaster function now supports raster pixel type conversion and pixel value stretching. It also supports converting multi-band remote sensing images to three-band images for AI recognition scenarios. ST_SubRaster
    Bug fix Fixed an issue where parsing invalid histogram information for rasters could cause the database to crash.
    Fixed an issue where the database could crash on exit after a reprojection operation.
    Fixed an issue where the database might crash during raster data import.

    April 2021

    minor version (V1.1.11)

    Category Feature Description References
    new feature idle_session_timeout parameter

    Adds the idle_session_timeout parameter, which sets the maximum duration for an idle session before it is terminated.

    • Value range: 0 to 2147483647

      The default value, 0, disables this feature.

    • Unit
      • 'ms': milliseconds (default)
      • 's': seconds
      • 'min': minutes
      • 'h': hours
      • 'd': days
    		 Configure parameters
    Constraint DDL Adds support for the ALTER TABLE ... ENABLE/DISABLE CONSTRAINT statement to enable or disable a constraint. ALTER TABLE ... ENABLE/DISABLE CONSTRAINT
    Tablespace DDL Adds support for tablespace-related DDL operations, such as CREATE TABLESPACE. None
    numeric data type Adds compatibility with the Oracle numeric data type. By default, this feature is disabled. To enable it, set the polar_enable_comp_numeric_format parameter by running the following command: 
    SET polar_enable_comp_numeric_format=on;
    		 None
    fixed issue Fixed an issue that prevented the use of the built-in DBMS_JOB package across databases.
    Fixed an issue preventing the use of the CONNECT BY clause with the ROWNUM function.
    Fixed an issue where the CONNECT BY clause could not find parent objects.

    Ganos (V3.6)

    Category Feature Description References
    new feature raster data type Adds the ST_RPCGeoreference function, which retrieves the rational polynomial coefficients (RPC) information from raster data. ST_RPCGeoreference
    Adds the ST_SetRPCGeoreference function, which sets the RPC information for raster data. ST_SetRPCGeoreference
    Adds the ST_RPCRectify function, which rectifies a raster object based on its RPC parameters and returns the rectified object. ST_RPCRectify
    GiST indexing Adds support for creating GiST indexes in parallel. Create spatial indexes in parallel
    fixed issue Fixed an issue where custom spatial references could not be exported when using the pg_dump utility.

    March 2021

    Minor version (V1.1.10)

    Category Feature Description Related documentation
    New partitioned table Partitioned tables now support BEFORE row-level triggers. BEFORE row-level triggers
    polar_outline plug-in Adds the polar_outline plug-in for adjusting execution plans and optimizing SQL statements. Adjust an execution plan
    Improved partitioned table INTERVAL RANGE partitioning now supports a subpartition template. Subpartition templates
    Performance optimization Improves data file read I/O performance by caching table size information in shared memory. N/A
    Compatibility The INTERVAL and FLOAT8 data types now support the following operators:
    • +
    • -
    • *
    • /
    		 N/A
    Compatibility Adds the OPT_PARAM HINT. You can use this hint to specify the values of specific parameters at the SQL level. OPT_PARAM Hints

    Ganos (V3.5)

    Category Feature Description Related documentation
    New Large object storage optimization Adds the Simple storage policy to optimize large object storage. Use the Simple storage policy
    Improved raster object When you update a raster object containing chunked data with another raster object, the system automatically deletes the chunked data from the original object. N/A
    Fixed Fixed an issue where Trajectory extensions could not be upgraded.
    Fixed an issue where resampling a raster object with the Average method sometimes caused an error.
    Fixed an issue where queries on a trajectory object could return incorrect results if multiple trajectory points shared the same timestamp.
    Fixed a geo-spatial object conversion failure that caused the system to exit. The system now provides a message indicating the failure cause.

    Minor version (V1.1.9)

    Category Feature Description Related documentation
    New partitioned table Adds INTERVAL RANGE partitioning, an extension of RANGE partitioning that automatically creates new partitions when inserted data exceeds the range of existing partitions. INTERVAL RANGE partitioning
    You can convert between RANGE partitioning and INTERVAL RANGE partitioning. Convert between RANGE and INTERVAL RANGE partitions
    Adds subpartition templates to simplify subpartition specifications. You can define descriptors once in a template and apply it to all partitions in a table for efficient subpartitioning. Subpartition templates
    AWR monitoring Adds the Automatic Workload Repository (AWR), a performance collection and analysis tool. AWR generates reports from statistics, such as dynamic views, to help you analyze database performance over a specified period. N/A
    Improved partitioned table Improves query performance on partitioned tables by enabling partition pruning optimizations during the planning phase. N/A
    data type In PolarDB for PostgreSQL (Compatible with Oracle), the Date data type uses microsecond precision. For compatibility with Oracle, which is accurate to the second for this data type, it is now automatically converted to timestamp(0). N/A
    WAL Improves overall system performance by optimizing WAL overhead with pipeline technology. N/A
    TO_CHAR The server now automatically identifies the format of TO_CHAR(text1, text2). If text1 is a valid date type and text2 is a valid date format, text1 is automatically processed as a timestamp. N/A
    Fixed Fixed an issue with unnecessary SIGHUP signals.
    Fixed a crash that occurred when using MERGE INTO on a partitioned table.
    Fixed an illegal memory access issue that occurred when pg_icu_collate_names was used.
    Fixed an illegal memory access issue that occurred when ALTER QUEUE ADD CALL was used.
    Fixed an illegal memory access issue in the POLICY system table, which occurred when a variable-length string was passed to the fixed-length rdname field.
    Fixed an issue in the TDE feature where undeclared functions caused their return value addresses to be truncated.
    Fixed an illegal memory access issue in the roaringbitmap plug-in caused by invalid input parameters.
    Fixed an issue that could interrupt the streaming replication connection. This occurred when a read-only node with significant replication lag failed to send timely feedback to the primary node.

    Ganos (V3.4)

    Category Feature Description Related documentation
    New Large object storage optimization Optimizes storage for geo-spatial objects to accelerate index creation and improve spatial query efficiency. This is achieved by using feature signatures for large geo-spatial objects and adding the polar_enable_storage_partial parameter to support combined in-row and out-of-row storage for geo-spatial objects. Feature signatures for large geo-spatial objects
    Parallel function execution in the raster module The ST_ImportFrom function now supports parallel import of raster data. ST_ImportFrom
    The ST_BuildPyramid function now supports parallel creation of a pyramid from raster data. ST_BuildPyramid
    Trajectory Empty Adds the Trajectory Empty object, which is returned when an operation's requirements are not met. N/A
    Fixed Fixed an issue where the ST_AddZ function could return incorrect results for 16-bit signed integer (16BSI) inputs.
    Fixed an issue that sometimes prevented the Trajectory module from being upgraded.
    Fixed an issue where some functions in the Trajectory module could not use indexes.
    Fixed an issue where some nd-functions incorrectly handled non-intersecting time periods, causing an error to be returned instead of false.

    January 2021

    Kernel minor version (V1.1.8)

    Category Feature Description References
    New feature DBMS_STATS plug-in Adds support for the DBMS_STATS plug-in. You can use this plug-in to collect statistics while the database is running, back up existing statistics, and restore statistics from backups. DBMS_STATS
    Read-after-write transaction splitting Now supports transaction splitting for read-after-write statements at the READ COMMITTED isolation level. This allows all read requests within a transaction to be sent to a read-only node, ensuring read-write consistency. Transaction splitting
    Optimized feature OR expressions This version enhances the OR to UNION ALL conversion. Previously, OR expressions were not automatically converted to UNION ALL, which often resulted in an inefficient full table scan. This optimization now performs the conversion automatically, significantly improving query performance. None
    ECPG compatibility
    • ECPGPlus is now compatible with parts of the Pro*C syntax.
    • ECPGPlus is now compatible with native Oracle connection methods.
    		 None
    Oracle compatibility The GROUP BY CONST/EMPTY clause is now compatible with Oracle. None
    PBP The persistent buffer pool is now enabled by default on the primary node. None
    Synchronization of partitioned tables to Kafka Optimized the configuration for synchronizing partitioned tables from PolarDB for PostgreSQL (Compatible with Oracle) to Kafka. You can now configure synchronization by the parent table's name, and the synchronized table in Kafka retains that name. None
    User creation The CREATE USER ... IDENTIFIED BY ... syntax now creates only standard users. Create a user
    Fixed issue Fixed an issue where deleting a task from a DBMS_JOB table without a primary key would cause an error during logical replication.
    Fixed a memory leak in resource group processes that occurred when memory usage exceeded the limit.
    Fixed an issue that caused long promotion times for standby nodes.
    Fixed a display issue with the temporary table parameter in the temporary field of ***_all_tables views.
    Fixed an out-of-bounds memory access issue in the audit log.
    Fixed an issue where query results were truncated when using a database link from PolarDB for PostgreSQL (Compatible with Oracle) to PostgreSQL.
    Fixed a defect in multi-key subpartition pruning for partitioned tables.

    Ganos (V3.3)

    Category Feature Description References
    New feature ST_JaccardSimilarity function Adds the ST_JaccardSimilarity function to calculate the similarity between trajectory objects. ST_JaccardSimilarity
    ST_Transform function Adds the ST_Transform function to transform a trajectory from one spatial reference system to another. ST_Transform
    Optimized feature Vector pyramid You can now specify a spatial extent when creating a vector pyramid. This change resolves an issue where the spatial extent could not be calculated automatically in some scenarios. None
    Fixed issue Fixed an issue where the Ganos data directory was set incorrectly in some environments.

    December 2020

    Minor version 1.1.7

    Category Parameter Description References
    New feature partitioned table Adds the Merge Partitions feature to merge two partitions.
    Compatibility with Oracle-style decoding Supports Oracle-style Base64 decoding. The BASE64_DECODE function automatically detects an invalid encoded string and decodes the valid prefix. polar_enable_base64_decode
    Date format Supports inserting or updating dates in the YYYYMMDDHH24MISS format. None
    SYS.***_TAB_COLS views Adds the SYS.***_TAB_COLS views to query all columns in tables and views.
    polar_utility plugin Adds the polar_utility plugin. polar_utility
    stored procedure Stored procedures can now return holdable refcursors. None
    DBMS_JOB package Adds the DBMS_JOB package. A privileged account can call this package or use it to schedule jobs across databases. DBMS_JOB
    Improvement UTL_ENCODE Newly created standard users can now use the UTL_ENCODE plugin. UTL_ENCODE
    polar_agg plugin The polar_agg plugin is now enabled by default. None
    fdw plugin Improved the stability of the fdw plugin. None
    Fixed issue Fixed an error that occurred when querying null values using SELECT INTO in a stored procedure.
    Fixed an issue where an index scan invalidated constraints after executing ALTER TABLE… EXCHANGE PARTITION.

    Console

    Category Parameter Description References
    New feature DBLink

    You can create a DBLink from PolarDB for PostgreSQL (Oracle Compatible) to a self-managed PostgreSQL database on an ECS instance to enable data communication from PolarDB for PostgreSQL (Oracle Compatible) to PostgreSQL. Combined with the DBLink feature in PostgreSQL, you can enable two-way data communication between the two databases.

    Path: On the cluster details page, choose Configuration and Management > Databases.

    Click the DBLink List tab, and then click Create DBLink to Self-managed Database.     		Create a DBLink from PolarDB for PostgreSQL (Compatible with Oracle) to PostgreSQL

    Ganos (V3.2)

    Category Parameter Description References
    New feature ST_AsPNG Vector pyramids can now return images as a stream for faster visualization of vector data. ST_AsPNG
    raster data Adds the JPEG2000 compression algorithm for raster data, supporting compressed storage of 16-bit raster data. None
    Improvement st_dwithin Improved the performance of st_dwithin distance queries. None
    Fixed issue Fixed an issue where time intersections were incorrect for the trajectory data type.
    Fixed issues in the Ganos memory topology index.

    API

    Category Parameter Description
    Improvement CreateDBLink Adds support for database links from PolarDB for PostgreSQL (Compatible with Oracle) to self-managed PostgreSQL databases on ECS instances.

    November 2020

    Kernel minor version 1.1.6

    Category Feature Description References
    New features Compatibility This minor version is compatible with PostgreSQL 11.9. What is PolarDB for PostgreSQL (Compatible with Oracle)?
    Primary/secondary switchover The OnlinePromote feature is enabled by default. This reduces high-availability (HA) switchover time and improves cluster availability. Automatic and manual primary/secondary switchover
    DBLink You can use a DBLink to connect to a database in another PolarDB for PostgreSQL (Compatible with Oracle) cluster. DBLink overview
    Fixed issues Fixed an issue where a node restart could hang in some scenarios.
    Fixed an issue where an out-of-memory (OOM) error could cause a cluster to crash in some scenarios.
    Fixed an issue where a read-only node could crash in some scenarios.
    Fixed a UTF-8 to GBK conversion error when running the client_encoding=gbk command.
    Fixed an issue where the NVL function returned an error when its first argument was null.

    Console

    Category Feature Description References
    New feature DBLink

    You can create a DBLink from a PolarDB for PostgreSQL (Oracle-compatible) database to another PolarDB for PostgreSQL (Oracle-compatible) database to enable cross-database data access and ensure data interoperability between different PolarDB for PostgreSQL (Oracle-compatible) databases.

    Path: On the cluster details page, navigate to Configuration and Management > Databases.

    		 DBLink overview

    API

    Category Feature Description
    New CreateDBLink Creates a DBLink for a PolarDB for PostgreSQL (Compatible with Oracle) cluster.
    DescribeDBLinks Queries information about DBLinks for a PolarDB for PostgreSQL (Compatible with Oracle) cluster.
    DeleteDBLink Deletes a DBLink from a PolarDB for PostgreSQL (Compatible with Oracle) cluster.

    October 2020

    Minor version (V1.1.5)

    Category Parameter Description References
    New Audit log The audit log now renders logs from precompiled SQL statements as executable SQL. None
    Hash partitioning Adds syntax to create a partitioned table with a specified number of hash partitions. CREATE TABLE ... PARTITION BY HASH
    Partitioned table You can now query data in a specific partition or subpartition by specifying its name. Query a specified partition
    HOST parameter Supports the HOST parameter for retrieving a client's HOST value. None
    Optimized View The polar_stat_activity view now includes the query_id field. None
    Compatibility The minor version has been upgraded to 11.8, which fixes several stability issues. None
    Fixed issue Fixed an issue where semi-synchronization failed to time out.
    Fixed an issue where using the CONNECT BY clause with the WITH clause would fail.

    Ganos (V3.1)

    Category Parameter Description References
    New Trajectory data type Ganos now supports GiST indexes on the trajectory data type, providing six operator families for multi-dimensional analysis. None
    Adds the BoxND spatio-temporal bounding box type for representing spatio-temporal ranges and storing trajectories. None
    Adds the intersection (&&), contains (@>), and contained by (<@) operators for multi-dimensional comparisons. None
    Adds four types of trajectory processing functions: ST_ndIntersects, ST_ndDWithin, ST_ndContains, and ST_ndWithin.
    Ganos can now collect statistics for the trajectory data type and estimate scan costs accordingly. None
    Introduces TrajGist, a new indexing method that provides better index selection. None
    ganos_update function Adds the ganos_update function. You can run the select ganos_update(); command to upgrade all Ganos plugins to the latest version. None
    Optimized Spatio-temporal range query The two-phase query process for GiST indexes has been improved, optimizing the performance of spatio-temporal range queries. None
    Vector pyramid Ganos now supports source data with any SRID and provides tile output in both EPSG:3857 and EPSG:4326. None
    The pixelSize parameter is now available to aggregate point data and reduce the tile count. None
    Fixed issue Fixed an issue where updating a Ganos Raster could fail under certain conditions.
    Fixed an issue that caused crashes when upgrading Ganos binary files.
    Fixed an issue causing top-level tiles to contain excessive data when building vector pyramids from point data with default parameters.

    September 2020

    minor version (V1.1.4)

    Category Parameter Description Related documentation
    New features GROUP_ID function Adds the GROUP_ID() function. GROUP_ID
    Partitioned table Supports concurrent index creation on a partitioned table using the CREATE INDEX CONCURRENTLY statement. None
    Invisible table index Supports making a table index invisible using the ALTER INDEX [NAME] INVISIBLE statement. None
    ali_decoding plugin Adds the ali_decoding plugin to incrementally synchronize DML statements between databases. None
    pg_cron plugin Supports querying scheduled task records using the pg_cron plugin. PG_CRON
    to_char() The to_char() function accepts string arguments. None
    Data type Adds the following operators to compare the prid_ type of ROWID with string data types such as text:
    • <
    • <=
    • >
    • >=
    • =
    • <>
    		 None
    View Adds views that provide process status information. None
    Adds views that provide execution time statistics for SQL statements. None
    Audit log Audit logs now include failed SQL statements. None
    Bug fixes Fixed an issue where data page prefetching could cause a deadlock in specific scenarios.
    Fixed an issue where a JOIN query could not find the correct partition during partition pruning.

    Ganos (V3.0)

    Category Parameter Description Related documentation
    New features Support for NetCDF data with subsets Supports importing Network Common Data Form (NetCDF) files that contain subsets by layer name. None
    Custom metadata and time series for raster data Adds the ST_MetaItems function to retrieve the names of all custom metadata items. ST_MetaItems
    Adds the ST_MetaData function to retrieve custom metadata items and return them in JSON format. ST_MetaData
    Adds the ST_SetMetaData function to set metadata items. ST_SetMetaData
    Adds the ST_BeginDateTime function to retrieve the start time of raster data. ST_BeginDateTime
    Adds the ST_EndDateTime function to retrieve the end time of raster data. ST_EndDateTime
    Adds the ST_SetBeginDateTime function to set the start time of raster data. ST_SetBeginDateTime
    Adds the ST_SetEndDateTime function to set the end time of raster data. ST_SetEndDateTime
    Adds the ST_SetDateTime function to set the start and end times for raster data and the acquisition time for a band. ST_SetDateTime
    Stream-based image format for raster data Adds the ST_AsImage function to return a raster as a stream-based image. ST_AsImage
    Adds the ST_AsPNG function to return a raster as a stream-based image in PNG format. ST_AsPNG
    Adds the ST_AsJPEG function to return a raster as a stream-based image in JPEG format. ST_AsJPEG
    GeomGrid data type and operations Adds the GeomGrid data type. GeomGrid SQL reference
    Adds the ST_AsText function to convert GeomGrid data to its text representation. ST_AsText
    Adds the ST_AsGeometry function to convert GeomGrid data to a geometry data type. ST_AsGeometry
    Adds the ST_AsBinary function to convert GeomGrid data to a binary data type. ST_AsBinary
    Adds the ST_AsBox function to convert GeomGrid data to a BOX data type. ST_AsBox
    Adds the ST_AsGrid function to compute the corresponding GeomGrid data for a geometry object. ST_AsGrid
    Adds the ST_GridFromText function to convert a text-based grid representation to the GeomGrid data type. ST_GridFromText
    Adds the ST_GridFromBinary function to convert a binary-based grid representation to the GeomGrid data type. ST_GridFromBinary
    Adds the ST_Intersects function to determine whether a GeomGrid object intersects with a geometry object. ST_Intersects
    Adds the ST_Contains function to determine whether a GeomGrid object contains another GeomGrid object or a geometry object. ST_Contains
    Adds the ST_Within function to determine whether a GeomGrid object is within another GeomGrid object or a geometry object. ST_Within
    Fast display and storage for vector data Adds the ST_BuildPyramid function to create a vector pyramid. ST_BuildPyramid
    Adds the ST_DeletePyramid function to delete a vector pyramid. ST_DeletePyramid
    Adds the ST_Tile function to retrieve vector data in Mapbox Vector Tile (MVT) format. ST_Tile
    Bug fixes Fixed an issue where creating a pyramid could cause an out-of-memory (OOM) error in some scenarios.
    Fixed an issue where a moving object could not be created at the 2000-01-01 timestamp.
    Fixed an issue where ST_Intersection returned an incorrect sub-trajectory for a moving object in certain scenarios.
    Fixed an issue that could cause a crash during a Ganos upgrade.
    Upgraded PostGIS compatibility to version 2.5.4.

    August 2020

    Minor version (V1.1.3)

    Category Parameter Description References
    New feature View Adds views to display SQL execution statistics. None
    Adds views to display QPS statistics. None
    Adds views to display CGroup status information. None
    Privileged account Grants the SELECT permission on dba_* views to accounts with the polar_superuser role. None
    Fixed issue Fixed a display error in the polar_stat_io_info view.
    Fixed missing AWR system wait information.
    Fixed a pruning error for partitioned tables.
    Fixed a memory size calculation error for SLRU.
    Fixed an issue that caused read-only nodes to be rebuilt due to playback latency.

    Ganos (V2.9)

    Category Parameter Description References
    New feature Support for Cloud Optimized GeoTIFF (COG) files Adds support for the Cloud Optimized GeoTIFF (COG) file format, which allows you to read pyramid information from COG files. None
    ST_AddZ function Adds the ST_AddZ function to add a z-value to a geometry object based on the pixel value of raster data. ST_AddZ
    Enhanced spatial extent retrieval for raster objects Adds the ST_Extent function, which returns the spatial extent of a raster object as a BOX object. ST_Extent
    The ST_Envelope function now returns the spatial extent of a raster object as a geometry object. ST_Envelope
    The ST_ConvexHull function now returns the convex hull of a raster object as a geometry object. ST_ConvexHull
    The ST_Height function now returns the pixel height of a raster object. ST_Height
    The ST_Width function now returns the pixel width of a raster object. ST_Width
    Fixed issue Addressed a performance bottleneck with external raster data that used a 1×n chunk layout. You can now customize the chunk size by using storage options.
    Fixed inconsistent coordinate sorting in results from the ST_Values function when querying line objects in certain directions.
    Prevents the ST_BestPyramidLevel function from returning a negative value in some cases.
    Prevents the ST_BuildPyramid function from repeatedly creating a pyramid.
    Ensures that truncating a raster table also clears the corresponding chunk table.
    Fixed an issue where the ST_ExportTo function ignored the CreateOption parameter in some cases.
    The ST_ClearChunks function now correctly handles table names that contain mixed-case characters.
    Fixed cases where an overview could not be created for an external pyramid.
    You can now create an internal pyramid for a raster object that already has an external pyramid.
    Fixed incorrect statistical calculations for raster data that contains NaN values.

    July 2020

    Minor kernel version (V1.1.2)

    Category Parameter Description Related documentation
    New feature PIVOT syntax The PIVOT syntax now supports using an alias for a table or subquery. N/A
    ROWID pseudocolumn Now supports the ROWID pseudocolumn and the ROWIDTOCHAR/CHARTOROWID functions. N/A
    Built-in functions Now supports the LNNVL, DUMP, SYS_CONTEXT, USERENV, TZ_OFFSET, and VSIZE functions. N/A
    DBMS_JOB and DBMS_SCHEDULER Now supports DBMS_JOB and DBMS_SCHEDULER to manage job queues. N/A
    Temporary tables You can now write temporary table files to local storage, which significantly improves the performance of temporary table operations. N/A
    Event triggers Accounts with the polar_superuser role can now create logical subscriptions to event triggers. N/A
    Custom resource isolation Custom resource groups can now initiate requests. N/A
    Optimization Crash recovery Optimized crash recovery to reduce recovery time in extreme scenarios. N/A
    Issue fix Fixed an issue where accounts with the polar_superuser role could not use the Index Advisor.

    Ganos (V2.8)

    Category Parameter Description Related documentation
    New feature Enhanced interfaces for accessing raster data metadata Adds the ST_XMin function to get the minimum X-coordinate of raster data. ST_XMin
    Adds the ST_YMin function to get the minimum Y-coordinate of raster data. ST_YMin
    Adds the ST_XMax function to get the maximum X-coordinate of raster data. ST_XMax
    Adds the ST_YMax function to get the maximum Y-coordinate of raster data. ST_YMax
    Adds the ST_ChunkHeight function to get the height of a raster tile. ST_ChunkHeight
    Adds the ST_ChunkWidth function to get the width of a raster tile. ST_ChunkWidth
    Adds the ST_ChunkBands function to get the number of bands in a raster tile. ST_ChunkBands
    ST_SrFromEsriWkt function Adds the ST_SrFromEsriWkt function to convert a spatial reference string from Esri WKT format to OGC WKT format. ST_SrFromEsriWkt
    Raster data type The raster data type now supports the Zstd and Snappy compression algorithms. N/A
    Point cloud data type The point cloud data type now supports binary copy. N/A
    Environment variables Now supports setting the PROJ_LIB and GDAL_DATA environment variables and deploying the relevant data. N/A
    Issue fixes Fixed an issue where an invalid OSS path could cause the database to crash.
    Fixed an issue where the SRID of some imported raster data was inconsistent with its definition.

    June 2020

    Kernel minor version (V1.1.1)

    Category Feature Description References
    New NVL2 function Added support for the NVL2 function. This function returns the second parameter if the first parameter is not NULL or an empty string; otherwise, it returns the third parameter. None
    polar_proxy_utils plug-in Added support for the polar_proxy_utils plug-in. You can use this plug-in to manage proxy-related features, such as configuring read-only UDFs and read-only tables. This allows you to use a cluster endpoint to route requests for read-only UDFs and read-only tables to read-only nodes. None
    polar_resource_group plug-in Added support for the polar_resource_group plug-in. You can use this plug-in to create custom resource groups and isolate resources by CPU and memory at the user, database, or session level. None
    Improved Reliability and availability Decoupled database compute nodes from the file system. This allows you to perform operations and maintenance on the file system independently, which significantly improves database reliability and availability. None
    Transaction processing Replaced the active transaction list snapshot with a monotonically increasing version number, significantly improving database transaction processing performance. None
    Execution plan Optimized the execution planner to prevent it from using stale statistics. None
    Fixed Fixed an issue where a process could crash when the timescaledb plug-in encountered an error while requesting memory.
    Fixed an issue where the I/O monitoring feature did not aggregate statistics after a process exited.
    Fixed a null pointer exception that could occur when lock_debug was enabled.
    Fixed an issue that could cause the pg_cron plug-in to become unavailable in specific scenarios.
    Fixed a known community issue related to a Distributed Shared Memory (DSM) deadlock.
    Fixed an issue where the number of user connections could exceed the limit.

    May 2020

    Minor version (V1.1.0)

    Category Parameter Description Related documentation
    New TO_SINGLE_BYTE function Converts multi-byte characters in a string to their single-byte equivalents. Full-width and half-width character conversion functions (TO_SINGLE_BYTE and TO_MULTI_BYTE)
    TO_MULTI_BYTE function Converts single-byte characters in a string to their multi-byte equivalents. Full-width and half-width character conversion functions (TO_SINGLE_BYTE and TO_MULTI_BYTE)
    REGEXP_LIKE function Performs pattern matching using POSIX-compliant regular expressions, similar to the LIKE conditional expression. None
    RATIO_TO_REPORT function Computes the ratio of a value to the sum of a set of values. None
    DBMS_UTILITY.FORMAT_ERROR_STACK function Returns layered stack and error information. None
    UTL_I18N.ESCAPE_REFERENCE and UTL_I18N.UNESCAPE_REFERENCE functions Escapes and unescapes HTML or XML characters. None
    INSERT ALL statement Inserts data into multiple tables in a single statement. None
    polar_concurrency_control plug-in Lets you set concurrency limits on transactions, SQL queries, stored procedures, and DML operations. You can also apply these limits to large queries to optimize performance in high-concurrency scenarios. None
    pldebugger plug-in Enables debugging of local stored procedures by using a client, such as pgAdmin4 4.19 or later. pldebugger (debugging stored procedures)
    oss_fdw plug-in Enables reading from and writing to Aliyun OSS by using external tables. The plug-in improves import/export performance through parallelism and compression, and can be used to implement tiered storage for hot and cold data. Use oss_fdw to read from and write to external data text files
    Enhancements ROUND function The ROUND function now supports the Interval parameter type and returns the number of days. ROUND
    polar_stat_activity view Added the wait_info and wait_time columns to the polar_stat_activity view to show what object a process is waiting for and for how long. None
    Index Improves insert performance for indexed tables by pre-extending index pages. None

    Ganos (V2.7)

    Category Parameter Description Related documentation
    New MD5 operation functions Retrieves the MD5 hash of a raster object. ST_MD5Sum
    Sets the MD5 hash for a raster object. ST_SetMD5Sum
    Authentication for spatial raster objects in OSS Retrieves the AccessKey ID of a raster object stored in OSS. ST_AKId
    Sets the AccessKey ID and AccessKey Secret for a raster object stored in OSS. ST_SetAccessKey
    Sets the AccessKey ID for a raster object stored in OSS. ST_SetAKId
    Sets the AccessKey Secret for a raster object stored in OSS. ST_SetAKSecret
    Spatial raster metadata operation functions Retrieves the pixel width of a raster object on the x-axis. ST_ScaleX
    Retrieves the pixel height of a raster object on the y-axis. ST_ScaleY
    Sets the pixel width and height of a raster object in the spatial reference system. ST_SetScale
    Retrieves the x-axis skew (rotation) of a raster object. ST_SkewX
    Retrieves the y-axis skew (rotation) of a raster object. ST_SkewY
    Sets the x-axis and y-axis skew (rotation) for a raster object. ST_SetSkew
    Retrieves the x-coordinate of the upper-left corner of a raster object. ST_UpperLeftX
    Retrieves the y-coordinate of the upper-left corner of a raster object. ST_UpperLeftY
    Sets the upper-left corner coordinates for a raster object. ST_SetUpperLeft
    Retrieves the width of a raster object in pixels. ST_PixelWidth
    Retrieves the height of a raster object in pixels. ST_PixelHeight
    Fixed issue Fixed an issue where using aggregate functions caused extension upgrade failures.