Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Better usability for calculating TTL limit rates #103685

Open
steven-hubbard opened this issue May 19, 2023 · 0 comments
Open

Better usability for calculating TTL limit rates #103685

steven-hubbard opened this issue May 19, 2023 · 0 comments
Labels
A-row-level-ttl C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Comments

@steven-hubbard
Copy link
Contributor

steven-hubbard commented May 19, 2023

Is your feature request related to a problem? Please describe.
When calculating TTL limit rates, the process is pretty nebulous. Ideally, you would be able to specify a per table rate or a per cluster rate and that would be the end of the process. However, that rate can be impacted by factors like the number of nodes in the cluster, the number of tables in the cluster, the delete batch size, and the select batch size. This makes calculating the proper rate for a customer fairly difficult and subject to change when clusters are resized or workloads are added or removed.

Describe the solution you'd like
One global cluster limit that is carved up among all TTL workloads would be one potential solution

Describe alternatives you've considered
May not be an issue once #98722 is resolved as the general guidance is to allow Admission Control to handle TTL

Additional context
Add any other context or screenshots about the feature request here.

Jira issue: CRDB-28134

Epic CRDB-18322

@steven-hubbard steven-hubbard added the C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) label May 19, 2023
@blathers-crl blathers-crl bot added the T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) label May 22, 2023
@rafiss rafiss added A-row-level-ttl T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) and removed T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels May 22, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-row-level-ttl C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Development

No branches or pull requests

2 participants