This topic describes the release notes for the minor versions, console, Ganos, and extensions of PolarDB for PostgreSQL.
You can execute the following statement to view the minor version of a PolarDB for PostgreSQL cluster:
SHOW polardb_version;The revision version numbers of PolarDB for PostgreSQL clusters changed to a 6-digit format on February 26, 2025 (UTC+8). For more information, see Change overview.
14.5.3.0
Minor version
Feature | Description | References | Release date |
New feature | You can manage parameters for specified instances. | N/A | December 2022 |
The oss_fdw extension is supported. You can use the oss_fdw extension to load data from Object Storage Service (OSS) to PolarDB for PostgreSQL and write data in PolarDB for PostgreSQL to OSS. | December 2022 | ||
The pgTAP extension is supported. The pgTAP extension is a unit testing framework for PostgreSQL written in PL/pgSQL and PL/SQL and a TAP testing framework of PolarDB for PostgreSQL. | December 2022 |
Ganos
Feature | Description | References | Release date |
New feature | This feature is added to convert GeoHash strings to INT-type values. | December 2022 | |
This feature is added to convert INT-type values to Geohash strings. | December 2022 | ||
This feature is added to update vector pyramids. | December 2022 | ||
This feature is added to configure a rule to update a vector pyramid. | December 2022 | ||
This feature is added to build a vector pyramid based on the size of the vector bounding box. | December 2022 | ||
This feature is added to perform spatial interpolation operations. | December 2022 | ||
This feature is added to generate contours. | December 2022 | ||
This feature is added to collect statistics on and analyze custom weights for raster data in MultiPoint mode. | December 2022 | ||
This feature is added to resample a trajectory. | December 2022 | ||
This feature is added to collect statistics on the density of a trajectory. | December 2022 | ||
This feature is added to identify the stay points of a trajectory. | December 2022 | ||
Fixed issue | The following issue is fixed: The raster object becomes empty after the ST_BuildHistogram function is called. | December 2022 | |
The following issue is fixed: Downtime and Z-value errors occur due to the null values of the ST_AsTable function. | December 2022 | ||
The following issue is fixed: Incorrect results are returned when the GeoHash mode is used for the ST_Split function. | December 2022 | ||
The following issue is fixed: Errors occur in attribute field encoding for the ST_Tile function. | December 2022 | ||
14.5.2.0
Minor version
Feature | Description | References | Release date |
New feature | The persisted buffer pool is supported to optimize the recovery time of databases. | November 2022 | |
The CSN log which is a new transaction snapshot mechanism is supported to improve MVCC performance. | N/A | November 2022 | |
The pg_sphere extension is provided to support spherical data types, compute functions, and operators for PostgreSQL. It is mainly used to solve the problem of how to represent points, lines, and planes on a sphere (for example, the earth), and calculate the distance or area between points, lines, and planes. | November 2022 | ||
The wal2json extension is provided to generate logical log files in the JSON format. | November 2022 | ||
The pg_bigm extension is added to create a 2-gram Generalized Inverted Index (GIN) that is used to accelerate full-text searches. | November 2022 | ||
Optimized feature | Pre-extension of data pages is supported in the index update phase to improve index performance. | N/A | November 2022 |
Buffer policies are optimized to prevent severe performance degradation in ring buffer scenarios. | N/A | November 2022 |
14.5.1.1
Minor version
Feature | Description | References | Release date |
New feature | SM4, AES-128, and AES-256 algorithms are supported for transparent data encryption. | N/A | November 2022 |
From the minor version of 14.5.1.1 (PostgreSQL 14), the default values of some parameters have been modified. The new default values are applicable only to newly purchased clusters and can significantly improve cluster performance. You can modify the default values in the console. | Release notes on modified default values for some parameters | November 2022 |
14.5.1.0
Minor version
Feature | Description | References | Release date |
New feature | Connection to the shared storage by using VFS interfaces is supported to optimize read-only replica nodes and transmitting only meta in stream replication. | N/A | November 2022 |
The flushing control feature is provided to prevent future pages from being written to the shared storage and maintain consistency LSNs for clusters. The feature also supports interaction by using the stream replication protocol, the dirty page list, parallel flushing, delayed flushing of hot buffers by using the copy buffer mechanism, and incremental checkpoints. | N/A | November 2022 | |
Logindex supports on-demand page replay, forced flushing of hot buffers by using fullpage, SLRU local cache, SLRU search complexity optimized to O(1), online promote, xlog buffer for replay acceleration, and parallel replay. | N/A | November 2022 | |
DDL statements are synchronized to ensure that files are not accessed by other nodes when DDL statements are executed on them. | N/A | November 2022 | |
Asynchronous lock replay is supported to prevent the primary replay process of the replica from being blocked by lock replay conflicts. | N/A | November 2022 | |
Read/write splitting supports smart proxying of PolarProxy. | N/A | November 2022 | |
The audit log display is optimized for readability of audit logs with SQL parameters. | N/A | November 2022 | |
GBK and GB18030 encoding modes are supported. | N/A | November 2022 | |
Streaming replication slots can be stored in the shared storage. | N/A | November 2022 | |
Lazy is supported to process sublinks. | N/A | November 2022 | |
POLAR_WAL is supported as an extensible WAL log type. | N/A | November 2022 | |
Static configuration files are supported to prevent accidental operations on configuration files. | N/A | November 2022 | |
Resource groups are supported to simplify management on application resources and cluster entities. | N/A | November 2022 | |
The polar_monitor extension is added to monitor the performance data of modules in PolarDB for PostgreSQL. | N/A | November 2022 | |
The polar_monitor_preload extension is added to monitor the performance data of modules in PolarDB for PostgreSQL. | N/A | November 2022 | |
The hll extension supports the HyperLogLog data type to estimate metrics such as page views (PV) and unique visitors (UV). | November 2022 | ||
The hypopg extension is added to check whether an index is useful for one or more queries. | November 2022 | ||
The pg_hint_plan extension is added to modify the execution plan by adding hints to SQL statements. | November 2022 | ||
The pg_wait_sampling extension is added to sample statistics for wait events. | N/A | November 2022 | |
The pgaudit extension is added to generate audit logs. Audit logs can be used to perform fault analysis and behavior analysis on the database and help you obtain the execution condition of data. | November 2022 | ||
The polar_io_stat extension is added to monitor detailed I/O-related performance data in PolarDB for PostgreSQL. | N/A | November 2022 | |
The polar_parameter_check extension is added to check parameter validity. | N/A | November 2022 | |
The polar_proxy_utils extension is added to store the mxs routing whitelist. | N/A | November 2022 | |
The polar_resource_manager extension is added to control memory usage and prevent out-of-memory (OOM). | N/A | November 2022 | |
The polar_stat_sql extension is added to monitor detailed SQL-related performance data in PolarDB for PostgreSQL. | N/A | November 2022 | |
The postgres-decoderbufs extension is added to decode WAL logs in the protobuf format. | N/A | November 2022 | |
The rum extension is added to implement fast full-text search. | N/A | November 2022 | |
The sequential_uuids extension is added to provide two sequential UUID generators and solve the random I/O problem caused by random UUID generators. | November 2022 | ||
The smlar extension is added to efficiently calculate data similarity in databases and provide similarity operators that support GiST and GIN indexes. | November 2022 | ||
The zhparser extension is added for Chinese full-text search. | N/A | November 2022 | |
Optimized feature | Pre-extension and read-ahead can be used to create indexes, load data and implement sequential scans. | N/A | November 2022 |
Audit logs are optimized to support multi-channel log output, reduce usage of memcpy, and change row buffering to full buffering. | N/A | November 2022 | |
The table file cache API is provided to improve runtime performance of databases. | N/A | November 2022 |
Ganos
Feature | Description | References | Release date |
New feature | Ganos 5.0 is supported. | November 2022 |