Skip to content

jobs: add a column and index for the type of job #68896

@ajwerner

Description

@ajwerner

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)X-staleno-issue-activity

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions