Workspace-Level Limits

Item

Max Spec (enforced)

Max Spec (recommended)

Comments

Number of hosts in a workspace

None

Workloads that generate significant network traffic between hosts should be limited to workspaces with smaller number of hosts.

Number of nodes in a workspace (includes leaves and aggregators)

None

Workloads that generate significant network traffic between nodes should be limited to workspaces with smaller number of nodes.

Number of databases in a workspace

None

Each database requires memory for transaction buffer and more databases implies greater demand on available memory.

Concurrent queries in a workspace

None

Each aggregator will only actually execute a limited number of queries at once (defined by max_connection_threads, default 192). Beyond that concurrency, queries will be queued up.

Simultaneous client connections

100,000 per aggregator