Snowflake Postgres 实例规格¶
Snowflake Postgres offers three tiers of instances — Burstable, Standard, and Memory — to cover a variety of use cases.
For credit costs for each instance size, see the Snowflake Service Consumption Table.
一般而言：
- 突发型 实例具有基线 CPU 水平，但可以暂时突破此基线。
- 标准型 实例在 CPU 和内存之间具有良好的平衡。
- Memory-optimized instances have a higher ratio of memory to CPU, which may improve performance for workloads with greater memory needs.
突发型
重要注意事项
- 突发型实例最多可以预置 100GB 存储空间。
- Burstable instances have burstable vCPUs. Utilization in excess of the CPU baseline shown below will deplete available vCPU credits, leading to CPU rate limiting. This may appear as a sudden downgrade in performance with no other cause.
- 突发型实例不支持高可用性备用实例。
| 名称 | 核心数 | 内存 | IOPS | 支持 HA |
|---|---|---|---|---|
| BURST_XS | 2 | 1GB | 11,800 | 否 |
| BURST_S | 2 | 2GB | 11,800 | 否 |
| BURST_M | 2 | 4GB | 11,800 | 否 |
常规用途
| 名称 | 核心数 | 内存 | IOPS | 支持 HA |
|---|---|---|---|---|
| STANDARD_M | 1 | 4GB | 20,000 | 是 |
| STANDARD_L | 2 | 8GB | 40,000 | 是 |
| STANDARD_XL | 4 | 16GB | 40,000 | 是 |
| STANDARD_2XL | 8 | 32GB | 40,000 | 是 |
| STANDARD_4XL | 16 | 64GB | 40,000 | 是 |
| STANDARD_8XL | 32 | 128GB | 40,000 | 是 |
| STANDARD_12XL | 48 | 192GB | 60,000 | 是 |
| STANDARD_24XL | 96 | 384GB | 78,000 | 是 |
Note
Microsoft Azure 上不提供 STANDARD_M 实例规格。
内存优化型
| 名称 | 核心数 | 内存 | IOPS | 支持 HA |
|---|---|---|---|---|
| HIGHMEM_L | 2 | 16GB | 40,000 | 是 |
| HIGHMEM_XL | 4 | 32GB | 40,000 | 是 |
| HIGHMEM_2XL | 8 | 64GB | 40,000 | 是 |
| HIGHMEM_4XL | 16 | 128GB | 40,000 | 是 |
| HIGHMEM_8XL | 32 | 256GB | 40,000 | 是 |
| HIGHMEM_12XL | 48 | 384GB | 78,000 | 是 |
| HIGHMEM_16XL | 64 | 512GB | 78,000 | 是 |
| HIGHMEM_24XL | 96 | 768GB | 78,000 | 是 |
| HIGHMEM_32XL | 128 | 1TB | 78,000 | 是 |
| HIGHMEM_48XL | 192 | 1.5TB | 78,000 | 是 |