2023-AnalyticDB(AnalyticDB)-阿里云帮助中心

Engine release notes for AnalyticDB for PostgreSQL in Serverless mode, covering versions released in 2023. Each entry lists optimizations and bug fixes by category.

To apply a new version, update the minor engine version from the AnalyticDB for PostgreSQL console. See Update the minor engine version.

October 2023 (V2.1.1.2)

Category	Description
Query performance	Reduced the number of hash buckets when you create an instance. Reduced memory usage for bitmap index scans.
Archiving performance	Reduced disk usage for vacuum index operations.
Bug fixes	Fixed a service restart caused by a full cache. Fixed delta table management errors. Fixed resource queue errors during scaling.

October 2023 (V2.1.1.0)

Category	Description
Query performance	Reorganized delta table management and reduced the number of small files in base data to improve scan performance. Optimized memory usage and performance for bitmap index scans. Improved sequential scan performance. Optimized CPU utilization of DADI cache.
Import performance	Improved import performance for cloud-native indexes.
Archiving performance	Optimized auto-vacuum trigger conditions. Improved cloud-native table vacuum performance and fixed incorrect index reclamation.
SQL concurrency	Optimized ORC streams and added MMapContext to increase SQL concurrency.
Scaling performance	Improved scaling performance and fixed related issues.
Bug fixes	Fixed index interruption and rebuilding errors during scaling. Fixed PL/Java memory leaks. Fixed errors when reading ORC files that contain a double quotation mark (`''`). Fixed a memory leak in the flush scheduling module. Fixed DDL deadlocks caused by flush operations. Fixed visibility determination for index-only scans. Fixed data inconsistency caused by incomplete deletion of Data Transmission Service (DTS) task data.

May 2023 (V2.0.0.5)

Important

V2.0.0.5 fixes the CVE-2023-2454 vulnerability. We recommend that you update the minor version of your instance to V2.0.0.5 or later.

Category	Description
SQL execution performance	Improved single-statement execution performance under concurrent workloads, reducing total execution time.
SQL concurrency	Reduced per-statement memory consumption under concurrent workloads, allowing more statements to run in parallel.
ANALYZE	Optimized statistics collection via the ANALYZE statement. See Use the ANALYZE statement to collect statistics on AnalyticDB for PostgreSQL.
Bug fixes	Fixed the CVE-2023-2454 vulnerability. Fixed data loss during disk storage operations. Fixed false primary key conflict errors during concurrent data insertion.

April 2023 (V2.0.0.2)

Category	Description
Bug fixes	Fixed errors on flush, compact, and concurrent DDL operations during real-time data writes.

March 2023 (V2.0.0.1)

Category	Description
Real-time write and DTS	Added the delta table feature to support real-time write and DTS tasks. See Synchronize data from an ApsaraDB RDS for MySQL instance to an AnalyticDB for PostgreSQL instance in Serverless mode and What is DTS?.
Indexes	Added support for primary key indexes and secondary indexes.
Row-level data updates	Added support for concurrent row-level writes, updates, and deletes.
Bloom filter	Added Bloom filter optimization to improve query efficiency.
Bug fixes	Fixed syscache errors caused by memory hijacking when reading or writing ARRAY-type data.

February 2023 (V1.0.3.0 to V1.0.5.0)01月

Category	Description
Garbage collection	Released a new garbage collection implementation that significantly improves collection speed.
Manual instance pause and resume	Added support for manually pausing and resuming Serverless mode instances. Paused instances are not charged for compute resources. See Manually pause and resume an instance.
Sort scan	Added sort scan support for STRING-type fields.
NUMERIC precision	Removed the precision limit for NUMERIC-type fields.
Memory protection	Added support for the Laser memory protection parameter in Serverless mode instances. Laser is enabled by default.
Bug fixes	Fixed query errors after sort key-based memory accumulation tasks. Fixed errors when reading string data from Serverless mode instances. Fixed WHERE clause errors caused by excessive filter conditions. Fixed errors in SQL statements that include LIKE operators. Fixed scaling failures caused by lock wait timeout errors.