idle_in_transaction_timeout
От
Vik Fearing
Тема
idle_in_transaction_timeout
Дата
Msg-id
538DC843.2070608@dalibo.com
Список
Дерево обсуждения
idle_in_transaction_timeout Vik Fearing <vik.fearing@dalibo.com>
Re: idle_in_transaction_timeout Abhijit Menon-Sen <ams@2ndquadrant.com>
Re: idle_in_transaction_timeout Vik Fearing <vik.fearing@dalibo.com>
Re: idle_in_transaction_timeout David G Johnston <david.g.johnston@gmail.com>
This patch implements a timeout for broken clients that idle in transaction. This is a TODO item. When the timeout occurs, the backend commits suicide with a FATAL ereport. I thought about just aborting the transaction to free the locks but decided that the client is clearly broken so might as well free up the connection as well. The same behavior can be achieved by an external script that monitors pg_stat_activity but by having it in core we get much finer tuning (it is session settable) and also traces of it directly in the PostgreSQL logs so it can be graphed by things like pgbadger. Unfortunately, no notification is sent to the client because there's no real way to do that right now. -- Vik
В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата: