topic Re: Lakebase auto start/stop in Lakebase Discussions

Lakebase auto start/stop

jericksoncea — Mon, 14 Jul 2025 07:04:31 GMT

It doesn’t appear that the Lakebase OLTP instances function like Sql warehouses in the following ways:
• automatically starting when initiating a connection
• automatically stopping after no usage in x minutes

I am wondering if others have use cases for auto start-stop, and if it on the product roadmap…

Re: Lakebase auto start/stop

-werners- — Mon, 14 Jul 2025 08:33:26 GMT

I guess that the start/stop pattern is not something you want in a low-latency OLTP database.
Perhaps they add it in the future.

Re: Lakebase auto start/stop

jericksoncea — Mon, 14 Jul 2025 10:33:14 GMT

I can definitely think of use cases where I would trade the cost savings for a few seconds of startup (like serverless sql warehouses), and low-latency thereafter...

Re: Lakebase auto start/stop

balajij8 — Wed, 29 Apr 2026 10:56:01 GMT

Lake base supports Autoscaling & Scale to Zero with Automatic Suspension & Reactivation capabilities

Automatic Suspension - Lake base compute automatically suspends after a period of inactivity (default is 5 minutes).
Reactivation - The compute automatically reactivates within a few hundred milliseconds when you run a new query

You can use Autoscaling to adjust resources based on workload demand & scale to zero to suspend compute entirely after a period of inactivity reducing compute costs to zero during idle periods. You pay only for active compute time & not for idle periods

More details here