Lakebase auto start/stop

jericksoncea
New Contributor III

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…

-werners-
Esteemed Contributor III

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.

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...

balajij8
Contributor III

Lake base supports AutoscalingScale 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