How to kick out automatically stuck in queries

Поиск
Список
Период
Сортировка
От Együd Csaba
Тема How to kick out automatically stuck in queries
Дата
Msg-id 000701c3e966$b6c64910$230a0a0a@compaq
обсуждение исходный текст
Ответы Re: How to kick out automatically stuck in queries  (Kris Jurka <books@ejurka.com>)
Список pgsql-general
Hi All,
I'm wonder if there is any possibility to kick out automatically stuck in
queries after say 10 minutes or so?
I mean some kind of queries which calls eg. buggy functions with dead loops
or something similar.
Time to time I face such kind of problems which are solved automatically
after some hours/days.

Is there any options in config files or other settings to shorten this time?

I'm interested in limiting "dead" connections too. I mean frozen client
programs which leave the connection open.

(Server. RH 7.1, PG7.3.2 ; Client: Win98/ME/XP/2k)

Thank you,
-- Csaba Együd


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

Предыдущее
От: Richard Schilling
Дата:
Сообщение: Re: Very slow query - why?
Следующее
От: Michal Hlavac
Дата:
Сообщение: Array in stored procedure