TaxTMI 
TaxTMI 
TecentDB PostgreSQL will provide full support for PG 17
X X X X Extracts X X X X
X X X X Extracts X X X X
....ecentDB PostgreSQL will provide full support for PG 17<BR>PTI News<BR>Dated:- 24-4-2025<BR>PTI<BR>SHENZHEN, China, April 24, 2025 /PRNewswire/ -- TencentDB for PostgreSQL has implemented comprehensive security measures, such as data encryption, VPC isolation, and process monitoring, to ensure alignment with international compliance standards. Core Capability Upgrades in PostgreSQL 17.0 Enhanced ....
X X X X Extracts X X X X
X X X X Extracts X X X X
....Logical Replication • Supports logical replication slot failover, retaining slots during major version upgrades (via 'pg_upgrade') to improve data synchronization reliability. Performance Optimizations • Optimized batch I/O page read/write for higher efficiency. • Improved WAL (Write-Ahead Logging) write performance under high concurrency. • VACUUM adopts a new memory management mech....
X X X X Extracts X X X X
X X X X Extracts X X X X
....anism, enhancing performance while reducing memory consumption. Operational Enhancements • 'pg_basebackup' now supports incremental backups, reducing storage and time costs. • Added 'transaction_timeout' parameter to enable transaction timeout termination, preventing long-running transaction blocks. Tencent Cloud Self-Developed Features & Scenario-Specific Solutions Fine-Grained Multi-Te....
X X X X Extracts X X X X
X X X X Extracts X X X X
....nant Resource Management • Resource Isolation: Precisely controls CPU resources at the `database` level, supporting dynamic configuration adjustments (add/delete/upgrade/downgrade). • Process-Level Monitoring: Real-time monitoring of tenant processes' CPU/memory usage via the 'tencentdb_process_system_usage' view, aiding health assessment. • SQL Throttling: Limits real-time SQL concurren....
X X X X Extracts X X X X
X X X X Extracts X X X X
....cy based on SQL statements or 'queryid' to prevent resource abuse. Cold/Hot Data Separation Solutions • Option 1: Leverage the self-developed 'cos_fdw' plugin to transparently access cold data (e.g., archived data) stored in COS, achieving storage tiering. • Option 2: Integrate the 'starocks_fdw' plugin to connect with the StarRocks analytics engine, enabling cold data storage on-premises ....
X X X X Extracts X X X X
X X X X Extracts X X X X
....or in object storage while unifying TP+AP capabilities. Enterprise-Grade Security Auditing • Express Edition: Meets basic auditing needs with high performance. • Advanced Edition: Enhances the 'pgaudit' plugin, expanding audit coverage to function execution, object types/names, etc., with performance surpassing native PG full-log auditing. Business Value • Balanced Performance & Cost: ....
X X X X Extracts X X X X
X X X X Extracts X X X X
....Cold/hot separation reduces storage costs while supporting hybrid HTAP workloads on a single node. • Maximized Resource Efficiency: Precise resource control in multi-tenant scenarios ensures high utilization and stability. • Strengthened Compliance: Flexible auditing modes adapt to varying security requirements, with significant performance advantages in stress tests. (Disclaimer: The ab....
X X X X Extracts X X X X
X X X X Extracts X X X X
....ove press release comes to you under an arrangement with PRNewswire and PTI takes no editorial responsibility for the same.). PTI PWR PWR<BR> News - Press release - PIB....