AnalyticDB for PostgreSQL is a distributed cloud database that is composed of multiple groups to provide MPP (Massively Parallel Processing) data warehousing service. AnalyticDB for PostgreSQL is developed based on the Greenplum Open Source Database program and is enhanced with some in-depth extensions by Alibaba Cloud.

AnalyticDB for PostgreSQL is compatible with the Greenplum environment and supports features including OSS storage, JSON data type, and HyperLogLog approximating analysis. For details about AnalyticDB for PostgreSQL features and limits, see Features and limitations.

To use AnalyticDB for PostgreSQL, you need to complete the following tasks:

  1. Create an instance.
  2. Set up an instance, including Set up a whitelist, Set up an account, and Set the network type.
  3. Connect to a database
  4. Import data. You can select to import and export data in parallel by using OSS external tables, or to import data from MySQL, from PostgreSQL, or by using the COPY commmand.