Re: Add “FOR UPDATE NOWAIT” lock details to the log.

cca5507 <cca5507@qq.com>

From: cca5507 <cca5507@qq.com>

To: Fujii Masao <masao.fujii@oss.nttdata.com>, Yuki Seino <seinoyu@oss.nttdata.com>, Jelte Fennema-Nio <postgres@jeltef.nl>

Cc: pgsql-hackers <pgsql-hackers@lists.postgresql.org>

Date: 2026-05-14T05:27:58Z

Lists: pgsql-hackers

Attachments

v1-0001-Make-log_lock_failures-support-LOCK-NOWAIT.patch (application/octet-stream)

Hi,

> Yes, logging every autovacuum lock failure would be too noisy.
> I was thinking that log_lock_failure should apply only to LOCK TABLE ... NOWAIT,
> but per the current code, restricting it that way seems difficult.

I wrote a simple patch to support LOCK NOWAIT only.

Looking forward to your comments!

--
Regards,
ChangAo Chen