From: | "Ing(dot) Marcos Ortiz Valmaseda" <mlortiz(at)uci(dot)cu> |
---|---|
To: | Lorenzo Allegrucci <lorenzo(dot)allegrucci(at)forinicom(dot)it> |
Cc: | pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [PERFORM] Strange performance degradation |
Date: | 2009-11-24 20:31:36 |
Message-ID: | 4B0C42A8.1040302@uci.cu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
Lorenzo Allegrucci escribió:
> 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.
>
>
Matthew replied to you of that way because this is not a good manner to
do this, not fot thr fact that you are crazy.
You can find better ways to do this.
Regards
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Yves F. Barbier | 2009-11-24 21:36:25 | howto escape my string |
Previous Message | Robert Haas | 2009-11-24 19:46:55 | Re: [HACKERS] Updating column on row update |
From | Date | Subject | |
---|---|---|---|
Next Message | Ing. Marcos Ortiz Valmaseda | 2009-11-24 20:37:38 | Re: RAID card recommendation |
Previous Message | Scott Marlowe | 2009-11-24 20:05:28 | Re: RAID card recommendation |