-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql/catalog/lease: improve historical descriptor lookups #70692
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)T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Description
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
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)T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)