Hi, > Thanks for the patch! I haven't reviewed it yet, but since this is > a v19 item, please add it to the next CommitFest so we don't lose > track of it. > > Also, I think it would be better to split the addition of the wait event > and the introduction of exponential backoff in XactLockTableWait() into > separate patches. They serve different purposes and can be committed > independently. >
I've renamed and created two discussion threads and commitfest entries for these patches to allow independent evaluation. 1) Add new wait event to XactLockTableWait https://commitfest.postgresql.org/patch/5804/ https://www.postgresql.org/message-id/CABPTF7WZODAVPFxtn9ygA9d6zckkJbFG%3DSUtHdvk7ca%3DUTzSFg%40mail.gmail.com 2) Add progressive backoff to XactLockTableWait https://commitfest.postgresql.org/patch/5806/ https://www.postgresql.org/message-id/CABPTF7XmTrBp8S93a%2BzQ5M3FhLB6o8kWn9yQ1YnHJqTPT9dRYA%40mail.gmail.com There's some code overlap between XactLockTableWait() and ConditionalXactLockTableWait() in 2) that would warrant a shared helper function. However, introducing such a helper would create dependencies between the patches, defeating the purpose of keeping them separate. I’m very familiar with splitting patches and submitting them separately, so please let me know if anything here needs improvement. Best regards, Xuneng