Lakebase auto start/stop

[jericksoncea]

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

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.

[jericksoncea]

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]

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