Re: 'Waiting on lock'

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: 'Waiting on lock'
Дата
Msg-id 20070530164934.GZ7531@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: 'Waiting on lock'  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: TOAST usage setting
Следующее
От: Enrico Sirola
Дата:
Сообщение: table partitioning pl/pgsql helpers