Skip to content

sql/catalog/lease: improve historical descriptor lookups #70692

@fqazi

Description

@fqazi

Historical descriptor looks up are done inefficiently, where we currently have to do multiple round trips across modification times to find a target timestamp. This involves reading them one by one until we find one that matches the target timestamp. We can take advantage of MVCC capabilities inside Corkoach to read historical descriptors more efficiently using a single ExportRequest.

Epic CRDB-10481

Metadata

Metadata

Assignees

Labels

C-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