TencentDB for PostgreSQL

A powerful database ideal for handling complex SQL processing in OLTP workloads

Overview

TencentDB for PostgreSQL enables you to easily configure, use and scale PostgreSQL, one of the most powerful open-source databases, on the cloud. Tencent Cloud takes care of the complicated and time-consuming tasks, such as software installation, storage management, high-availability replication, and data backup for disaster recovery. You can then focus your energies on developing your applications and business growth.

Benefits

Powerful Features

Over the recent years, PostgreSQL has become the go-to open-source relational database for commercial use. TencentDB for PostgreSQL leverages the advantages of PostgreSQL to better support non-structural data types such as JSON, XML, and key-value based on SQL and a rich variety of SQL syntaxes and functions. In addition, with the sync replication technology, it can implement commercial-grade strong data consistency.

Best-in-Class Performance

TencentDB for PostgreSQL is suitable for high-performance OLTP and OLAP applications. It has a query optimizer comparable to that of commercial databases and supports all mainstream multi-table joins. Based on NVMe SSD storage, its maximum QPS can reach over 230,000, enabling you to process more concurrent business requests with fewer databases.

Convenient Management

TencentDB for PostgreSQL supports a complete set of solutions by default, including backup, restoration, monitoring, migration and more. These can be performed and managed easily in the Tencent Cloud Console. You can also view performance metrics such as ongoing SQL queries, current lock waits, table scan, and index scan in the console, keeping you updated on your resource statuses and enabling you to locate performance issues accurately and quickly.

Features

TencentDB for PostgreSQL is an easy to use managed database service that features high performance, availability, security, scalability.
Managed Deployment

You can launch a TencentDB for PostgreSQL instance and connect it to applications in minutes with no additional configuration required. The default configuration has universal parameters that can be modified at any time in the console. This eliminates laborious and complicated installation and configuration processes and improves your OPS efficiency.

Scenarios

Website/App Development

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.

LBS-enabled Applications

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 by 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.

Pricing

TencentDB for PostgreSQL is pay-as-you-go.

Pay-as-you-go is a postpaid billing mode suitable for businesses with demands that fluctuate greatly and instantaneously. You only need to pay for what you use with no upfront payment required.

For more information on billing, please see Pricing.