Powerful Features
Over the recent years, PostgreSQL has become the go-to open-source relational database for commercial use.
PostgreSQL is fully open-source under the PostgreSQL License, similar to BSD and MIT open-source licenses. It can be used for various commercial purposes, distribution, and secondary development based on PostgreSQL. This means there are no restrictions on using PostgreSQL.
PostgreSQL supports C, C++, Java, PHP, Python, Perl, and other programming languages, making the development of your business easier and faster.
PostgreSQL is the best open-source alternative to Oracle in terms of architecture, syntax, and data types.
PostgreSQL is compatible with the SQL:2003 standard and supports the main features of SQL:2011.
PostgreSQL supports the traditional SQL LIKE operator, the more recent SQL:1999 SIMILAR TO operator, and POSIX-style regular expressions.
PostgreSQL supports rich data types, including geometry, network address, XML, JSON, RANGE, and array.
PostgreSQL supports complex types (custom data types).
PostgreSQL supports complex multi-table joins and join algorithms such as hash joins and merge joins.
PostgreSQL supports window functions, enabling real-time complex analysis and processing of database data. This is useful for tasks such as market analysis, generating financial reports, and creating plans in daily business operations.
PostgreSQL supports function indexes, partial (row) indexes, custom indexes, and full-text indexes.
PostgreSQL features a multi-process architecture that makes it more stable, so that a single PostgreSQL database can achieve a high throughput.
PostgreSQL supports powerful, high-performance extensions. For example, PostGIS is a database extension for geo-spatial data and provides additional support for geographic objects, allowing you to run location queries with SQL.
PostgreSQL provides strong data consistency required for commercial use. With synchronous replication, it guarantees zero data loss and is even suitable for financial trading systems.
High Performance
PostgreSQL achieves high performance in OLAP or OLTP scenarios.
PostgreSQL provides query optimizers comparable to those of commercial databases. It also supports common multi-table join queries (such as nested loop joins, hash joins, and sort-merge joins). For example, the performance of joining two tables, each with 100,000 rows, is 100 times faster than that of MySQL. With the capability of obtaining query results faster from more tables, you can make your analysis more accurate.
PostgreSQL uses NVMe SSDs as the storage media with a QPS as high as 230,000. You can support more concurrent business requests with fewer databases.
PostgreSQL supports a large number of performance profiles. You can view performance data such as the ongoing SQL queries, current lock waits, table scans, and index scans, which helps you quickly and accurately locate performance problems.
By optimizing the PostgreSQL kernel and enhancing the performance of built-in operators, TencentDB for PostgreSQL leverages high-performance NVMe SSD configurations to deliver at least ten times the QPS of SATA configurations. It provides a default deployment mode with one primary and one standby instance, enabling synchronous replication to ensure uninterrupted business operations and prevent data inconsistencies or loss.
Effortless Management
Tencent Cloud enables you to launch a PostgreSQL instance and connect it to your application within minutes, without any additional configuration. The default configuration has universally applicable parameters, which can be modified in real-time through the management console. This helps you avoid cumbersome and complex installation processes, improving your operational efficiency.
Convenient Monitoring
Key performance metrics for PostgreSQL, such as CPU utilization, storage capacity usage, and I/O activity, are provided at no additional cost. You can view these metrics in the management center to quickly identify and resolve issues. By customizing alarm thresholds for these metrics, you can stay informed about any anomalies through email or SMS notifications without constantly monitoring the system.
Scalable
You can effortlessly upgrade to the desired specifications through Tencent Cloud Management Center without any additional operations. The upgraded instance will inherit the original instance's IP and all configurations. During the upgrade process, there will only be a one-second disconnection during the switch, allowing you to meet your business's elastic needs without extended downtime. If your existing PostgreSQL still cannot support your business growth, you can accommodate an unlimited capacity and serve a massive user base with minimal or even no changes to your business operations.
High Assurance
Upon node failure, the cluster scheduler will immediately initiate automatic recovery attempts. In case of severe data issues, you can quickly restore to a normal point in time to handle upgrade failures, disaster recovery, and other situations. Multi-layered security protection is provided by default for each database in the cloud, without the need for separate purchases.