Re: Lock Wait Statistics (next commitfest)

Tom Lane wrote:
> Mark Kirkwood <markir@paradise.net.nz> writes:
>   
>> Yeah, enabling log_lock_waits is certainly another approach, however you 
>> currently miss out on those that are < deadlock_timeout - and 
>> potentially they could be the source of your problem (i.e millions of 
>> waits all < deadlock_timeout but taken together rather significant). 
>> This shortcoming could be overcome by making the cutoff wait time 
>> decoupled from deadlock_timeout (e.g a new parameter 
>> log_min_lock_wait_time or similar).
>>     
>
> The reason that they're tied together is to keep from creating
> unreasonable complexity (and an unreasonable number of extra kernel
> calls) in management of the timeout timers.  You will find that you
> can't just wave your hand and decree that they are now decoupled.
>
>   

Thanks Tom - I did wonder if there was a deeper reason they were tied 
together!

Cheers

Mark