Re: [PERFORM] Strange performance degradation - Mailing list pgsql-general

From Lorenzo Allegrucci
Subject Re: [PERFORM] Strange performance degradation
Date
Msg-id 4B0BFC89.9000509@forinicom.it
Whole thread Raw
In response to Re: [PERFORM] Strange performance degradation  (Matthew Wakeling <matthew@flymine.org>)
Responses Re: [PERFORM] Strange performance degradation  ("Ing. Marcos Ortiz Valmaseda" <mlortiz@uci.cu>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: [BUGS] BUG #5211: invalid password
Next
From: Matthew Wakeling
Date:
Subject: Re: [PERFORM] Strange performance degradation