AnalyticDB for PostgreSQL - Supports Features Such as Backup, Restoration, and Parallel Query and Provides Some Optimizations and Fixes
Target customers: all AnalyticDB for PostgreSQL users. Features released: New features: AnalyticDB for PostgreSQL now supports the Laser engine, parallel query for individual tables, and sorting acceleration. By default, the Laser engine is enabled, and parallel query is enabled for individual tables. After you execute a SORT <tablename> statement, the system sorts the data of the specified table. Then, AnalyticDB for PostgreSQL pushes operators such as SORT down to the storage layer to accelerate queries based on the physical order of data. This feature can accelerate queries that contain SORT, AGG, and JOIN operators based on sort keys. AnalyticDB for PostgreSQL also supports backup and restoration for instances that have multiple coordinator nodes. Global User Configuration (GUC) parameters are supported to query the minor version of AnalyticDB for PostgreSQL by using the show adbpg_version statement. Optimized features: The performance of real-time materialized views is enhanced. The aggregate functions MAX and MIN can be used in DELETE and UPDATE statements. Common table expressions (CTEs) can be used in change statements executed on base tables. When coordinator nodes execute distributed transactions, each coordinator node directly generates distributed transaction IDs instead of requesting these IDs from the global transaction manager (GTM). This eliminates single-point bottlenecks of the GTM and improves distributed transaction performance in the event of highly concurrent queries. Fixed issues: The issue that may cause deadlock detection failures when more than two distributed transactions are initiated in the same session of a secondary coordinator node is fixed.