All Products
Search
Document Center

AnalyticDB for PostgreSQL:Create an instance

Last Updated:Nov 09, 2023

This topic describes how to create an instance in the AnalyticDB for PostgreSQL console.

Prerequisites

An Alibaba Cloud account is created. If you do not have an Alibaba Cloud account, visit the Alibaba Cloud official website to create an account.

Free trial

Alibaba Cloud provides a free trial for new users of AnalyticDB for PostgreSQL V6.0 instances in elastic storage mode. If you are new to AnalyticDB for PostgreSQL, you can click free to apply for a free trial. If you are ineligible for a free trial, you can create an instance in the AnalyticDB for PostgreSQL console based on the following procedure.

Create a service-linked role

The first time you use AnalyticDB for PostgreSQL, you must create a service-linked role in the console.

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-right corner of the console, click Create Instance.

  3. In the Create Service Linked Role message, click OK.

Create an instance

  1. Log on to the AnalyticDB for PostgreSQL console.
  2. In the upper-right corner of the console, click Create Instance to go to the buy page.

  3. Configure the Product Type parameter. Valid values:

    • Subscription: You must pay a subscription fee when you create an instance. For long-term usage, the subscription billing method is more cost-effective than the pay-as-you-go billing method. You are charged lower prices for longer subscription durations.

    • Pay-as-you-go: You are charged on an hourly basis for the resources that you use. For short-term use, we recommend that you select the pay-as-you-go billing method. If you no longer need a pay-as-you-go instance, you can release the instance to reduce costs.

  4. Configure the parameters that are described in the following table.

    Parameter

    Description

    Region and Zone

    The region where you want to create the instance.

    Note
    • After you complete the purchase, you cannot change the region of the instance. To accelerate access to the instance, we recommend that you select a region that is close to your geographical location.

    • Make sure that the AnalyticDB for PostgreSQL instance is deployed in the same region as the Elastic Compute Service (ECS) instance to which you want to connect. Otherwise, you cannot connect these instances over an internal network and make them deliver the optimal performance.

    The zone where you want to create the instance. Each zone is an independent physical location within a region. Zones in the same region do not have substantial differences.

    You can create the instance in the same zone as the ECS instance to which you want to connect or in a different zone.

    Instance Resource Type

    The resource type of the instance. Valid values:

    • Serverless: You can specify only the required computing resources without the need to reserve storage resources.

    • Elastic Storage Mode: You can add nodes or increase your storage capacity.

    Note

    The resource types that are available vary based on the region and zone. If the current region and zone do not provide your required instance resource type, change the region and zone.

    For more information about the resource types that are available in different regions and zones, see Instance specifications.

    Serverless Mode

    The scheduling mode for the instance in Serverless mode. Valid values:

    • Manual Scheduling: You can perform manual resource orchestration based on your business requirements. For example, you can manually pause and resume the instance and perform scheduled scaling. For more information, see Manually pause and resume an instance and Manage plans.

    • Automatic Scheduling: The instance can be automatically paused and resumed based on traffic detection. If no traffic is detected, the instance automatically changes to the idle state. You are not charged for computing resources when the instance is in the idle state.

    Note
    • This parameter is available only for instances in Serverless mode.

    • You can select Automatic Scheduling only when you set the Product Type parameter to Pay-as-you-go.

    Maximum ACUs

    The number of maximum AnalyticDB compute units (ACUs) for the instance in Serverless automatic scheduling mode. Valid values: 8 to 32, in 8 increments.

    An ACU is the unit of computing resources for AnalyticDB for PostgreSQL instances in Serverless automatic scheduling mode. If your instance fails to meet computing performance requirements, you can manually modify the value of this parameter. For more information, see Configure instance resources.

    Note

    This parameter is available only for instances in Serverless automatic scheduling mode.

    Engine Version

    The engine version of the instance. Valid values: 7.0 Standard Edition and 6.0 Standard Edition.

    Note

    You can select 7.0 Standard Edition only for instances in elastic storage mode.

    This parameter is available only when you set the Product Type parameter to Subscription.

    Edition

    The edition of the instance. Valid values: High Performance (Basic Edition) and High-availability.

    Note

    You can select High Performance (Basic Edition) only when you set the Instance Resource Type parameter to Elastic Storage Mode. For more information, see High-performance Edition.

    Vector Engine Optimization

    Specifies whether to enable vector engine optimization. Valid values:

    • Disabled (Recommended for Data Warehouses): In main-stream analysis, data warehousing, and real-time data warehousing scenarios, we recommend that you disable vector search engine optimization.

    • Enabled: In AI-generated content (AIGC) and vector search scenarios, we recommend that you enable vector search engine optimization.

    Vector search engine optimization can improve vector analysis performance of your instance, but consumes large amounts of memory resources and significantly decreases the concurrency of queries. Make sure that you have learned the impact before you enable vector search engine optimization.

    Note
    • You can enable vector search engine optimization only for V6.0 instances in elastic storage mode.

    • You can enable vector search engine optimization only for instances whose compute node specifications are 4 cores and 32 GB or more.

    Coordinator Node Resources

    The specifications of coordinator node resources. We recommend that you select coordinator node resources with the number of compute units (CUs) to be equal to the number of CPU cores per compute node.

    If you need more coordinator node resources, you can add more resources after you create the instance. For more information, see Manage coordinator node resources.

    Note

    This parameter is unavailable for instances in Serverless automatic scheduling mode.

    Compute Node Specifications

    The specifications of compute nodes. The available specifications vary based on the resource type and the edition. For more information, see Instance specifications.

    Note

    This parameter is unavailable for instances in Serverless automatic scheduling mode.

    Nodes

    The number of compute nodes. The instance performance increases with the number of compute nodes. The number of compute nodes that you can select varies based on the resource type and edition.

    • Serverless mode

      Valid values when Edition is set to High-availability: 2 to 512, in 2 increments.

    • Elastic storage mode

      • Valid values when Edition is set to High-availability: 4 to 512, in 4 increments.

      • Valid values when Edition is set to High Performance (Basic Edition): 2 to 512, in 2 increments.

    Note

    This parameter is unavailable for instances in Serverless automatic scheduling mode.

    Storage Disk Type

    The disk storage type. Valid values:

    • PL1 ESSD (Recommended)

    • ESSD_PL0

    • PL2 ESSD (High-throughput)

    For information about performance differences between the disk storage types, see EBS performance.

    Note

    This parameter is available only for instances in elastic storage mode.

    Encryption Type

    The encryption type of the instance. You can select Not Encrypted or Disk Encryption.

    Note

    This parameter is available only for instances in elastic storage mode.

    CMK

    The encryption key of disks.

    This parameter is available only when you select Elastic Storage Mode and Disk Encryption.

    Single Node Storage Capacity

    The storage capacity of each node in the instance. Unit: GB. Valid values: 50 to 6000. The value must be a multiple of 50.

    Note

    This parameter is available only for instances in elastic storage mode.

    Network Type

    The network type of the instance. It is automatically set to VPC.

    VPC

    The virtual private cloud (VPC) in which the instance resides.

    A VPC is an isolated virtual network that provides higher security and higher performance than the classic network. Before you configure this parameter, make sure that a VPC and a vSwitch are created in the region where you want to create the instance. For more information, see Create and manage a VPC.

    vSwitch

    The vSwitch to which the instance is connected.

    Resource Group

    The resource group to which the instance belongs. For more information about resource groups, see What is Resource Management?

    Sample Data

    Specifies whether to load sample data to the instance. For more information about the sample dataset, see Manage the sample dataset.

    Duration

    The subscription duration of the instance.

    Note

    This parameter is available only when you set the Product Type parameter to Subscription.

  5. Click Buy Now.

  6. On the Confirm Order page, perform the following operations based on the value of the Product Type parameter:

    • Subscription

      1. Confirm the information in the Parameters section, read and select the Terms of Service, and then click Pay.

      2. On the Purchase page, click Subscribe.

    • Pay-as-you-go

      Confirm the information in the Parameters section, read and select the Terms of Service, and then click Activate Now.

  7. After the instance is created, go to the Instances page to view the instance.

    Note

    It takes a period of time to initialize an AnalyticDB for PostgreSQL instance. You can perform operations only when the instance is in the Running state.

Related operations

Operation

Description

CreateDBInstance

Creates an AnalyticDB for PostgreSQL instance.