Thank you for your comment. Sorry for being late.
> SELECT FOR UPDATE SKIP LOCKED might skip a large number of rows,
> leading to
> a high volume of log messages from log_lock_failure in your current
> patch.
> Could this be considered unintended behavior? Would it be better to limit
> the number of log messages per query?
It is necessary to suppress the generation of a large amount of logs due
to SKIP LOCKED.
But I think that when using SKIP LOCKED, the locks are often
intentionally bypassed.
It seems unnatural to log only the first write or to set a specific
number of samples.
What do you think if we simply don't log anything for SKIP LOCKED?
Regards,