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 по дате отправления: