Re: Interaction between "client_connection_check_interval" and "log_lock_waits" parameters

Alfonso Escribano <alfonso(dot)escribano(at)meteologica(dot)com> writes:
> When client_connection_check_interval has any value, and
> log_lock_waits is enabled, the postgresql log displays a message
> about lock waits with the frequency of
> client_connection_check_interval.

When log_lock_waits is enabled, we'll print that "still waiting"
message anytime ProcSleep is awoken from a wait-for-lock sleep,
if it's already waited deadlock_timeout or longer. Normally there
isn't much that would awaken such a process other than being granted
the lock. But here, you've set client_connection_check_interval
so short that that interrupt happens repeatedly while waiting.

Why in the world would you want client_connection_check_interval
as short as 10 ms? Sane values would probably be more like 10 s.

regards, tom lane