| 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: | Whole Thread | Raw Message | 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 |