Announcements and Updates

• Notices
• Release notes
• Engine release notes for elastic storage mode
• Engine release notes for Serverless mode

Product Introduction

• Overview
• Scenarios
• Instance specifications
• AnalyticDB for PostgreSQL V7.0
• High-performance Edition
• Serverless mode
• Performance tests on the Serverless mode
• Limits
• Terms

Billing

• Free trial
• Billable items
• Pricing
• Switch between billing methods
• Billing of configuration changes
• Expiration or overdue payments
• Renewal policy
• Resource usage and bills
• Per-second billing

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

Data Migration and Synchronization

• Overview
• Migrate or synchronize data from a self-managed database
• Migrate or synchronize data from a third-party cloud database
• Import data by using tools
• Migrate or synchronize data from an Alibaba Cloud database
• Migrate data between AnalyticDB for PostgreSQL instances
• Export data

Console Guide

• Overview
• Instance management
• Database connection
• Account and security management
• Performance monitoring
• Backup and restoration
• Data sharing
• Event center
• Tags

SQL Manual

• SQL syntax
• Data types
• Hints
• Data
• Window functions
• Aggregate function reuse
• Generated column
• Stored procedures
• Column group statistics
• Common table expressions

Real-time Data Warehousing

• Real-time materialized views
• Query rewrite for materialized views

Vector Analysis

• Overview
• Usage of vector analysis
• Performance tests for vector analysis
• Case: Recommendation systems
• Case: Product attributes extraction and multimodal search
• Case: Efficient gene sequence retrieval empowers quick analysis of a pneumonia virus
• Case: Alibaba Cloud's efficient genetic retrieval application for pathogens

Spatio-temporal Data Analysis

• Use PostGIS
• GANOS

Extension Management

• Manage extensions
• Use roaring bitmaps
• Use the uuid-ossp extension
• SQL plan management
• Use zhparser to perform Chinese word segmentation
• Use the SM4 encryption algorithm
• HyperLogLog
• Use the pg_cron extension to configure scheduled tasks

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

Tools

• Data Warehouse Development
• BI Analysis and Visualization

Optimization Guide

• Instance specification selection and planning
• Database object optimization
• Performance optimization

Best Practices

• Use pg_stat_activity to analyze and diagnose active SQL queries
• Pre-process special characters within files to be imported
• TPC-H

Technical White Paper

• Data analysis trends
• AnalyticDB for PostgreSQL overview
• Scenarios
• Benefits
• Ecosystem integration
• Planning

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 use table partition?
• 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?

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

SDK Reference

• Examples of using Alibaba Cloud AnalyticDB for PostgreSQL SDKs
• SDK download

Error Codes

Related Protocols

• Service Level Agreement