[YSQL] Support deferred mode for writes - Githubissues

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.

https://www.yugabyte.com

Other

9.02k stars 1.08k forks source link

[YSQL] Support deferred mode for writes #24940

Open pao214 opened 6 days ago

pao214 commented 6 days ago

Jira Link: DB-14078

Description

Currently, we do not support DEFERRABLE for writes since single shard transactions are not handled. See #19407 for context.

Supporting yb_read_after_commit_visibility='deferred' will let us defer read time for both read and write txns. This will help resolve #23056

Issue Type

kind/bug

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

[X] I confirm this issue does not contain any sensitive information.