From: | Lorenzo Allegrucci <lorenzo(dot)allegrucci(at)forinicom(dot)it> |
---|---|
To: | |
Cc: | pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [PERFORM] Strange performance degradation |
Date: | 2009-11-24 15:32:25 |
Message-ID: | 4B0BFC89.9000509@forinicom.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
Matthew Wakeling wrote:
> On Mon, 23 Nov 2009, Lorenzo Allegrucci wrote:
>> Anyway, how can I get rid those "idle in transaction" processes?
>> Can I just kill -15 them or is there a less drastic way to do it?
>
> Are you crazy? Sure, if you want to destroy all of the changes made to
> the database in that transaction and thoroughly confuse the client
> application, you can send a TERM signal to a backend, but the
> consequences to your data are on your own head.
I'm not crazy, it was just a question..
Anyway, problem solved in the Django application.
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Wakeling | 2009-11-24 15:41:09 | Re: [PERFORM] Strange performance degradation |
Previous Message | Kurt | 2009-11-24 15:25:26 | exclude table from transactions |
From | Date | Subject | |
---|---|---|---|
Next Message | Grzegorz Jaśkiewicz | 2009-11-24 15:36:39 | Re: DELETE performance problem |
Previous Message | Thom Brown | 2009-11-24 15:19:23 | Re: DELETE performance problem |