8000 ttl: use secondary index to scan if available · Issue #99003 · cockroachdb/cockroach · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
ttl: use secondary index to scan if available #99003
New issue
New issue
Open
Open
ttl: use secondary index to scan if available#99003
Labels
A-row-level-ttlC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)
@otan

Description

@otan
otan
opened on Mar 20, 2023

Today, row-level-TTL does a scan over all PRIMARY KEYs.

It can potentially skip this if it evaluates that ttl_expiration_expression can be reduced to a covering index. We should add a way for TTL to detect this, or a user option to force an index to be used to force TTL deletions to be faster.

Jira issue: CRDB-25648

Epic CRDB-18322

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-row-level-ttlC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions
      0