AnalyticDB for PostgreSQL offers two instance type families: High-performance and High-capacity.
Choose an instance type
Select an instance type based on your workload's I/O demands and storage requirements:
High-performance (
gpdb.group.segsdx): Backed by SSD storage, this family delivers higher I/O throughput. Choose it for query-intensive workloads where read/write speed is the primary bottleneck.High-capacity (
gpdb.group.seghdx): Backed by HDD storage, this family provides more storage per dollar. Choose it for large datasets where cost-efficient storage matters more than raw I/O performance.
To reduce storage costs further, offload data that is not involved in real-time computing to OSS-based external tables. AnalyticDB for PostgreSQL supports gzip compression for data in external storage.
Instance specifications
The tables below list the CPU, memory, and storage per compute node for each instance type.
High-performance type family
| Instance type | CPU | Memory | Storage space |
|---|---|---|---|
| gpdb.group.segsdx1 | 1 core | 8 GB | 80 GB SSD |
| gpdb.group.segsdx2 | 2 cores | 16 GB | 160 GB SSD |
| gpdb.group.segsdx16 | 16 cores | 128 GB | 1.28 TB SSD |
High-capacity type family
| Instance type | CPU | Memory | Storage space |
|---|---|---|---|
| gpdb.group.seghdx4 | 4 cores | 32 GB | 2 TB HDD |
| gpdb.group.seghdx36 | 36 cores | 288 GB | 18 TB HDD |