| From: | Matthew Wakeling <matthew(at)flymine(dot)org> |
|---|---|
| To: | Denis Lussier <denis(dot)lussier(at)enterprisedb(dot)com> |
| Cc: | Lorenzo Allegrucci <lorenzo(dot)allegrucci(at)forinicom(dot)it>, pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Strange performance degradation |
| Date: | 2009-11-24 15:41:09 |
| Message-ID: | alpine.DEB.2.00.0911241527020.684@aragorn.flymine.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On Tue, 24 Nov 2009, Denis Lussier wrote:
> IMHO the client application is already confused and it's in Prod.
> Shouldn't he perhaps terminate/abort the IDLE connections in Prod and
> work on correcting the problem so it doesn't occur in Dev/Test??
The problem is, the connection isn't just IDLE - it is idle IN
TRANSACTION. This means that there is quite possibly some data that has
been modified in that transaction. If you kill the backend, then that will
automatically roll back the transaction, and all of those changes would be
lost.
I agree that correcting the problem in dev/test is the priority, but I
would be very cautious about killing transactions in production. You don't
know what data is uncommitted. The safest thing to do may be to bounce the
application, rather than Postgres.
Matthew
--
All of this sounds mildly turgid and messy and confusing... but what the
heck. That's what programming's all about, really
-- Computer Science Lecturer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexandra Roy | 2009-11-24 16:19:07 | Re: DBD::Pg 2.15.1 compilation failed |
| Previous Message | Lorenzo Allegrucci | 2009-11-24 15:32:25 | Re: [PERFORM] Strange performance degradation |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2009-11-24 16:07:59 | Re: DELETE performance problem |
| Previous Message | Grzegorz Jaśkiewicz | 2009-11-24 15:36:39 | Re: DELETE performance problem |