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