2022

Category

Feature

Description

References

New feature

Sample dataset

AnalyticDB for PostgreSQL V7.0 provides sample datasets to help you quickly try out or test instances.

• Manage sample datasets

• Dataset information and example queries

orafce extension

Adds the orafce extension for compatibility with Oracle syntax and functions.

None

Incremental sort

Adds the incremental sort feature. This feature periodically checks the data status of tables, sorts new unordered data, and merges it with existing ordered data.

None

Locale

Adds the zh_CN locale to support the Chinese character set.

None

zhparser extension

Adds the zhparser extension for Chinese word segmentation in full-text searches.

Zhparser

Full-text search

Full-text search now supports range distance-related functions.

None

Optimized feature

Query performance

Adjusts some performance metrics to optimize query performance.

None

Fixed issue

Fixes an issue where tasks such as vertical scaling prevented rdssuper connections from closing properly.

Fixes an issue where inconsistent system tables caused exceptions in DTS sync tasks.

Fixes an issue where reusing connections with uncleaned caches during concurrent writes caused catalog read exceptions.

Category

Feature

Description

References

New feature

[Real-time data warehouse] Real-time incremental materialized view capabilities

Real-time materialized views support real-time data writes, processing, and analysis. You can build an end-to-end real-time data warehouse with a single system.

Real-time materialized views

[Enterprise-grade feature] Stored procedure syntax support

Supports stored procedure syntax. This provides better compatibility with services from traditional data warehouses such as Oracle.

Stored procedures

[Enterprise-grade feature] Generated columns support

Supports generated columns. A generated column is a special column that is computed from other columns.

Generated columns

[Enterprise-grade feature] Window function enhancements

Supports all window functions in the SQL:2011 standard to help businesses perform multi-dimensional analysis.

Window functions

[Security feature] Password encryption algorithm enhancements

Supports SCRAM-SHA-256 encryption, which provides higher security than MD5 encryption.

Password and SSL security enhancements

[Security feature] Row-level permission management

Row-level permissions allow for data encryption at the row level. This helps minimize access to sensitive data.

Row security policies

[Feature enhancement] Aggregate function reuse

Reuses calculations for aggregate functions across multiple columns. This greatly reduces computation time and resource usage.

Aggregate functions

[Feature enhancement] Partitioned table feature and performance enhancements

Provides more comprehensive and higher-performance partitioned table tools to improve user experience.

Partitioned tables in AnalyticDB for PostgreSQL V7.0

[Feature enhancement] Column statistics support

Supports specifying collection targets to improve the accuracy of cost estimation and increase query performance.

Column group statistics

[Feature enhancement] JSON

Supports more JSON type functions.

JSON functions and operators

[Feature enhancement] Support for more index types

Adds Hash, BRIN, and Bloom indexes. Optimizes B-tree, GIN, Gist, and Bitmap indexes.

CreateIndex - Create an index

[Performance improvement] Just-in-time (JIT) compilation

Supports just-in-time (JIT) compilation. The system uses JIT technology to improve query performance.

Performance tuning