| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, David Steele <david(at)pgmasters(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Request: pg_cancel_backend variant that handles 'idle in transaction' sessions |
| Date: | 2015-11-04 21:55:04 |
| Message-ID: | 20151104215504.GK3685@tamriel.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
* Joe Conway (mail(at)joeconway(dot)com) wrote:
> On 11/04/2015 01:24 PM, Alvaro Herrera wrote:
> > I agree with Pavel. Having a transaction timeout just does not make any
> > sense. I can see absolutely no use for it. An idle-in-transaction
> > timeout, on the other hand, is very useful.
>
> +1 -- agreed
I'm not sure of that. I can certainly see a use for transaction
timeouts- after all, they hold locks and can be very disruptive in the
long run. Further, there are cases where a transaction is normally very
fast and in a corner case it becomes extremely slow and disruptive to
the rest of the system. In those cases, having a timeout for it is
valuable.
David (adding him to the CC) actually developed a utility specifically
to identify what transactions are blocking what others and to kill off
other processes if they were running for too long and blocking higher
priority processes. It didn't matter, in that environment, if they were
idle-in-transaction or actively running.
David, please correct/confirm my recollection above.
Thanks!
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2015-11-04 22:07:47 | Re: Request: pg_cancel_backend variant that handles 'idle in transaction' sessions |
| Previous Message | Joe Conway | 2015-11-04 21:48:41 | Re: Request: pg_cancel_backend variant that handles 'idle in transaction' sessions |