Document Center
all-products-head
This Product
This Product
All Products
AnalyticDB for PostgreSQL
AnalyticDB for PostgreSQL
All Products
Announcements and Updates
Notices
Release notes
Engine release notes for elastic storage mode
Engine release notes for Serverless mode
Show more
Show less
Product Introduction
Overview
Scenarios
Instance specifications
AnalyticDB for PostgreSQL V7.0
Basic Edition
Serverless mode
Performance tests on the Serverless mode
Limits
Terms
Show more
Show less
Billing
Pricing
Switch between billing methods
Impact of expiration or overdue payments
Renewal policy
Resource usage and bills
Per-second billing
Show more
Show less
Quick Start
Overview
Create an instance
Configure an IP address whitelist
Create a privileged account
Connect to a database
Load a sample dataset
Query data
Scale an instance
Data sharing
Show more
Show less
Data Migration and Synchronization
Overview
One-click data warehousing
Migrate data to AnalyticDB for PostgreSQL
Synchronize data from cloud databases
Synchronize data from self-managed databases
Show more
Show less
Console Guide
Overview
Instance management
Database connection
Account and security management
Performance monitoring
Backup and restoration
Data sharing
Event center
Tags
Show more
Show less
Developer Guide
SQL statements
Data types
Manage JSON and JSON-B data
Optimization engines
Use a connection pool
Use resource queues for load management
Data
Extension features
AnalyticDB for PostgreSQL V7.0
Show more
Show less
Multi-model Data Analysis
Spatio-temporal data analysis
Show more
Show less
GANOS
Overview
Model
Raster SQL Reference
SpatialRef SQL reference
Trajectory SQL reference
GeomGrid SQL reference
FAQ
Best practice
Show more
Show less
Data Lake Analysis
Use MaxCompute foreign tables to access MaxCompute data
Use OSS foreign tables for data lake analysis
Use external tables for federated analytics of Hadoop data sources
Use external tables for federated analytics of external SQL databases
Show more
Show less
Data Warehouse Development
Use DataWorks to schedule ETL tasks of AnalyticDB for PostgreSQL
Use job scheduling of DMS
Show more
Show less
BI Analysis and Visualization
BI tools compatible with AnalyticDB for PostgreSQL
Connect Alibaba Cloud Quick BI to AnalyticDB for PostgreSQL
Use Tableau to connect to AnalyticDB for PostgreSQL
Show more
Show less
Optimization Guide
Instance specification selection and planning
Database object optimization
Performance optimization
Show more
Show less
Best Practices
Use pg_stat_activity to analyze and diagnose active SQL queries
Pre-process special characters within files to be imported
TPC-H
Show more
Show less
Technical White Paper
Data analysis trends
AnalyticDB for PostgreSQL overview
Scenarios
Benefits
Ecosystem integration
Planning
Show more
Show less
FAQ
What do I do if I cannot connect to an instance?
How to view the data size of a table or a database?
How do I obtain technical details about AnalyticDB for PostgreSQL?
How do I choose an AnalyticDB for PostgreSQL instance type?
How do I switch the network type?
How do I clear data on a locked disk?
How do I reconfigure parameters?
How to enable column-store and compression in AnalyticDB for PostgreSQL?
What do I do if an AnalyticDB for PostgreSQL instance fails to be created or remains in the creating state for a long time?
Do I need to execute COPY statements as the superuser user?
Why am I unable to view the bills for my pay-as-you-go instance? And when can I receive my invoice?
How do I terminate the abnormal execution of an SQL statement?
How do I view the distribution key and partitions of a table?
How do I join the AnalyticDB for PostgreSQL technical support group on DingTalk?
Mappings between compute node types and compute group types
Create an AccessKey pair
How do I set the timeout period of SQL statements?
Show more
Show less
API Reference
List of operations by function
Request structure
Common parameters
Responses
Sign signatures
Service linked role
Use RAM for resource authorization
Instance management
Account management
Data sharing
Diagnostics and optimization
Plan management
Tag management
Security management
Log management
Network management
Sample dataset
Appendix
Show more
Show less
Error Codes
Show more
Show less
Related Protocols
Service Level Agreement
Show more
Show less