yugabyte/yugabyte-db

[YSQL] Use bound key as lower bound in backward scan

Open

#25,938 opened on Feb 7, 2025

View on GitHub
 (0 comments) (0 reactions) (1 assignee)C (1,003 forks)batch import
area/ysqlgood first issuekind/enhancementpriority/lowstatus/awaiting-triage

Repository metrics

Stars
 (8,229 stars)
PR merge metrics
 (Avg merge 17d 21h) (92 merged PRs in 30d)

Description

Jira Link: DB-15251

Description

Helpful in reducing spurious read restart errors in backward scan.

Issue Type

kind/enhancement

Warning: Please confirm that this issue does not contain any sensitive information

  • I confirm this issue does not contain any sensitive information.

Contributor guide

Research direction
Investigate the backward scan implementation in the YSQL layer. Identify where bound keys are used and how they affect read restart errors. Look for opportunities to use the bound key as a lower bound in backward scans to reduce spurious read restart errors.
Tech stack
csql
Domain
databasebackend
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Needs investigation
Prerequisites
CGitDistributed Systems
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
20