Postgres Pro
Downloads
Home   >   mailing lists

Re: Request: pg_cancel_backend variant that handles 'idle in transaction' sessions - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Request: pg_cancel_backend variant that handles 'idle in transaction' sessions
Date
Msg-id CAFj8pRCAh2tfu7r9K1cx0PWcS2PJ5mdjnqfP7soBJ2kOpVFJrg@mail.gmail.com
Whole thread Raw
In response to Re: Request: pg_cancel_backend variant that handles 'idle in transaction' sessions  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Request: pg_cancel_backend variant that handles 'idle in transaction' sessions  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view


2015-11-04 22:14 GMT+01:00 Joshua D. Drake <jd@commandprompt.com>:
On 11/04/2015 01:11 PM, Pavel Stehule wrote:


I am sorry, but I have a different experience from GoodData. The few
hours autovacuum is usual. So probably, there should be exception for
autovacuum, dump, ..

 But autovacuum and dump are not idle in transaction or am I missing something?

last Merlin's proposal was about transaction_timeout not transaction_idle_timeout

Regards

Pavel

JD


--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
New rule for social situations: "If you think to yourself not even
JD would say this..." Stop and shut your mouth. It's going to be bad.

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Request: pg_cancel_backend variant that handles 'idle in transaction' sessions
Next
From: Pavel Stehule
Date:
Subject: Re: Request: pg_cancel_backend variant that handles 'idle in transaction' sessions