Latest News
RDS for PostgreSQL 16 Has Arrived
Enhanced security, efficiency, and more
Learn More >
Upgrade RDS for PostgreSQL Major Version In One Click
You are allowed to upgrade from any version(since PG 10) to the latest with one click only if the disk type of your instance is cloud disk. Upgrade metrix:
PG 10 -> PG 11~16
Learn More >
Video: How to upgrade RDS PostgreSQL major version in just one click
Watch the video in 7 minutes and upgrade PostgreSQL seamlessly with no impact on your business.
More Video >
Hands-On Lab | Migrate User-Created PostgreSQL to ApsaraDB RDS for PostgreSQL through Cloud Migration
Learn More >
Best Practice | How to Build a Heat Map Tile App with Alibaba Cloud ECS & PostgreSQL/Ganos: A Step-by-Step Guide
Learn More >
Known as "the world’s most advanced open source relational 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.
Popular Scenarios
Discover what and how you can use our products to build >
BI
PostgreSQL BI Dashboard Toolkit
Streamline BI dashboard creation using Cube, React, and ApsaraDB RDS for PostgreSQL. Learn more >
- Plug-and-Play
- Simplified Management
- Smooth Integration
Product Used
ECS | ApsaraDB RDS for PostgreSQL
GIS
PostgreSQL GIS Heat Map Power Visual
Develop dynamic heat maps with geo-visualization and analytics on ApsaraDB RDS for PostgreSQL featuring Ganos. Learn more >
- All-Inclusive Features
- Superior Performance
- Fortified Security
Product Used
ECS | ApsaraDB RDS for PostgreSQL
Free Trials & Special Offers
See Special Offer Terms & Conditions for specifics and limitations.
ApsaraDB RDS for PostgreSQL Serverless
Scale automatically in seconds, only pay for actual usage, lower cost
50% OFF
PostgreSQL 14/15/16
Basic/High-Availability Edition
All Available Regions
ApsaraDB RDS for PostgreSQL
OLTP scenarios, GIS and other NoSQL data support.
Free
PostgreSQL 11~16 High-availability
pg.n2.2c.2m
2C4G, 20 GB ESSD PL1
ApsaraDB RDS for PostgreSQL
OLTP scenarios, GIS and other NoSQL data support.
Free
PostgreSQL 11~16 Basic
pg.n2.2c.1m
2C4G, 20 GB ESSD PL1
Benefits
-
NoSQL compatibility
Compatible with SQL:2011 and supports multiple data types, such as JSON and XML.
-
Multiple Extensions
Supports GIS data, cloud storage expansion, and Chinese text segmentation to make development easier.
-
Efficient Querying
Provides a cost-based SQL query optimizer that shows significantly better performance in multi-table queries than MySQL.
-
Secure and Stable
Supports SQL auditing and field permission control. Provides IP whitelists to prevent DDoS attacks.
Features
-
Easy Spatial Information Processing
With PostGIS extensions, the service supports 2D and 3D geographical data modelling, and recognizes the shifts caused by the irregular shape of the Earth to enable precise positioning that meets the OpenGIS standard.
Spatial data types
Supports spatial data types such as POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, and GEOMETRYCOLLECTION.
Spatial functions
Supports spatial functions such as Area, Length, and Distance.
Metadata types and functions
Supports GEOMETRY_COLUMNS and SPATIAL_REF_SYS.
Binary predicates
Supports binary predicates such as Contains, Within, Overlaps, and Touches.
Spatial operators
Supports spatial operators such as Union and Difference.
-
Strong Compatibility with NoSQL
The SQL statements support unstructured data types such as JSON, XML, and Key-Value, which enables a Not Only SQL (NoSQL) solution.
Create tables using JSON data
For example, CREATE TABLE json_tab(id bigint, data jsonb);
Directly save JSON data
For example, INSERT INTO json_tab VALUES (1,'{""pname"":""Product 1"",""qty"":50}')
Directly query JSON data
For example, SELECT * FROM json_tab WHERE data->>'qty' > 30
Index JSON attributes to enhance performance
For example, CREATE INDEX idx_json_tab_data_pname ON json_tab USING btree ((data ->> 'pname'));
Perform JOIN queries on existing tables
For example, SELECT * FROM json_tab JOIN product ON (products.pname=json_data.data->>'pname') WHERE data->>'qty' > 30;
-
Supports Full-text Search
You can use SQL operations to perform full-text searches and fuzzy queries without the need to create additional search engines.
Multiple features
Supports Chinese text segmentation and custom word banks, and allows you to continuously process and optimize existing word banks. The service also offers advanced features such as jieba segmenter, similarity analysis, similarity indexing, and regular expression matching. You can use the SQL engine to perform text segmentation smoothly and easily.
-
Supports OSS Storage Expansion
Based on the Foreign Data Wrapper (FDW) feature of PostgreSQL, ApsaraDB RDS for PostgreSQL integrates the management of external tables stored in OSS and supports flexible storage expansion.
Readable, writeable, and flexible storage
With external tables, you can use the CSV files stored in OSS as local data tables. The service also allows you to perform JOIN queries involving local tables, to read and write data directly, and to flexibly increase the database size to meet your needs for the management of hot and cold data lifecycles. You can also use the standard GZIP algorithm to compress the CSV files stored as external tables in OSS. This effectively shortens the data writing time to OSS and lowers the storage cost by more than 50%.
-
Supports Data Warehousing
ApsaraDB RDS for PostgreSQL meets the high availability needs of OLTP applications, and also supports OLAP data warehouses for real-time data analysis.
OLAP + OLTP = HTAP
Provides the same database driver for online databases and data warehouses, which helps SMEs reduce the development cost. To analyze TB size data, you can use AnalyticDB RDS for PostgreSQL to create OLAP data warehouses that support horizontal scaling, and BI transactions that involve analyzing hundreds of TB or PB size data.
How it works
Standard enterprise-level PostgreSQL solution
Core business database
Based on Alibaba Cloud 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.
Benefits
-
Supports large tables
Each table can contain hundreds of millions of rows. Maintains high performance in multi-table queries based on Hash JOIN.
-
OLAP solutions
Provides OLAP support for tables of hundreds of gigabytes. For larger sizes of data, AnalyticDB for PostgreSQL supports horizontal scaling.
-
Flexible storage
Allows you to store cold data in external tables in OSS. Supports interaction with AnalyticDB for PostgreSQL.
Related Products and Services
Flexible storage expansion
Breaks the limit of RDS storage
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.
Benefits
-
Log storage
Provides flexible storage based on OSS.
-
Analysis of large amounts of BI data
Use AnalyticDB for PostgreSQL to implement high performance analysis using the same SQL grammar.
Related Products and Services
Boosts IoT development with GIS and JSON
Increase the productivity of developers and database administrators with SQL
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.
Benefits
-
Sensor data of JSON format
Use SQL to perform relational queries and lower the development cost.
-
GIS data
Precise positioning. Supports 2D and 3D data types, route planning, and raster data analysis.
Related Products and Services
Rely on Alibaba Cloud's Worldwide Data Centers
Alibaba Cloud has 87 zones strategically located across 29 regions in the world, providing reliable computing support for billions of customers.
-
No.1
Market Share in the Asia PacificIaaS Market Share - Gartner IT Service Report 2022
-
29
Global Data Center regions -
3,200 +
CDN Nodes Globally -
87
Availability Zones
2
2
2
3
3
1
2
3
1
2
3
22
10
2
21
3
3
1
1
Data centers and availability zones
Upgraded Support For You
1 on 1 Presale Consultation, 24/7 Technical Support, Faster Response, and More Free Tickets.