This topic describes the release notes for the minor versions, console, Ganos, and API of PolarDB for PostgreSQL and provides links to the relevant references.

Note You can execute the following statement to view the minor version that is used by PolarDB for PostgreSQL:
show polar_version;

The following table describes the version mappings between PolarDB for PostgreSQL and open source PostgreSQL.

PolarDB for PostgreSQL version Open source PostgreSQL version
v1.1.23 11.9
v1.1.22 11.9
v1.1.20 11.9

June 2022

Minor version 1.1.23

Category Feature Description References
New feature pg_hint_plan The pg_hint_plan plug-in allows you to add hints to change the execution plans of SQL statements. pg_hint_plan
New feature Performance optimization for resource manager memory release
  • New mem_release_policy parameter indicates the memory release policy. Default value: default. Valid values:
    • default: When the database thresholds are reached, resource manager starts the adaptive policy. This parameter cannot be combined with other parameters. The memory is released based on the default policy. Processes are divided into idle processes and active processes. Idle processes are first released and then active processes.
    • cancel_query: cancels queries of active processes.
    • terminate_idle_backend: terminates idle processes.
    • terminate_any_backend: terminates any processes.
    • none: takes no actions.
  • New total_memcontext_dump_rate parameter indicates the threshold for memory context output. Default value: 75. Valid values: 20 to 95. The parameter value takes effect after you restart the cluster or perform a reload operation.
  • New max_proc_mcxtdump_num parameter indicates the number of processes for memory context output. Default value: 1. Valid values: 1 to 100. The parameter value takes effect after you restart the cluster or perform a reload operation.
  • New interval_max_num parameter indicates the number of intervals for memory context output. Default value: 0. Valid values: 0 to INT32_MAX. The parameter value takes effect after you restart the cluster or perform a reload operation.
N/A

March 2022

Minor version 1.1.22

Category Feature Description References
New feature Analyze operation in parallel execution
  • The polar_px_enable_explain_allstat parameter is added to display the execution result (such as the number of tuples processed by each worker and the execution duration) of each worker when the explain analyze command is run in parallel queries.
  • The polar_px_explain_memory_verbosity parameter is added to display the memory usage of each worker when the explain analyze command is run in parallel queries. Valid values:
    • summary: the collective information of the memory usage of each worker.
    • detail: the detailed memory usage information of each worker.
N/A
Support for Clang Clang is supported. N/A

Ganos V4.6

Category Feature Description References
New feature Object storage paths Raster data can be accessed by using self-managed Multi-Cloud Object Storage (MinIO) servers. Object storage paths
ST_PointValues function The ST_PointValues function is added. It can be used to return the pixel values of all bands. ST_PointValues
Fixed issue The issue that causes incorrect band order when the ST_Clip function is executed is fixed.
The issue that causes low performance due to lack of primary key indexes during raster updates is fixed.
If trajectory failed to read data from OSS, it can try again.

Ganos V4.5

Category Feature Description References
New feature Ganos is supported for PostgreSQL 14. N/A
Optimized feature Cache for trajectory objects in external storage is increased to improve access performance. N/A
Fixed issue The issue that causes missing file suffixes when raster data is exported to OSS is fixed.
The issue that causes failed statistics on specific raster data is fixed.

January 2022

Minor version 1.1.20

Category Feature Description References
New feature Drop flashback You can use the drop flashback feature to quickly restore deleted tables and view and clear the recycle bin. Drop flashback
Multi-level partitioned tables in parallel execution You can use the parallel execution feature to query data from multi-level partitions in parallel. Use the cross-node parallel execution feature to query data from partitioned tables

Ganos V4.4

Category Feature Description References
New feature ST_LinearStretch function The ST_LinearStretch function is added to linearly stretch a raster and return a new raster. ST_LinearStretch
ST_BuildPercentiles function The ST_BuildPercentiles function is added to return the percentage of pixels for a set of raster bands. ST_BuildPercentiles
ST_ComputeStatistics function The ST_ComputeStatistics function is added to return the statistics of a raster object, including histograms and percentage. ST_ComputeStatistics
ST_Percentile function The ST_Percentile function is added to return the percentage of pixels for a raster band. ST_Percentile
Optimized feature Parallel computing The ST_SummaryStats and ST_BuildHistogram functions can be used to perform parallel computing. N/A
ST_ExportTo function The ST_ExportTo function returns false instead of an error message if the specified file already exists. N/A
ST_ImportFrom function If an import error occurs, the ST_ImportFrom function returns the details about the error. You can troubleshoot the error based on the error details. ST_ImportFrom
Fixed issue The issue where half a pixel is lost due to number rounding when a raster is cropped is fixed.
The issue due to which the data of a raster cannot be properly imported or collected if the data contains values such as NAN and INF is fixed.