Engine release notes for AnalyticDB for PostgreSQL in elastic storage mode in 2025-AnalyticDB(AnalyticDB)-阿里云帮助中心

April 2025

Category	Feature	Description	Reference
New feature	Automatic data migration from Amazon Redshift	A data migration tool with DDL conversion support is now available to automate migration from Amazon Redshift to AnalyticDB for PostgreSQL.	Configure automatic data migration from an Amazon Redshift cluster to an AnalyticDB for PostgreSQL instance

Category	Feature	Description	Reference
Optimized feature	Auto-vacuum	Resource usage limits are now enforced on auto-vacuum to protect database performance and prevent business disruptions.	Use auto-vacuum
Optimized feature	Lineage analysis	Lineage analysis now supports the audit log format introduced in AnalyticDB for PostgreSQL V6.0. Structured log data is parsed more efficiently, enabling accurate tracking of data sources, table dependencies, and field-level data flows. This strengthens support for data governance, impact analysis, and security audits.	None
Fixed issue	External table	Fixed two issues: (1) An error that could occur when accessing ORC external tables, improving compatibility with external data sources and query stability. (2) An occasional connection failure when using the greenplum_fdw extension for cross-database queries, improving connection stability and fault tolerance.	None
	Vector search engine	Fixed a crash in the vector search engine: core dumps occurred when a vertex was deleted from a Hierarchical Navigable Small World (HNSW) graph due to memory access errors or graph structure inconsistencies.	Usage of the vector search engine
	Scale-up	Fixed several stability issues with scale-up.	None
	Transaction	Fixed an issue where `oldestxmin` stopped advancing because the VACUUM operation had no effect.	None

Category	Feature	Description	Reference
Optimized feature	GUC parameter	The `sr_plan.register_default_enable` GUC parameter is now supported, letting registered execution plans be enabled by default.	None
	Real-time materialized views	Mutable function support is extended for real-time materialized views. Time-related functions such as `now()` and `current_date()` are now supported.	Real-time materialized views
	pg_hint_plan extension	The pg_hint_plan extension can now check whether a table specified by a hint is empty before executing hash joins.	None
Fixed issue	Stability	Fixed an issue where the sr_plan extension caused core dumps in specific scenarios.	None