-
Notifications
You must be signed in to change notification settings - Fork 4.1k
jobs: add a column and index for the type of job #68896
Copy link
Copy link
Closed
Labels
C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)X-staleno-issue-activity
Description
Is your feature request related to a problem? Please describe.
We often want to look up jobs based on their type. It'd be great to index that.
Describe the solution you'd like
We should add a string column for the job type. On some level it'd be nice to make it a virtual computed column to extract the value from the proto. I worry that that might make writing job records more expensive because of the need to use crdb_internal.pb_to_json to express it.
Jira issue: CRDB-9346
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)X-staleno-issue-activity