CloudDB for PostgreSQL
A powerful database ideal for handling complex SQL processing in OLTP workloads
Overview
Benefits
Features
Scenarios
Overview
CloudDB for PostgreSQL enables you to easily configure, use, and scale PostgreSQL, one of the most powerful open-source databases, on the cloud. Cloud takes care of 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. CloudDB 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
CloudDB 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
CloudDB 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 Console. You can also view performance metrics such as ongoing SQL queries, current lock waits, table scans, and index scans in the console.
Features
Managed Deployment
You can launch a CloudDB 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.
Monitoring and Alarming
CloudDB for PostgreSQL provides key operational metrics for PostgreSQL databases for free, including performance monitoring data such as CPU utilization, storage utilization, and disk I/O. You can view them in the console to quickly locate and resolve issues.
Enhanced Performance
10 times that of SATA by using NVMe SSDs, helping you meet high concurrence requirements. To ensure high availability, it features a primary/standby deployment mode and enables sync replication by default.
Multiple Layers of Security Protection
The cluster scheduler feature of CloudDB for PostgreSQL will automatically restore a node when it fails to a previous point in time for failover and disaster recovery. In addition, backups in the console can be used for manual data restoration.
Scalability
The CloudDB for PostgreSQL instance configuration can be modified in the Console to meet your elastic business needs with no additional configuration needed. After scaling, new instances will inherit the IPs and settings of the original instances, and the business will be interrupted for a second.
Scenarios
Website/App Development
CloudDB 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, and optimize website performance.
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
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.
Data Warehouse and Big Data
A primary goal of modern enterprises is to maximize the value of data. CloudDB for PostgreSQL supports a wide range of data types, window functions, CTE/CUBE advanced analytics, external data source plugins, and TB-level large tables.