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
v2-0001-Add-threshold-based-sleep-to-XactLockTableWait-functions.patch
Description: Binary data