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 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 mechanism, 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-Tenant 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 concurrency 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 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: 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.
View original content:https://www.prnewswire.co.uk/news-releases/tecentdb-postgresql-will-provide-full-support-for-pg-17-302436769.html [https://www.prnewswire.co.uk/news-releases/tecentdb-postgresql-will-provide-full-support-for-pg-17-302436769.html]
Tencent CloudCONTACT: Lisa Ling, xiao.ling@bluefocus.com
