Horton
Menu

Re: Add progressive backoff to XactLockTableWait functions

Xuneng Zhou <xunengzhou@gmail.com>

View thread
From: Xuneng Zhou <xunengzhou@gmail.com>
To: Fujii Masao <masao.fujii@oss.nttdata.com>
Cc: Kevin K Biju <kevinkbiju@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2025-06-15T08:01:12Z
Lists: pgsql-hackers

Attachments

Hi,

Attached is v2 of the patch to add threshold-based sleep to
XactLockTableWait functions.

Changes from v1:
- Simplified approach based on Fujii's feedback [1]: instead of exponential
backoff,
  we now sleep 1ms for the first 5 seconds, then switch directly to 1s
sleeps
- Reduced the threshold from 10 seconds to 5 seconds to avoid excessive
delays

[1]
https://www.postgresql.org/message-id/7c72c5d1-4d2f-46f7-8b68-dd96905f8c42%40oss.nttdata.com

Best regards,
Xuneng

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Allow logical decoding on standbys