Powerful computing performance and geographic information processing capabilities that are ideal for OLTP scenarios with complex enterprise-grade SQL processing
TencentDB for PostgreSQL enables you to easily set up, operate and scale PostgreSQL in the cloud, the most powerful open-source database on the market. Tencent Cloud takes care of most of the complex and time-consuming administrative tasks such as PostgreSQL software installation, storage management, high-availability replication and data backup for disaster recovery, allowing you to focus on business program development.
Over the past few years, PostgreSQL has become the first choice for open-source relational database for commercial use. Based on SQL, TencentDB for PostgreSQL supports unstructured data types such as JSON, XML and Key-value and a variety of SQL syntaxes and functions. In addition, it leverages synchronous replication technology to achieve commercial-grade strong data consistency.
As a high-performance database ideal for OLTP and OLAP scenarios, TencentDB for PostgreSQL has a query optimizer comparable to that of commercial databases to support all mainstream types of multi-table join queries. It is capable of processing up to 100,000 queries per second based on PCI-E SSD storage, enabling you to support more concurrent requests with less databases.
PostgreSQL supports a complete set of default operations such as backup, recovery, monitoring and migration. You can manage conveniently with just a few clicks in the Tencent Cloud Console. A large number of performance views offer visibility into the performance of currently running SQL, current lock wait, table scan, index scan and other items, helping you locate performance issues faster and with more accuracy.
Tencent Cloud enables you to launch a PostgreSQL instance and connect it to applications in just a few minutes without additional configuration required. The default settings have universal parameters that can be modified in the console in real time, eliminating complicated installation and configuration and improving your OPS efficiency.
TencentDB for PostgreSQL is equipped with PostgreSQL's key operational performance metrics, including CPU utilization, storage capacity usage and I/O activities, which can be viewed in the console free of charge to help you troubleshoot quickly. Custom alarm thresholds for metrics notify you of exceptions via email or SMS, freeing you from around-the-clock monitoring.
TencentDB for PostgreSQL stores data in PCI-E SSDs that can process at least three times the QPS compared with SATA hard drives. It provides you with a default one-master-one-slave deployment scheme and enables synchronous replication, ensuring your business continuity and avoiding data confusion and loss.
The cluster scheduler automatically attempts to recover a node as soon as it fails, so when serious problems occur to your data, the data can be quickly restored to a previous point in time for failure upgrade and disaster recovery. Manual data recovery can also be performed with the backup function offered in the console. For details, please go to Console. TencentDB for PostgreSQL provides multiple default layers of security protection for each database which do not need to be purchased separately.
One-click scale-up can be performed in the Tencent Cloud Console without the need for additional operations. The scaled-up instance inherits the IP and all settings of the original instance. The service gets interrupted for only one second during the scaling process, eliminating prolonged downtime and meeting your business elasticity needs any time. If an existing PostgreSQL database is insufficient to support your business, it can be easily scaled to an unlimited capacity to serve massive volumes of end users with few or no changes to your business required.
TencentDB for PostgreSQL boasts high performance and powerful features. It supports custom functions, JSON and XML data formats, and full-text search, helping you reduce initial development costs, optimize website performance, and speed up the development process.
Games and O2O applications generally have features such as maps, nearby searches, and distance calculation. PostGIS supports geographical objects and efficient spatial indexing, allowing you to run location queries using SQL with no complex coding required. TencentDB for PostgreSQL helps you straighten out business logic with ease and implement LBS services conveniently to improve user stickiness.
Core Enterprise Applications
Core enterprise systems such as ERP, transaction systems, and financial systems contain monetary and customer information and thus demand high data security and complex business logic. TencentDB for PostgreSQL can ensure strong transactional consistency and is fully ACID-compliant. It supports the highest level of serializable isolation, helping you achieve high availability with guaranteed data consistency and build complex business logic with simple coding.
Data Warehouse and Big Data
A primary goal of modern enterprises is to maximize the value of data. TencentDB for PostgreSQL supports a wide range of data types, window functions, CTE/CUBE advanced analytics, external data source plugins, and TB-level large tables. It features efficient multi-table correlation and parallel query optimization, enabling you to build data warehouses and big data analytics platforms with ease to facilitate your business operations.