Lakebase Postgres
Lakebase Postgres is a fully managed, cloud-native PostgreSQL database that brings online transaction processing (OLTP) capabilities to the Lakehouse.
Lakebase Autoscaling is available in the following regions: us-east-1, us-east-2, us-west-2, ca-central-1, sa-east-1, eu-central-1, eu-west-1, eu-west-2, ap-south-1, ap-southeast-1, ap-southeast-2.
Lakebase Autoscaling is the latest version of Lakebase, with autoscaling compute, scale-to-zero, branching, and instant restore. If you are a Lakebase Provisioned user, see Lakebase Provisioned.
Lakebase Provisioned is available in the following regions: us-east-1, us-east-2, us-west-2, eu-central-1, eu-west-1, ap-south-1, ap-southeast-1, ap-southeast-2.
Lakebase Provisioned is the original Lakebase offering that uses provisioned compute you scale manually. For the latest version of Lakebase, with autoscaling compute, scale-to-zero, branching, and instant restore, see Lakebase Autoscaling.
New Lakebase instances will be created as Autoscaling projects. Rollout starts March 12, 2026. For details, see Autoscaling by default.
Lakebase Autoscaling for new databases
New Lakebase instances are created as Lakebase Autoscaling projects. Existing Provisioned instances continue to be supported. For details on the change and what it means for you, see Autoscaling by default.
Version | Description |
|---|---|
Default for new Lakebase instances. Fully managed PostgreSQL with autoscaling compute, branching, scale-to-zero, and instant restore. Organizes resources as projects. See What is Lakebase Autoscaling?. | |
Existing Provisioned instances only. We continue to support existing Provisioned instances. Organizes resources as database instances with manually scaled compute. See What is Lakebase Provisioned?. |
What's new in Lakebase Autoscaling
Lakebase Autoscaling introduces modern database capabilities designed for flexible development and cost-efficient operations:
- Lakebase App: A new Lakebase interface with a project-based structure for managing database resources
- Autoscaling: Compute resources automatically adjust based on workload demand. Learn more: Autoscaling
- Scale-to-zero: Computes automatically suspend after inactivity, waking up in seconds when needed. Learn more: Scale to zero
- Projects and branches: Create instant, isolated copies of your database using copy-on-write technology. Learn more: Branches
- Instant restore: Restore your database to any point in time within your configured restore window (0-30 days). Learn more: Point-in-time restore
- Read replicas: Create read-only compute endpoints that share the same storage layer, enabling instant creation without data duplication. Learn more: Read replicas
- High availability: Pair a primary compute with secondary compute instances across availability zones for automatic failover. Learn more: High availability
- Data API: PostgREST-compatible RESTful interface for direct HTTP access to your database. Learn more: Data API
Feature comparison
The following table compares capabilities in Lakebase Autoscaling and Lakebase Provisioned.
Lakebase Autoscaling is the new version of Lakebase. New feature development is focused on Lakebase Autoscaling.
New Lakebase instances will be created as Autoscaling projects. Rollout starts March 12, 2026. For details, see Autoscaling by default.
Feature | Autoscaling | Provisioned |
|---|---|---|
Core capabilities | ||
Provisioned (fixed-size) compute | ✓ | ✓ |
Autoscaling | ✓ | |
Scale to zero | ✓ | |
Branching | ✓ | |
Instant restore | ✓ | |
Point-in-time restore | ✓ | ✓ |
Read replicas / readable secondaries | ✓ (Read replicas, readable secondaries) | ✓ (Readable secondaries) |
High availability | ✓ | ✓ |
Private Link | ✓ | ✓ |
Compliance security profile | ✓ (set to HIPAA, C5, TISAX, or None) | |
Data integrations | ||
Unity Catalog registration | ✓ | ✓ |
Synced tables (serve lakehouse data with Lakebase) | ✓ | ✓ |
Lakehouse Sync (sink Lakebase tables to Delta/Iceberg tables) | ✓ Beta on AWS | |
Query federation | ✓ | ✓ |
Application integrations | ||
Databricks Apps | ✓ | ✓ |
Feature Store | ✓ | ✓ |
Notebooks | ✓ | ✓ |
Stateful AI agents | ✓ | ✓ |
Access control | ||
UI for Postgres role management | ✓ | ✓ |
Workspace ACLs | ✓ | ✓ |
Developer tools | ||
Infrastructure as code (Asset Bundles, Terraform) | ✓ (Beta) | ✓ |
Programmatic access (REST API, CLI, SDKs) | ✓ (Beta) | ✓ |
PostgREST API support | ✓ (PostgREST-compatible Data API) | ✓ (Private Preview) |
Cost management | ||
Tags and usage policies | ✓ | ✓ |
Choosing the right version
Both versions of Lakebase are suitable for production workloads. Choose based on your feature requirements:
Choose Lakebase Autoscaling if you want:
- Compute that scales automatically based on workload demand
- Scale-to-zero for cost optimization
- Branch-based development workflows
- Instant point-in-time restore
Choose Lakebase Provisioned if you want:
- Provisioned compute that you manually scale
For detailed feature support differences, see the Feature comparison table above and Lakebase Autoscaling limitations.