Re: transaction timeout

Поиск
Список
Период
Сортировка
От Frank L. Parks
Тема Re: transaction timeout
Дата
Msg-id 42E66AFB.9040802@ezbizpartner.com
обсуждение исходный текст
Ответ на Re: transaction timeout  (Dr NoName <spamacct11@yahoo.com>)
Список pgsql-general
TIP 2: Don't 'kill -9' the postmaster



Dr NoName wrote:

>>The common view on this kind of thing is that if
>>your client is broken,
>>you need to fix it.
>>
>>
>
>The problem is, we can't fix the users, nor can we fix
>other software that our client has to interact with.
>There will always be occasional situations when a
>client gets stuck.
>
>
>
>>That said, I have seen some folks post about writing
>>a perl or shell
>>script that runs every x minutes looking for
>>connections that have been
>>idle for > a certain amount of time and kill the
>>backend associated with
>>it (sigterm, not -9...)
>>
>>
>
>what are the implications of killing a postmaster
>process?
>
>thanks,
>
>Eugene
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: don't forget to increase your free space map settings
>
>
>
>
>


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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: transaction timeout
Следующее
От: Richard Huxton
Дата:
Сообщение: Budget battery-backed ramdisk (Gigabyte i-RAM)