Re: Add “FOR UPDATE NOWAIT” lock details to the log. - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Add “FOR UPDATE NOWAIT” lock details to the log.
Date
Msg-id 7a8198b6-d5b8-4910-b41e-8d3efcbb015d@eisentraut.org
Whole thread Raw
In response to Re: Add “FOR UPDATE NOWAIT” lock details to the log.  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Responses Re: Add “FOR UPDATE NOWAIT” lock details to the log.
List pgsql-hackers
On 14.03.25 16:07, Fujii Masao wrote:
>>>> Instead, wouldn't it be simpler to update LockAcquireExtended() to
>>>> take a new argument, like logLockFailure, to control whether
>>>> a lock failure should be logged directly? I’ve adjusted the patch
>>>> accordingly and attached it. Please let me know what you think!
>>>>
>>>> Regards,
>>> Thank you!
>>>
>>> It's very simple and nice.
>>> It seems like it can also handle other lock failure cases by 
>>> extending logLockFailure.
>>> > I agree with this propose.
>>
>> Thanks for reviewing the patch!
>>
>> I've made some minor cosmetic adjustments. The updated patch is attached.
>>
>> Unless there are any objections, I'll proceed with committing it.
> 
> Pushed the patch. Thanks!

This patch added a setting "log_lock_failure", but the existing similar 
setting "log_lock_waits" has a plural.  Is there a reason for this 
difference?  Otherwise, maybe "log_lock_failures" would be better.




pgsql-hackers by date:

Previous
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: Replication slot is not able to sync up
Next
From: Daniil Davydov
Date:
Subject: Speedup truncations of temporary relation forks