RDS DuckDB-based analytical primary instances are available in two editions and multiple specification tiers. Each instance supports up to 128 TB of storage. Use this page to match your workload's concurrency, memory, and throughput requirements to the right specification.
Choose a specification
The specification code encodes the CPU-to-memory ratio and instance size:
x2 / n2 — 1:2 ratio (vCPU:memory in GB), suited for compute-intensive analytical queries
x4 / n4 — 1:4 ratio, balanced general-purpose analytics
x8 / n8 — 1:8 ratio, suited for memory-intensive workloads such as large joins and wide aggregations
Scale up the size tier (large → xlarge → 2xlarge → 4xlarge → 8xlarge) to increase vCPUs, connections, and IOPS proportionally.
Higher IOPS limits apply at larger size tiers. If your queries are I/O-bound rather than CPU-bound, prioritize size tier over memory ratio when selecting a specification.
Cluster edition
The Cluster edition uses Dedicated instance families.
All Cluster edition specifications support 20 GB–128,000 GB of storage space.
| Specification code | vCPU | Memory | Default max connections | Max IOPS |
|---|---|---|---|---|
| myduck.x2.large.xc | 4 | 8 GB | 6,000 | 20,000 |
| myduck.x4.large.xc | 4 | 16 GB | 8,000 | 20,000 |
| myduck.x8.large.xc | 4 | 32 GB | 12,000 | 20,000 |
| myduck.x2.xlarge.xc | 8 | 16 GB | 12,000 | 25,000 |
| myduck.x4.xlarge.xc | 8 | 32 GB | 12,000 | 25,000 |
| myduck.x8.xlarge.xc | 8 | 64 GB | 16,000 | 25,000 |
| myduck.x2.2xlarge.xc | 16 | 32 GB | 16,000 | 40,000 |
| myduck.x4.2xlarge.xc | 16 | 64 GB | 20,000 | 40,000 |
| myduck.x8.2xlarge.xc | 16 | 128 GB | 32,000 | 40,000 |
| myduck.x2.4xlarge.xc | 32 | 64 GB | 32,000 | 60,000 |
| myduck.x4.4xlarge.xc | 32 | 128 GB | 40,000 | 60,000 |
| myduck.x8.4xlarge.xc | 32 | 256 GB | 64,000 | 60,000 |
| myduck.x2.8xlarge.xc | 64 | 128 GB | 64,000 | 120,000 |
| myduck.x4.8xlarge.xc | 64 | 256 GB | 80,000 | 150,000 |
| myduck.x8.8xlarge.xc | 64 | 512 GB | 128,000 | 150,000 |
Basic edition
The Basic edition uses General-purpose instance families.
All Basic edition specifications support 20 GB–128,000 GB of storage space.
| Specification code | vCPU | Memory | Default max connections | Max IOPS |
|---|---|---|---|---|
| myduck.n2.large.1 | 4 | 8 GB | 6,000 | 20,000 |
| myduck.n4.large.1 | 4 | 16 GB | 8,000 | 20,000 |
| myduck.n8.large.1 | 4 | 32 GB | 12,000 | 20,000 |
| myduck.n2.xlarge.1 | 8 | 16 GB | 8,000 | 25,000 |
| myduck.n4.xlarge.1 | 8 | 32 GB | 12,000 | 25,000 |
| myduck.n8.xlarge.1 | 8 | 64 GB | 16,000 | 25,000 |
| myduck.n2.2xlarge.1 | 16 | 32 GB | 16,000 | 40,000 |
| myduck.n4.2xlarge.1 | 16 | 64 GB | 20,000 | 40,000 |
| myduck.n8.2xlarge.1 | 16 | 128 GB | 32,000 | 40,000 |