Re: [PERFORM] Strange performance degradation

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-25 11:07:36
Message-ID: alpine.DEB.2.00.0911251106110.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:
> Bouncing the app will roll back the transactions.

Depends on the application. Some certainly use a shutdown hook to flush
data out to a database cleanly.

Obviously if you kill -9 it, then all bets are off.

Matthew

--
Software suppliers are trying to make their software packages more
'user-friendly'.... Their best approach, so far, has been to take all
the old brochures, and stamp the words, 'user-friendly' on the cover.
-- Bill Gates

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jason Armstrong 2009-11-25 11:59:19 Excluding null return values from functions
Previous Message Greg Smith 2009-11-25 07:44:03 Re: [GENERAL] How duplicate data produce when a UNIQUE index exite ?

Browse pgsql-performance by date

  From Date Subject
Next Message Glyn Astill 2009-11-25 11:09:32 Re: RAID card recommendation
Previous Message Scott Marlowe 2009-11-25 02:46:26 Re: RAID card recommendation