Re: Shared memory corrupted?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Shared memory corrupted?
Дата
Msg-id 3360.1067552059@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Shared memory corrupted?  (Jeff Boes <jboes@nexcerpt.com>)
Список pgsql-admin
Jeff Boes <jboes@nexcerpt.com> writes:
> [How would a plperl function that changes the local behavior of SIGALRM
> affect the backend?]

IIRC, SIGALRM is used for two things: one, to trigger a deadlock check
cycle if we wait too long for a lock (see deadlock_timeout), and two,
to implement statement_timeout.  If you are using statement_timeout then
I think it would be dangerous to mess with SIGALRM at all.  If you are
not, then I think it would be all right to modify the SIGALRM handler
setting locally, as long as you restore it to its original setting when
you are done.  Don't try to run any database access operations while you
have a nonstandard setting of the SIGALRM handler, though, or you risk
problems with deadlock checking.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Logging query durations into another table in PostgreSQL 7.4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: help from Portugal