Stephen Frost wrote:
> * Tom Lane (tgl@sss.pgh.pa.us) wrote:
> > Stephen Frost <sfrost@snowman.net> 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