sql: consider exposing a way to run runtime.GC(), perhaps via builtin

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

https://www.cockroachlabs.com

Other

30.01k stars 3.79k forks source link

sql: consider exposing a way to run runtime.GC(), perhaps via builtin #120864

Open yuzefovich opened 6 months ago

yuzefovich commented 6 months ago

It'd be nice to have a way to force garbage collection (either on 1 node or on all nodes in the cluster, perhaps in the "rolling update" way) via SQL. This was suggested by Sean here.

Some things to consider:

permissions, roles, etc
single-tenant vs UA vs serverless
expose via SQL builtin or via RPC from DB Console (or both).

Jira issue: CRDB-36907

michae2 commented 6 months ago

Would it make sense for the hypothetical UI to support running this on a schedule, or at a certain frequency?