Re: 'Waiting on lock' - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: 'Waiting on lock'
Date
Msg-id 20070530164934.GZ7531@tamriel.snowman.net
Whole thread Raw
In response to Re: 'Waiting on lock'  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
* Alvaro Herrera (alvherre@commandprompt.com) wrote:
> Stephen Frost wrote:
> > 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.

Ah, I see..  Actually, if it's just one NOTICE after one second, I think
that'd be fine.  Sorry, misunderstood what was going on.
Thanks!
    Stephen

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: TOAST usage setting
Next
From: Enrico Sirola
Date:
Subject: table partitioning pl/pgsql helpers