tencent cloud

All product documents
TencentDB for PostgreSQL
DocumentationTencentDB for PostgreSQLRelease Notes and AnnouncementsAnnouncementsTencentDB for PostgreSQL's Full Support for PG17
TencentDB for PostgreSQL's Full Support for PG17
Download PDF
Last updated: 2025-01-06 10:01:30
TencentDB for PostgreSQL's Full Support for PG17
Last updated: 2025-01-06 10:01:30
Download PDF
TencentDB for PostgreSQL now fully supports PostgreSQL 17.0. All users can upgrade to the latest PostgreSQL 17.0 using the major version upgrade capability for an experience, or directly purchase it on the product purchase page. Based on the native PostgreSQL 17.0, TencentDB for PostgreSQL has a variety of self-developed kernels and control features added to help users easily cope with various scenario-based business needs.
Scenario of multi-tenant resource sharing
In this scenario, TencentDB for PostgreSQL offers a combination scheme: database resource isolation, real-time process resource monitoring, and SQL throttling. This scheme helps users maximize resource utilization while precisely controlling resource usage. The resource isolation capability of the database can precisely control the CPU resources used by tenants. This feature is implemented easily through kernel extensions, covering various capabilities such as adding configurations, deleting configurations, upgrading configurations, downgrading configurations, and querying. In terms of tenant monitoring, applications need not only the overall monitoring information of the database instance but also detailed process monitoring information within the instance to assess tenant health status and make real-time decisions on SQL restrictions. TencentDB for PostgreSQL provides the database process monitoring view tencentdb_process_system_usage, allowing applications to detect the CPU and memory usage details of multi-tenant processes in real time, thereby assessing the current health status of tenants. When certain multi-tenant scenarios occupy excessive resources and need restriction, SQL throttling can be used to limit the real-time concurrency of SQL based on SQL statements or queryid, achieving the purpose of overall resource monitoring and control.
Scenario of hot and cold separation
TencentDB for PostgreSQL offers two schemes for separating hot and cold data to help users save costs while maximizing support for single-server HTAP performance. The first scheme is based on the self-developed cos_fdw extension. Users do not need to worry about the access forms of different storage media. With the cos_fdw extension, data in COS can be loaded into PostgreSQL database tables and accessed like ordinary tables, achieving hot and cold storage separation. The second scheme utilizes the starocks_fdw extension, which not only introduces StarRocks' analytical capability, but also allows cold data to be stored locally in StarRocks or on object storage and easily connects TP and AP.
Scenario of enterprise-level security
For the audit feature which is a "rigid demand" of users, TencentDB for PostgreSQL supports both ultrafast and refined audit modes for PostgreSQL database instances. Ultrafast audit meets general audit requirements, while refined audit uses the pgaudit extension with optimizations and incorporates the audit of the execution function content, object type, and object name. In stress testing scenarios, the performance of both ultrafast audit and refined audit significantly exceeds the full-log audit of the native PG.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 available.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon