The ApsaraDB RDS for PostgreSQL is an advanced open-source database that is compatible with SQL and supports various data types, such as JSON data, IP data, and geometry data. PostgreSQL supports basic features, such as transactions, subqueries, multi-version concurrency control (MVCC), and data integrity check. In addition to the basic features, PostgreSQL supports the high availability architecture and provides the backup and restoration feature to facilitate database operation and maintenance (O&M). PostgreSQL also provides the following advanced features and functions:
To guarantee stability and security, you must understand the limits of ApsaraDB RDS PostgreSQL as below:
The following figure shows the operations that you need to perform from purchasing an instance to using the instance.
Based on Alibaba Cloud's multi-zone architecture, the service supports local disaster recovery and ensures the security and stability of enterprise databases. Compared with other open source databases, PostgreSQL is a better choice for online transaction processing and shows better performance at JOIN queries involving multiple tables.
To expand your storage, you can store frequently used hot data in SSDs and use OSS to store cold data. You can also compress OSS data based on the standard GZIP algorithm to further reduce the storage cost. With AnalyticDB for PostgreSQL, you can expand your OLAP applications horizontally to provide better performance and more storage space.
JSON and GIS data types are essential for processing IoT transactions. In traditional solutions, developers and database administrators frequently use hardcoding when interacting with NoSQL databases and professional GIS analytical tools. With PostgreSQL, you can use SQL to perform operations on JSON and GIS data directly. This saves the trouble of data imports and significantly increases the development efficiency.
Known as "The world’s most advanced open source database", PostgreSQL enables OLTP databases that handle enterprise-level SQL statements, supports NoSQL data types such as JSON, XML and hstore, and supports GIS data processing.
This tutorial introduces the ApsaraDB Stack, part of Alibaba Cloud's wider suite of database services products, that will free you from the administrative tasks often associated with managing your corporate data.
Alibaba Cloud ApsaraDB for RDS (Relational Database Service) is a stable and reliable online database service that scales elastically.
Check for more information:
ApsaraDB - August 1, 2022
Alibaba Clouder - January 27, 2021
ApsaraDB - September 7, 2021
Alibaba Clouder - February 11, 2020
Alibaba Clouder - February 25, 2021
ApsaraDB - January 13, 2022
An on-demand database hosting service for PostgreSQL with automated monitoring, backup and disaster recovery capabilitiesLearn More
An online MPP warehousing service based on the Greenplum Database open source programLearn More
An on-demand database hosting service for MySQL, SQL Server and PostgreSQL with automated monitoring, backup and disaster recovery capabilitiesLearn More
An on-demand database hosting service for MySQL with automated monitoring, backup and disaster recovery capabilitiesLearn More
More Posts by Alibaba Clouder