Stephen Frost wrote: > * Tom Lane ([EMAIL PROTECTED]) wrote: > > Stephen Frost <[EMAIL PROTECTED]> writes: > > > It'd be nice to have a NOTICE printed when a wait-on-lock takes longer > > > than a few seconds. > > > > It'd be relatively painless to make that happen as part of the > > deadlock-check timeout function, but that's typically only a one-second > > delay not a "few seconds". I think it'd likely be overly chatty. > > Yeah, I wouldn't want one per second.
It's not one per second, it's after one second (actually deadlock_timeout) has elapsed since you started to sleep waiting for a lock. If a deadlock is not detected the process won't be awakened again. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
