Manage instance capacity

Preview

This feature is in Public Preview in the following regions: us-east-1, us-west-2, eu-west-1, ap-southeast-1, ap-southeast-2, eu-central-1, us-east-2, ap-south-1.

This page explains the options for right-sizing your Lakebase instance capacity and how to manage it.

Change instance capacity

To resize an instance, you must have CAN MANAGE permissions. Resizing can take several minutes. The capacity change takes effect when the instance is restarted.

UI

1. Open a running instance. See Access a database instance.
2. Click Edit in thu upper-right corner.
3. Use the Capacity drop-down menu to select the new instance size.
4. Click Save.

curl

Bash

curl -X PATCH --header "Authorization: Bearer ${DATABRICKS_TOKEN}" https://$WORKSPACE/api/2.0/database/instances/$INSTANCE_NAME \
--data-binary @- << EOF
{
  "capacity": "CU_4"
}
EOF

Best practices

Each capacity unit allocates about 16GB of RAM to the database instance, along with all associated CPU and local SSD resources. Scaling up increases these resources linearly. Postgres distributes the allocated memory across multiple components:

• Database caches
• Worker memory
• Other processes with fixed memory requirements

Performance varies based on data size and query complexity.

Before scaling, test and optimize queries. Storage scales automatically.