RDS for PostgreSQL

PostgreSQL is a powerful open-source relational database, with high reliability and data integrity. It is commonly used to power e-commerce, location-based applications, financial insurance systems, and complex data object processing.

Product Advantages
  • Multi-Plugin Support

    RDS for PostgreSQL supports multiple plugins and data types for fast, flexible data processing.

  • High Reliability

    Primary and standby DB instances with automatic failover can be deployed in different AZs for high reliability.

  • High Security

    RDS for PostgreSQL has been certified by TRUCS, CSA STAR, and ISO 27001, with Class 3 certification in Information Security Protection by China's Ministry of Public Security.

  • Comprehensive Monitoring

    Comprehensive monitoring allows you to monitor DB instance status and set alarm rules.

Application Scenarios
  • Location Applications

  • Research Projects

  • Financial Insurance

  • E-Commerce

Location Applications

Location Applications

RDS for PostgreSQL supports PostGIS and is the preferred choice for location-based applications. It provides spatial features including space objects, indexes, operation functions, and operators.

Advantages

Various Spatial Data

Supports various types of spatial data including points, lines, planes, grids, and three-dimensional data.

Efficient Spatial Analysis

Provides efficient spatial analysis functions and works with OBS to expand the space.

Simple Spatial Operations

Reduces the code complexity for location applications, making spatial operations easier.

Related Services

ecs

vpn

obs

Research Projects

Research Projects

RDS for PostgreSQL supports different forms of complex data and custom data types. It stores infrequently used data to OBS to save storage costs and space.

Advantages

Guaranteed Data Accuracy

Stores data accurately and uses a VPN to protect data privacy.

Supported Expression Indexes

Builds indexes on generic expressions rather than values or columns.

Custom Data Types

Easily and quickly processes custom data types.

Related Services

ecs

vpn

obs

Financial Insurance

Financial Insurance

RDS for PostgreSQL uses Multi-Version Concurrency Control (MVCC) to ensure data consistency and synchronizes data between primary and standby DB instances to ensure data integrity.

Advantages

MVCC

Modifications made to a transaction are not visible to other users, complying with the properties of Atomicity, Consistency, Isolation, Durability (ACID).

Low Synchronization Delay

The primary/standby synchronization delay is mere milliseconds, ensuring data consistency.

Related Services

ecs

vpn

obs

E-Commerce

E-Commerce

RDS for PostgreSQL is an excellent choice for its stability in SQL programming for Internet applications in high-concurrency scenarios.

Advantages

Excellent Performance

Maintains excellent performance in high concurrency and heavy load scenarios.

Simple Operating Environment

Analysis functions and recursive functions are embedded, greatly simplifying complexity of Internet application code.

Related Services

ecs

vpn

obs

Functions

  • Precise Processing

    Uses PostGIS to support 2D and 3D models, including space objects, indexes, operation functions, and operators.

  • Two Instance Types

    Provides both single and primary/standby DB instances to choose from.

Precise Processing

  • Various Spatial Data

    Supports various types of spatial data including points, lines, planes, grids, and three-dimensional data.

  • Simple Spatial Operations

    Reduces the code complexity for location applications, making spatial operations easier.

  • Efficient Spatial Analysis

    Provides efficient spatial analysis functions.

Two Instance Types

  • Single DB Instance

    Provides an easy and cost-effective way to run non-production workloads for testing and development.


  • Primary/Standby DB Instances

    Supports concurrent requests, high availability, and automatic failover in case of a primary DB instance failure.

  • Multi-Layer Protection

    Has obtained 14 international security compliance to ensure network security.

  • Professional Database O&M

    Provides a web-based management console, making it easy to manage, monitor, and operate DB instances.

Multi-Layer Protection

  • VPC

    Uses VPCs to isolate tenants and control access to DB instances.

  • Security Group

    Uses security groups to allow access from specific IP addresses and ports.

  • SSL

    Uses SSL to encrypt connections to DB instances, ensuring data security and integrity.

Professional Database O&M

  • Instance Management

    Provides a management console to for you to manage DB instances, logs, parameters, and backup data.

  • Visualized Monitoring

    Comprehensively monitors metrics to inform you of DB instance running status and enables you to set alarm rules.


Recommended Configurations

Basic

For development and testing of small websites and small- and medium-sized enterprises

Basic

For development and testing of small websites and small- and medium-sized enterprises

Configuration

  • Instance class 2 vCPUs | 4 GB
  • Max. QPS 9,400
  • Max. TPS 600
  • Max. connections 1,700
  • Max. capacity 4 TB

Scenarios

  • Testing
  • Research
  • Enterprise websites
  • Location applications
$0.12 USD/hour

Intermediate

For production databases of large- and medium-sized enterprises. Primary/standby DB instances are recommended.

Intermediate

For production databases of large- and medium-sized enterprises. Primary/standby DB instances are recommended.

Configuration

  • Instance class 4 vCPUs | 8 GB
  • Max. QPS 19,000
  • Max. TPS 1,300
  • Max. connections 2,400
  • Max. capacity 4 TB

Scenarios

  • Logistics
  • Monitoring
  • E-commerce gaming
  • Enterprise websites
$0.29 USD/hour

Advanced

For large- and medium-sized e-commerce and gaming enterprises. Primary/standby DB instances and read replicas are recommended.

Advanced

For large- and medium-sized e-commerce and gaming enterprises. Primary/standby DB instances and read replicas are recommended.

Configuration

  • Instance class 8 vCPUs | 32 GB
  • Max. QPS 26,000
  • Max. TPS 2,000
  • Max. connections 9,000
  • Max. capacity 4 TB

Scenarios

  • Finance
  • Internet
  • Research
  • Location applications
$1.10 USD/hour
Usage Guides

Coupon Packages of $1600 USD for New Customers

Register Now