| From: | Xuneng Zhou <xunengzhou(at)gmail(dot)com> |
|---|---|
| To: | Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com> |
| Cc: | Kevin K Biju <kevinkbiju(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Add progressive backoff to XactLockTableWait functions |
| Date: | 2025-06-17 13:50:12 |
| Message-ID: | CABPTF7VtMuWOadC0radEhc9dORYjKTdMUTkbQWbTCazW6Wo+3w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
On Sun, Jun 15, 2025 at 4:01 PM Xuneng Zhou <xunengzhou(at)gmail(dot)com> wrote:
> 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
>
When applying the v2 patch for benchmarking, warnings about trailing
whitespaces are emitted. I’ve removed them—please find the updated v3 patch
attached.
Best regards,
Xuneng
| Attachment | Content-Type | Size |
|---|---|---|
| v3-0001-Add-threshold-based-sleep-to-XactLockTableWait-functions.patch | application/octet-stream | 3.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ranier Vilela | 2025-06-17 13:54:45 | Re: Fix copy-and-past thinko (src/interfaces/libpq/fe-cancel.c) |
| Previous Message | Aleksander Alekseev | 2025-06-17 13:48:14 | Re: --enable-{debug,cassert} should also activate --enable-depend |