Add progressive backoff to XactLockTableWait

5806

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v9, Patch count: 1, First patch: +210−9, All patches: +210−9

Topic

Performance

Tags

Created

2025-06-08 14:39:01

Last modified

2025-08-01 15:08:46 (2 weeks ago)

Latest email

2025-08-08 11:06:12 (1 week ago)

Status

PG19-2 (2025-09-01 - 2025-09-30): Needs review

PG19-1 (2025-07-01 - 2025-07-31): Moved to different CF

Target version

Authors

Xuneng Zhou (dylanzhou)

Reviewers

Fujii Masao (masaofujii)Become reviewer

Committer

Fujii Masao (masaofujii)

Links

Emails

Add progressive backoff to XactLockTableWait functions: First at 2025-06-08 14:33:39 by Xuneng Zhou <xunengzhou at gmail.com>
Latest at 2025-08-08 11:06:12 by Xuneng Zhou <xunengzhou at gmail.com>
Latest attachment (v9-0001-Optimize-transaction-waiting-during-logical-decod.patch) at 2025-08-01 09:25:34 from Xuneng Zhou <xunengzhou at gmail.com>
    Attachment (v9-0001-Optimize-transaction-waiting-during-logical-decod.patch) at 2025-08-01 09:25:34 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Optimize-transaction-waiting-in-standby.patch) at 2025-07-30 15:42:10 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (head.svg) at 2025-07-28 11:29:23 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v7-0001-Replace-polling-with-waiting-in-XactLockTableWait.patch) at 2025-07-28 11:14:17 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (flamegraph.svg) at 2025-07-17 14:54:44 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v6-0001-Replace-polling-with-waiting-in-XactLockTableWait.patch) at 2025-07-14 15:36:19 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Replace-polling-with-waiting-in-XactLockTableWait.patch) at 2025-07-07 14:50:05 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-threshold-based-sleep-to-SnapBuildWaitSnapshot.patch) at 2025-06-23 16:32:29 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (hardware_counter_results.png) at 2025-06-17 14:02:49 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v3-0001-Add-threshold-based-sleep-to-XactLockTableWait-functions.patch) at 2025-06-17 13:50:12 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (1s-threshold.svg) at 2025-06-17 13:38:18 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v2-0001-Add-threshold-based-sleep-to-XactLockTableWait-functions.patch) at 2025-06-15 08:01:12 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (0001-Add-progressive-backoff-to-XactLockTableWait.patch) at 2025-06-08 14:33:39 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)

History

When	Who	What
2025-08-01 15:08:46	Xuneng Zhou (dylanzhou)	Moved from CF PG19-1 to CF PG19-2
2025-06-13 02:04:01	Fujii Masao (masaofujii)	Added masaofujii as committer
2025-06-13 02:03:58	Fujii Masao (masaofujii)	Added masaofujii as reviewer
2025-06-08 14:39:01	Xuneng Zhou (dylanzhou)	Attached mail thread CABPTF7XmTrBp8S93a+zQ5M3FhLB6o8kWn9yQ1YnHJqTPT9dRYA@mail.gmail.com
2025-06-08 14:39:01	Xuneng Zhou (dylanzhou)	Created patch record