New Features in 9.1.1.x

9.1.1.100 (July 2025)

Flexible structure

1. Elastic VWs support the Analyze function, reducing the pressure on the primary VW and improving system scalability.
2. The execution capability of elastic VWs is enhanced. The job routing is more flexible and resource management and control mechanisms are more diversified (except index point query and short query scenarios).

Real-time analytics

1. Hybrid row- and column-store (HStore Opt) tables are supported. The performance of full-field point query is improved by 3 to 5 times, which indirectly implements row-store compression.
2. The HStore engine enable the Light Update capability. In the scenario where some columns of a wide table are updated, the import performance is improved by more than three times, which is ahead of similar products. The query performance is affected by less than 20%, and the final data consistency is ensured.
3. The Copy mode supports volatile temporary tables, which are not recorded in Xlogs. This further improves the performance of batch import.
4. The timeliness of Autovacuum is greatly optimized. The delta tablespace expansion of the HStore engine can be controlled within 1x.
5. Binlog supports HStore Opt V3 tables (decoupled storage and compute) and partial update.
6. Binlog optimizes the export and reverse query logic, full synchronization overhead between CNs and DNs, and auxiliary tablespace clearing logic. The performance is improved by about 30%, and the auxiliary tablespace is reduced by about 35%.
7. Direct import of connected DNs to the database supports the consistent hashing algorithm. This function has been integrated into dws-connector.
8. The COUNT(DISTINCT ...) SQL statement is often automatically optimized or rewritten to use a built-in UNIQ function.
9. The filter pushdown supports numeric types (such as INT), greater than (>) and less than (<) expressions. The overall performance is improved by 20%, and the performance in advantageous scenarios is improved by 3 to 5 times.
10. The allmeet quick filtering of roughcheck of CU improve performance by 35%.

High availability

1. Detection for subhealth scenarios such as network delay and packet loss is added. When such a sub-health scenario occurs, a primary/standby switchover can be triggered in a timely manner, improving system reliability.
2. Data on the secondary and standby nodes can be automatically dumped to OBS, preventing full disk space in fault scenarios.
3. Data can be exported using foreign tables and the performance in Parquet is optimized to be the same as that in ORC.

High security

1. The operations of adding, deleting, and modifying audit logs are optimized. Audit items such as insert overwrite and exchange partition are added.
2. A new mechanism is used for dumping audit logs to OBS to prevent partial loss in extreme scenarios.

Lakehouse

1. The interconnection of foreign table analysis statistics is optimized, and the date type is supported.
2. The partition pruning capability of foreign table queries is enhanced. There are directory pruning, metadata service pruning, and partition information pruning.

O&M and monitoring

1. V3 tables (with indexes) and Delta tables support online scale-out and redistribution with no downtime. The constraints are the same as those of V2 tables. For details, see Scaling Out a Cluster.
2. The query filter supports the blacklist function in SQL hash mode.
3. Based on the existing rules, the query filter adds capabilities such as resource pool switchover, concurrency control, and traffic limiting configuration to optimize the flexibility of filtering abnormal SQL statements.
4. Plan Management supports skew hints.
5. The expiration time is added to gs_view_invalid.
6. The TopSQL view displays the reasons that jobs cannot be routed to the elastic logical clusters. The new view displays the number of statements that are executed in each logical cluster.
7. The resource pool management in whitelist is optimized. The full match mode is supported. The SELECT 1, SHOW, DISCARD, COMMIT, and ROLLBACK statements are enabled.
8. The partition statistics are optimized, and the execution time is combined, doubling the performance.
9. VACUUM FULL and concurrent services can share locks with each other. The lock priority can be identified, and lock operations can be refined by transaction block.
10. The lock waiting mechanism is optimized for the scheduling of auto-increment partitions. This solves the lock timeout problem when partitions are automatically added or deleted. The management plane provides the service priority configuration capability.
11. The intelligent O&M scheduler optimizes the scheduling sequence of the automatic vacuum full tables to resolve disk overload issues, such as automatic abandonment when the disk space is insufficient during vacuum full, and unprocessed dirty pages, small CUs, cold partitions, or OBS tables.
12. The lwlock lock view is added to allow you to view the lock holding and waiting status in real time. The common lock time information is added.
13. V3 tables can be autovacuumed across VWs. It means that resources of the primary VW are not occupied.
14. Non-PCK tables can trigger asynchronous sorting, which replaces the small CU merge function.

Others

User-defined objects are not cascadingly deleted during the upgrade.