Skip to main content

Instance Types

MotherDuck implements a distinct tenancy architecture that diverges from traditional database systems. The platform utilizes a per-user tenancy model, which provisions isolated read-write instances for each Organization member. This architecture ensures dedicated compute resources and instance-level configuration at the individual user level, eliminating resource contention commonly found in shared compute environments. Users can independently optimize performance parameters according to their specific workload requirements.

Instance Types​

PULSE​

Optimized for ad-hoc analytics tasks and read-only workloads

  • Running ad-hoc queries and analysis
  • Read-optimized workflows with high concurrent user access
  • Customer-facing analytics for data apps and embedded analytics

STANDARD​

Production-grade instance for analytical processing and reporting

  • Core analytical workflows requiring balanced performance metrics
  • Development and validation environment for production workflows
  • Standard ETL/ELT pipeline implementation, such as:
    • Parallel execution of incremental ingestion jobs
    • Multi-threaded transformation processing

JUMBO​

Enterprise-scale instance for high-throughput processing

  • Large-scale batch processing ingestion operations
  • Complex query execution on high-volume datasets
  • Advanced join operations and aggregations
  • RAM-Intensive processing of deeply-nested JSON structures