TencentDB for PostgreSQL

Powerful computing performance and geographic information processing capabilities that are ideal for OLTP scenarios with complex enterprise-grade SQL processing

Overview

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.

Benefits

Powerful Functionality

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.

Excellent Performance

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.

Convenient Management

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.

Features

TencentDB for PostgreSQL is an advanced, secure and scalable database hosting service.
Easily Managed Deployment

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.

Scenarios

Enterprise Core Applications

Corporate systems for ERP, trading, finance, funds and client information have high data security requirements and complex business logic. TencentDB for PostgreSQL can be used for underlying data storage for such systems, not only helping you provide high availability under the premise of data consistency but also allowing you to use simple programming to implement complex business logic.

Applications with Location-Based Services

Applications such as large-scale games and O2O programs must be able to support viewing world maps, finding nearby stores and calculating the distance between two points. The additional support for geographic objects of PostGIS enables you to run location queries in SQL without requiring complex coding, helping you more conveniently streamline business logic, offer location-based services and increase user stickiness.

Data Warehouse and Big Data

TencentDB for PostgreSQL supports a greater variety of data types and features powerful computing capabilities, helping you build data warehouses or big data analytics platforms more easily for smoother business operations.

Website or App

TencentDB for PostgreSQL provides excellent performance and powerful functions to help effectively improve website performance and simplify the development.