Skip to content

sql: implement sql stats compaction for clean up job #69302

Closed
Closed
sql: implement sql stats compaction for clean up job#69302
Labels
A-sql-observabilityRelated to observability of the SQL layerC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)X-staleno-issue-activity
@Azhng

Description

@Azhng
Azhng
opened on Aug 24, 2021

Currently, SQL Stats clean up job implements a very simple heuristics that deletes the rows with oldest aggregated_ts.

We would want to eventually implement compaction of the older rows by merging multiple rows into a single row. This means we can store more data for longer duration.

Jira issue: CRDB-9536

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-observabilityRelated to observability of the SQL layerC-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